Creating a Serverless Database in Azure
Learn how you can create a database in the serverless tier in Azure.
2020-06-29
8,205 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
2,067 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
5,324 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
19,628 reads
Blogs
Fixing the PoSh Hotkey in ADS
By Steve Jones
I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted...
Daily Coping 28 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Simple Python question...
I have a table in SQL Server like this: CREATE TABLE #SymptomData ( ...
Regular expressions in script component
In one of our SSIS package we have a script component that validate a...
SSRS - Filtering data in a report
I have a dataset (Name, Product A Installed, Product B Installed, Product 3 Installed,...
Ask SSC