SQL Azure DW – What is it? How it works?

Azure DW what is it? Is it the same as SQL Azure but bigger? No. It is kind of…different. It is a full Cloud Service from Microsoft in the Microsoft Cloud (PaaS), multi-tenant, cloud-based data warehouse ‘Platform as a Service’ offering which elastically scales on demand. Separates storage and compute for elastic scale requirements regardless…


SQL Azure troubleshooting, some ideas and scenarios.

While I was working in a customer request about SQL Azure troubleshooting, I noticed sometimes when we compare the flexibility of SQL on premises tools and SQL Azure, we may feel we are kind of limited. The purpose of this post it is demonstrate something about SQL Azure troubleshooting, at least considering what is available…


Database Startup Times

Have you have ever wondered what your database is doing as it starts and works through the various stages (including crash recovery) up to the point when it is open and available for user connections? Maybe your database seems to take a long time, but you know it was cleanly shutdown so the number of…


Deconstructing Extended Event XML

In a recent engagement, I had need of an Extended Event to gather range scans on my target instance. The overall premise was to determine which queries were driving the large number of range_scans being reported by a recent health check. The target instance was a SQL 2008 R2 SP3 build. So… lets create an…