Microsoft Most Valuable Professional – Data Platform for 2018-2019
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second...
2018-07-02
346 reads
Blog Posts
New at Simple-Talk: Principles of Data Protection
My latest article, Principles of Data Protection, has been published at Simple-Talk! I address the basic problem and how we...
2018-07-02
365 reads
SSMS reset window layout (Day 37)
SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless...
2018-07-02 (first published: 2018-06-20)
4,795 reads
Strings vs Identifiers
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,408 reads
DevOps Debugs the Demo
I had my 24 Hours of Pass session today, Database DevOps to Ensure Compliance, and my demo broke. At least,...
2018-06-29 (first published: 2018-06-12)
2,150 reads
Learning Goals –June 2018 Update
The June update for T-SQL Tuesday #97. I made a plan and it’s hard to stick to.
tl;dr – Very little done.
I...
2018-06-29
812 reads
Respectfully Responding
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,281 reads
Azure Data Lake Store Gen2
Big news! The next generation of Azure Data Lake Store (ADLS) has arrived. See the official announcement. In short, ADLS Gen2 is the combination of the current ADLS (now called...
2018-06-28
17 reads
Check instant file initialization and lock pages in memory options
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,662 reads
I’m Speaking At SQL Saturday Baton Rouge!
I am excited to announce that I have been selected to speak at SQL Saturday Baton Rouge (#749) on August...
2018-06-28
359 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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