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 […]
2021-03-30
2,597 reads
With the addition of Python to Machine Learning Services in SQL Server 2017, you can now execute your Python code inside of SQL Server.
2020-11-13 (first published: 2019-04-18)
25,729 reads
Learn how you can create a database in the serverless tier in Azure.
2020-06-29
8,837 reads
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,808 reads
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,580 reads
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Comments posted to this topic are about the item Understanding the Internals of a...
Comments posted to this topic are about the item Preventing Trigger Execution
Ask SSC