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...
Friday, October 27, 2017

SQL Azure Databases - Active Secondary - Failover Groups - Part 4

›
150th Blog Post . So, the post involves video demo :) Previous posts on this series was about using "Geo Replication" to conf...
5 comments:
Wednesday, September 6, 2017

Dynamic Threshold for Statistic Update - SQL Server 2016

›
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statist...
Sunday, September 3, 2017

DBCC CloneDatabase for SQL Server 2012

›
Dear All, In case you are wondering, title of the post is not a typo :) DBCC CloneDatabase is going to be available for SQL Server 2012 :...