Thoughts on Query Performance with TDE enabled
Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance overhead of 2-4%. That doesn’t sound like very...
2018-05-23
2,095 reads
Blog Posts
Virtual Log Files: 200 or 1000?
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...
2018-05-23
485 reads
Azure PowerShell – List Data Center Locations
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do...
2018-05-22
66 reads
Bring Your Own Key to Azure SQL Database TDE
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure...
2018-05-22
29 reads
Converting JSON to SQL Server CREATE TABLE Statements
Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...
2018-05-22
22 reads
Converting JSON to SQL Server CREATE TABLE Statements
Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...
2018-05-22
14 reads
Power BI Custom Visuals Class (Module 102 – Slim Data Bar KPI Visual)
In this module you will learn how to use the Slim Data Bar KPI Visual. The Slim Data Bar KPI...
2018-05-22 (first published: 2018-05-09)
2,361 reads
SQL Saturday – Dallas – May 2018
I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to...
2018-05-22
210 reads
SQL Saturday Iowa City Precon June 22
I’m extremely proud to announce that I have been selected to present an all-new preconference training session on Friday, June...
2018-05-22
288 reads
Update Oddness for SQL Server
I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I...
2018-05-22
331 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers