Creating a Serverless Database in Azure
Learn how you can create a database in the serverless tier in Azure.
2020-06-29
7,469 reads
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
A Quick Start to Running Python Code in SQL Server
With the addition of Python to Machine Learning Services in SQL Server 2017, you can now execute your Python code inside of SQL Server.
2019-04-18
18,900 reads
Blogs
On Dynamic Ports, Named Instances, and Firewalls
By Will Assaf
Recently I had a client and their vendor trying to configure a firewall for...
Daily Coping 13 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Last Week Reading (2020-07-12)
By Kamil
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....
Forums
Help needed in getting all AD users and groups
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
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.
How to find the last occurrence of '\' in the following string and get...
Ask SSC