The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,963 reads
The SQL Professor
C-R-U-D The Basics
C-R-U-D The Basics
What is CRUD? Well, there are a lot of things I can think of when I use the...
2014-10-09 (first published: 2014-10-01)
8,140 reads
Passwords – A T-SQL Tuesday Topic
Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you...
2014-09-18
327 reads
SQL Prompt 6.4 – Get It
This guy looks just like me a few weeks ago only one difference…..he has hair!!! Okay seriously though, I felt...
2014-09-18
475 reads
What I Wish I Had Known Sooner…as a DBA
Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came...
2014-08-28
1,121 reads
ISPACs – Got To Love Em
Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back...
2014-08-20
599 reads
And Just Like That….Three Years
Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today...
2014-08-18
306 reads
T-SQL Tuesday #57 – SQL Family and Community
Maybe it is just me, but these monthly block parties seem to be coming around quicker and quicker as time...
2014-08-12
308 reads
SQL Prompt – The Power Within
*Photo by Red Gate
Come a little closer; no seriously come on over just a little closer as I don’t want...
2014-07-15
576 reads
T-SQL Tuesday #56 – Assumptions
Question: “What time is it?”
Answer: “T-SQL Tuesday time”
Question: “What time?”
Answer: “T-SQL Tuesday time”
“I can’t hear you?!?!?!”
That’s right; it’s that time...
2014-07-09
414 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