Why You Should Care About Microsoft APS and Azure SQL Data Warehouse

Last week, I gave a presentation about SQL Server’s data warehouse capabilities, and specifically about APS (Analytics Platform System) and...

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to...

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to...

Create a SQL Azure Database–Old Portal

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Generating Estimated Plan and the Plan Cache

Does generating an Estimated Plan cause that plan to be loaded into the plan cache?
No.
 
What? Still here? You want more?...

Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table

Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...

Buffer Pool Extension in SQL Server 2014

I guess many have heard the phrase «640K ought to be enough for anybody», which Bill Gates is mistakenly thought...

Data corruption in SQL Server 2012 and 2014 when rebuilding indexes online

When I hear the discussion about causes of data corruption in SQL Server, I always mention bugs in the operating...