A Monumental Migration to SQL Server 2016 - Part 2

In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...

Automating like an Enterprise DBA

One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....

Automating like an Enterprise DBA

TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...

Point In Time Restore for Azure SQL Database

Point In Time Restore for Azure SQL Database
This article try to explain

Automatic backups services provided by Azure 
Backup retention periods
How to take the point in time database restoration

This database restoration...

Point In Time Restore for Azure SQL Database

Point In Time Restore for Azure SQL Database
This article try to explainAutomatic backups services provided by Azure Backup retention periodsHow to...

T-SQL Tuesday #110 – Automate All the Things

From a DBA's perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
The post T-SQL Tuesday #110...

T-SQL Tuesday #110 – Automate All the Things

Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...

Speaking at SQLSaturday Nashville – 815!

Speaking at SQLSaturday Nashville – 815!
I’m proud to announce that I will be speaking at SQL Saturday Nashvilleon January 12th 2019! And wow, 815 SQL Saturdays! This one won’t let you...

Speaking at SQLSaturday Nashville – 815!

Speaking at SQLSaturday Nashville – 815!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 12th 2019! And wow,...

What product to use to transform my data?

If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake.  And much of this...