How To Get A Free SQL Server Indexing Book – Week 1

Free indexing books, awesome!
Before I tell you how, lets start with what we are talking about here. If you weren’t...

How To Get A Free SQL Server Indexing Book – Week 1

Free indexing books, awesome! Before I tell you how, lets start with what we are talking about here. If you weren’t aware, last summer I worked with Grant Fritchey...

Reblog: Unexpected result with the File System Task

SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default...

Attendee Questions from My #24HoP Presentation

I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate...

Restore a SQL Server Database with Different Methods

Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a...

Showplan comparison

A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...

Showplan comparison

A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...

Showplan comparison

A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans...

Speaking at Downtown Chicago SQL Server User Group June 9th

I’m going to be speaking for the downtown Chicago SQL Servers User Group at 5:30pm on June 9th! I plan to...

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQL User Group