SQL and NOT SQL: Best of 2017

With only a few days left in 2017, I thought it would be fun to do a year in review post.  Below you'll find some of my top 5...

SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations

In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot...

Accessing AzureML models through SQL Server in-database R services

In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In...

T-SQL Tuesday #97 – My learning plan

This month’s T-SQL Tuesday is hosted by…er..yours truly. I picked a topic that usually comes up for me every December...

What is the Automatic Plan Correction in SQL Server 2017?

SQL Server 2017 brings a new interesting feature, that might be a game changer in some environments. I’m talking about...

Adaptive Query Processing - Adaptive Joins - Plan resue - 3

Continuing on the series on Adaptive Query Processing covered over here, this post would cover what happens to adaptive joins when plans are reused.

To give a...

Adaptive Query Processing - Adaptive Joins - Plan resue - 3

Continuing on the series on Adaptive Query Processing covered overhere, this post would cover what happens to adaptive joins when...

Adaptive Query Processing - Adaptive Joins - Plan resue - 3

Continuing on the series on Adaptive Query Processing covered over here, this post would cover what happens to adaptive joins when plans are reused.

To give a...

My Interview at Data Platform Geeks 2017

Dear All,

Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As...

My Interview at Data Platform Geeks 2017

Dear All, Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As always a terrific experience to hangout, interact and...