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...

Use SSMS with a Different Windows Account – Back to Basics

Runas should be a very common tool in the toolbox of all IT professionals - not just Data Professionals. Learning how to test different accounts is essential to being...

Use SSMS with a Different Windows Account – Back to Basics

One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows...

Check instant file initialization and lock pages in memory options

Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...