Thank you all for going Zero to Cube with me!
Hey there folks. I am so excited about the tremendous turnout at the 24 hours of PASS. There were so many...
2010-09-17
362 reads
T-8d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelveeight days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-17
595 reads
SQLSaturday #52 – Colorado Here I Come!
Well, I’ve been waiting to book hotel and rental car for SQLSaturday #52 – Colorado because I wasn’t sure if my...
2010-09-17
358 reads
I Don't Want to Share!
I know we were taught to share in kindergarten, but there are some things that should not be shared. In...
2010-09-17
576 reads
ACID
What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the...
2010-09-17
2,212 reads
Do You Have Influence? Part 2
I started writing on influence last week and promised some comments on how to build influence and credibility. There are...
2010-09-17
1,361 reads
Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that...
2010-09-16
3,114 reads
Going to SQL Saturday #46 in Raleigh, NC
So, after a rather hectic few months, I’m finally crawling back out of the hole I’ve been occupying and getting...
2010-09-16
765 reads
Denver SQL Server UG September meeting
For the past 1 1/2 years now we’ve been hosting two presentations each meeting. The first presentation is typically a...
2010-09-16
783 reads
See You at SQL Saturday #46 - Raleigh
EDIT: Updated to include a picture of me.
I'm headed up this weekend to speak at SQL Saturday #46 - Raleigh. This...
2010-09-16
827 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