Using SQL Server Change Tracking for Incremental Loads

Earlier this week I wrote about the basics of change tracking in SQL Server, and showed how to get started...

Where in the world are Jen and Sean?

Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...

Easy Installing .NET 3.5 for SQL Admins

Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.

This is a common problem and relatively easy fix for...

Migrate from on-prem SQL server to Azure SQL Database

This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.
In...

Querying Deadlocks From System_Health XEvent

It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is...

The Importance of a Full Backup in SQL Server

This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...

Change Availability Group Endpoint IP

I had someone email me and ask how they could change the IP address on their Availability Group Endpoint.  It’s...

Does an index scan always read the entire index?

No.
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a...

Microsoft & R Programming Session Materials & Resources Available

Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power...

Speaking at SQLSaturday Chicago

I’m happy to announce that my first public session of 2016 will be at SQLSaturday Chicago on March 5! I...