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 :...
Monday, August 28, 2017

Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

›
Dear All, Very happy to share the 8th interview of # DataChannel . Dr. Leila Etaati MVP, MCT from New Zealand discusses Machine Learni...
Friday, June 9, 2017

SQL Azure Databases - Active Secondary - Failover - Part 3

›
Continuing on the series on SQL Azure Databases - Active Secondary , this post will explore the task of failing over to secondary. Fai...
Saturday, May 27, 2017

SQL Azure Databases - Active Secondary - How to connect? - Part 2

›
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier , this post will cover how to connect to a a...
Thursday, May 11, 2017

Find the number of rows for a value, without querying the table

›
Dear all, Being a DBA, developers approach me with questions like can you run this query for me in production? Select * FROM [d...
4 comments:
Sunday, May 7, 2017

SQL Azure Databases - Active Secondary - How to configure? - Part 1

›
Dear all, I have taken the azure dive at last :) In case if you are new to azure, azure is the Microsoft cloud platform service, offeri...
1 comment: