One for My SQL Sisters
Women, for the entire male half of the population, I apologize.
Those who know me well recognize, pretty easily, that I...
2013-08-30
1,788 reads
Professional Etiquette When Sending Mass Email – Use BCC:
<begin soap box rant>
Time and time again I find myself having to email people to remind them about how and...
2013-08-30
1,361 reads
Building a Better Litter Box
First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped...
2013-08-30
1,444 reads
Just Wow!! features
Over the years with each release I’m often impressed by some of the features contained in SQL server but every...
2013-08-30
1,331 reads
Fixing a Bug: DBCC CHECKDB data purity checks are skipped for master and model
Fellow MVP Paul Randal just blogged about an issue he has discovered with how the master and model databases are...
2013-08-29
1,736 reads
Data Mining with Excel Q&A
Thank you to everyone who attended my free webinar on August 29, 2013 where I talked about using the Data...
2013-08-29
2,882 reads
Resume hoarders
Unfortunately in my line of work as a consultant, I am contacted far too often by resume hoarders, who are...
2013-08-29
1,497 reads
Windows Azure SQL Database and Throttling
When I present on Windows Azure SQL Database, one of the biggest concerns comes up around throttling. Just the concept...
2013-08-29
1,537 reads
Before Asking for Help...
I have a standard rule that I use before going and bugging a co-worker or posting via social media/message forum about...
2013-08-29
1,886 reads
MDX #29–Co-authored MDX with SSAS 2012 Cookbook
I have been absent from this blog for the last few months. For those who have noticed, I’d like to...
2013-08-29
875 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