SQL Homework – July 2018 – Create a SQL Agent Job

For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...

Azure SQL Elastic Pools – Moving Databases

If you read official Microsoft documentation about naming conventions for your SQL elastic pools, it is hard to find any...

Cloud Backup Comparison

I used to use Crashplan. This was about $150 a year, but I could to 5 machines. I used to...

Learning Goals –June 2018 Update

The June update for T-SQL Tuesday #97. I made a plan and it’s hard to stick to.
tl;dr – Very little done.
I...

Azure Data Lake Store Gen2

Big news!  The next generation of Azure Data Lake Store (ADLS) has arrived.  See the official announcement. In short, ADLS Gen2 is the combination of the current ADLS (now called...

Azure Data Lake Store Gen2

Big news!  The next generation of Azure Data Lake Store (ADLS) has arrived.  See the official announcement.
In short, ADLS Gen2 is...

I’m Speaking At SQL Saturday Baton Rouge!

I am excited to announce that I have been selected to speak at SQL Saturday Baton Rouge (#749) on August...

Minion Backup: Restore to another server

Minion Backup makes your SQL Server backups effortless, of course.  And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look...

Does a Primary Key always have stats_id 1?

Back to the SQL Server Basics with Wayne

The Myth
I recently was attending a presentation where the presenter stated that the...

Mastering Index Tuning–Day 1

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...