Notes from Jacksonville, Atlanta, and South Florida
Misc notes: Jax. Ice cream break in the afternoon is nice, but the waffle cones on site make all the difference, the smell is hard to miss! Jax. Rooms...
2019-06-14
24 reads
Query machine name of the sql server instance - the hard or the harder way
I was at a client where they are using non-Microsoft clustering technology to achieve the high availability of SQL Server instances....
2019-06-26 (first published: 2019-06-13)
1,752 reads
How Developers and DBAs Collaborate in a DevOps World (video)
You’re a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for...
2019-06-13
22 reads
Does the case statement short circuit?
Let’s start with definitions: CASE Statement: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc ... Continue reading
2019-06-13
537 reads
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
74 reads
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
17 reads
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
224 reads
As a DBA, how do I offload some of my work?
I don't have time for this “I am a DBA, I am busy, too busy. Developers keep pushing changes to production without me reviewing the code, and now I...
2019-06-13
17 reads
As a DBA, how do I offload some of my work?
I don’t have time for this “I am a DBA, I am busy, too busy. Developers keep pushing changes to production without me reviewing the code, and now I...
2019-06-13
285 reads
Simulating Load
I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot...
2019-06-27 (first published: 2019-06-12)
483 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