SQL Server Management Studio Setup and Configuration

This is my first #entrylevel blog post. The challenge identified by the tags #entrylevel and #Iwanttoshare was started by Tim...

SQL Server Principals – Back to Basics

A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
Related Posts:

Easy Permissions Audit January 21, 2019

SQL...

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