Emmitt Albright

I have been working with SQL Server for more than 10 years as a database developer and report writer.

Comparing Two Execution Plans

This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]

5 (4)

2021-03-30

2,846 reads

Fixing MLS Python Services to Load the Runtime

Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]

2019-10-24

2,889 reads

Key Rotation in TDE

Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used. It's […]

2019-08-29

6,709 reads

Blogs

Goal Progress for April 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Daily Coping 7 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 6 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Best way to automate password reset of sql account

By adrob39

I'm looking to have a timer job every 90 days that runs a ps...

RO-AG With Mirror On Different Compat Level

By oogibah

Good Morning Gentlemen, We have a  2014 SQL Server that is in a read...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers