Emmitt Albright

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

1,818 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

4,863 reads

Blogs

On Dynamic Ports, Named Instances, and Firewalls

By

Recently I had a client and their vendor trying to configure a firewall for...

Daily Coping 13 Jul 2020

By

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

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Read the latest Blogs

Forums

Help needed in getting all AD users and groups

By Mysterio

I have very limited knowledge with server management. I need to extract AD users...

What do you like for third party database backup/restore for SQL server & Azure

By melissa.hamilton

Hi all, my company currently uses SQL server native tools to perform nightly backups. ...

Find the last occurrence of \ character and get the left of string.

By sathwik.em91

How to find the last occurrence of '\' in the following  string  and get...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers