Sunday, December 31, 2017

Azure SQL Database - Backup

›
Most of you must be knowing that backup in Azure SQL Database fully automatic. After the database is created and the database is automatica...
28 comments:
Saturday, December 23, 2017

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 e...
2 comments:

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 ...
23 comments:
Saturday, December 2, 2017

Data Channel Interview - 09 - Mr.Madhivanan on Best Practices in TSQL Programming

›
Dear All, Very happy to share the 9th interview of #DataChannel. Mr.Madhivanan Ramachandran, 10 time Microsoft MVP Award winner and a Dat...
3 comments:
Wednesday, November 29, 2017

Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2

›
Continuing from the introduction written over here , let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins....
Saturday, November 25, 2017

Tricks - Copy T SQL Result to Excel

›
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most ta...
Sunday, November 12, 2017

Adaptive Query Processing and Automatic Tuning - Introduction - 1

›
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons fo...