Distributed AG
going though Allan Hirt’s 24 SQLPASS recording, he has explained the new feature of SQL Server Availability group you can get...
2016-09-19
386 reads
5 Must Haves Before You Start Consulting
Please join me at IT/Dev Connections on Oct. 12 at 8:00AM where I’ll be hosting a Birds of a Feather session “Moving to Independent Consulting” Bring your questions!*
Yes, an 8:00AM session in Las Vegas,...
2016-09-19
16 reads
5 Must Haves Before You Start Consulting
Please join me at IT/Dev Connections on Oct. 12 at 8:00AM* where I’ll be hosting a Birds of a Feather session “Moving to Independent...
2016-09-19
530 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)However, once the SQL instance is restarted this flag...
2016-09-19
149 reads
Azure IaaS Premium Storage Test
I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will...
2016-09-19
568 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this...
2016-09-26 (first published: 2016-09-19)
1,768 reads
Migrating to Azure SQLDatabase
Right now one of the hottest topics around the world is the cloud and the successful methods for the migration...
2016-09-18
713 reads
"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016
I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by...
2016-09-17
366 reads
Open Source PowerShell – Play by Play
What’s going on here? So last week you may have seen this picture on Twitter…it went a little crazy…and you may have been wondering what are we up to?...
2016-09-16
21 reads
Open Source PowerShell – Play by Play
What’s going on here?
So last week you may have seen this picture on Twitter…it went a little crazy…and you may...
2016-09-23 (first published: 2016-09-16)
1,684 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