Microsoft SQL Server

Speaking at the Spanish Virtual PASS Chapter

Title : Recuperación de desastres y soluciones de alta disponibilidad con SQL Server Event link: http://globalspanish.sqlpass.org/Inicio.aspx?EventID=1846 Event description: “Esta presentación presenta las soluciones de recuperacion de desastres (Disaster Recovery) y alta disponibilidad (High Availability) con SQL Server y ofrece escenarios creativos por usar las soluciones para reportages (Reporting), BI y almacen de datos (Datawarehouse). ”…

Pythian at PASS 2014

General_PASS_Blog_Graphics

Join us in Seattle for SQL PASS Summit 2014—planned by and for the Microsoft SQL Server community—where some of our very own will be presenting. You’ll notice that PASS has a funny way of scheduling speaking sessions, so both of our experts are presenting at the same time. Also be sure to visit us at…

On the Road with Luan

For the months of September, October, and November, Microsoft SQL Server MVP Luan Moreno will be touring Brazil, Europe, and EUA for various speaking engagements. He’ll be sharing his SQL Server knowledge and insights during SQL Saturdays, conferences, and virtual conferences. “Pythian is a company that values and truly supports employees in sharing their knowledge at community events,”…

In-Memory OLTP – ORDER BY Behavior Clause Using Range Index

Some clients are beginning to thinking about the possibilities of migrating some disk tables to In-Memory tables — this process is not so simple. Migrating tables requires a new mindset as some things changed in the SQLOS and SQL Serve architecture. It is extremely important to know about the differences, the scenarios that can be…

Data Profile: Better Knowing Your Data

Have you ever needed to start a new data analysis project or create a report for the business users querying a database you never worked before? Or simply know the data distribution of a database to create better indexing strategies? Working as a consultant, I constantly face this challenge where I have to work with…

Azure Storage: Creating, Maintaining, and Deleting SQL Server Backups

This post covers how to create, monitor, maintain, and automatically delete SQL Server backups. What is Azure Storage and why should you use it? Microsoft Windows Azure is Microsoft’s cloud offering for offsite storage. It offers the ability to seamlessly enable massive storage, Virtual Servers, SQL Server database instances, and many other options without having…

How to Configure an Azure Point-to-Site VPN – Part 3

This blog post is the last of this series and which will demonstrate how to configure a Point-to-Site VPN step-by-step. In my first blog post, I demonstrated how to configure a virtual network and a dynamic routing gateway. This was followed by another post about how to deal with the certificate. Today we will learn how to…

SQL Server Replication Quick Tips

There is a time in every SQL Server DBA career where a mail came in with a “replication is not working, please check” message. This article is intended to provide with quick tips on how to handle common replication errors and performance problems in a one way transactional replication topology Oh boy, there is a…

Microsoft PowerBI: News from WPC

During the Worldwide Partner Conference (WPC) that happened last month, Microsoft made public some of the new functionalities that we can expect to see soon on Microsoft PowerBI. If you were on another planet in the last few months, and didn’t heard about PowerBI for Office 365, I’ve included a list of the set of tools…

Page 2 of 5012345...102030...Last »