Emmitt Albright

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

SQLServerCentral Article

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 (6)

You rated this post out of 5. Change rating

2023-11-24 (first published: )

9,805 reads

SQLServerCentral Article

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, […]

You rated this post out of 5. Change rating

2019-10-24

7,862 reads

SQLServerCentral Article

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 […]

You rated this post out of 5. Change rating

2019-08-29

14,616 reads

Blogs

A New Word: Lookaback

By

lookaback– n.  the chock of meeting back up with someone and learning that your...

Azure Vulnerability Assessments

By

Regarding managing databases in the cloud, security should never be an afterthought. That’s where...

Speaking at the NYC Lunch and Learn–May 23

By

In a couple of weeks, I’ll be in New York City for the Redgate...

Read the latest Blogs

Forums

Deleting a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting a Database

Data Analyst AI tool

By Daniel Calbimonte

Comments posted to this topic are about the item Data Analyst AI tool

Removing Log Shipping

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing Log Shipping

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers