Slides and Demos for #SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
495 reads
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate - XML. XML is so foreign to many DBAs. It's not relational and often...
2015-08-26
18 reads
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign...
2015-08-26
949 reads
The 30 minute rule
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule....
2015-08-26
671 reads
Slides and Demos for SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols including a rather fun live demo.
The slides and demo...
2015-08-26
9 reads
Speaking at SQLSaturday Oslo
This weekend, I’ll hop on a plane and fly over to Norway for SQLSaturday Oslo.
I’ll be delivering a session I...
2015-08-26
767 reads
Taking #PowerPivot to the Next Level
Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) and there is no doubt about...
2015-08-26
1,056 reads
The Log Chain
I ran across a question recently from someone that received a similar message to the one showed in this image:
In...
2015-08-25
1,279 reads
Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)
As I noted in my previous post, I am not a fan of scripting. In that post we set up...
2015-09-04 (first published: 2015-08-25)
1,313 reads
SQLSaturday & The Speaker Wait List
When a new SQLSaturday event is launched an email is sent to all the speakers who have opted in to...
2015-08-25
640 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