10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
24 reads
Blog Posts
Bring Your Own Key to Azure SQL Database TDE New UI
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key....
2018-06-12 (first published: 2018-06-05)
1,912 reads
Getting Started with Mssql-cli tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-06-12
265 reads
I’m published at Simple-Talk!
My first article has gone live at Simple-Talk! Thanks to Aunt Kathi for the opportunity!
Detecting Data Breaches
I’m also still writing...
2018-06-12
337 reads
It’s Azure T-SQL Tuesday #103
I’m slightly surprised that there haven’t been more invitations about Azure, with the main development branch of SQL Server being...
2018-06-12
331 reads
More Changes to PoshSSDTBuildDeploy - DeployReport Information
Hello!
This is going to be a short one because I’ve been working hard all evening on this, and frankly I’m a little tired. But I’ve made a change to...
2018-06-12
43 reads
Power BI Custom Visuals Class (Module 106 – Ring Chart MAQ Software)
In this module you will learn how to use the Ring Chart by MAQ Software. The Ring Chart is similar...
2018-06-12 (first published: 2018-06-04)
2,272 reads
Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class
Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...
2018-06-12
20 reads
Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class
Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...
2018-06-12
27 reads
Temporary Post Used For Theme Detection (84fc925e-61af-4c19-b75b-9b99021b1635 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e4f4591b-a7d5-4be4-937e-8d6230ec51d8 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2018-06-12
937 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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