Can a Data Professional Be Organized?
“One of the advantages of being disorderly is that one is constantly making exciting discoveries.” While this quote is true...
2017-05-05 (first published: 2017-04-25)
1,433 reads
The SQL Professor
SQL Doc by RedGate
I recently was on a call where a technical unit indicated they did not receive any form of documentation around...
2017-04-24 (first published: 2017-04-19)
1,328 reads
T-SQL Tuesday #89 Invitation – The times they are a-changing
This month’s topic by Koen Verbeeck (B|T) is based around times that are a changing. To break it down somewhat...
2017-04-11
355 reads
Don’t Duck On Responsibilities
Being a data professional you assume a certain amount of responsibility. It often requires having the right attitude and an...
2017-04-17 (first published: 2017-04-10)
1,402 reads
Are You Wasting Energy?
Often times we as leaders within our respective shops tend to waste our time focusing on the wrong things. Think...
2017-04-06
380 reads
Is There A Threat Inside?
If you’ve been involved in technology for any length of time you are aware of outside threats to your network...
2017-04-05
375 reads
How I Became A…SQL Server Data Professional
Last night I saw a tweet from Matt Gordon (b|t); the topic caught my eye – “How I Became A…SQL Server...
2017-04-04
407 reads
What Is SQL Saturday?
I was recently approached and asked, “What is SQL Saturday? I actually get asked that question more times than not...
2017-04-03
394 reads
The Pen Cap
This post is for all you up and coming data professionals out there. Over the course of the last week...
2017-03-21
504 reads
A Letter To A Younger Yates
Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...
2017-01-31
693 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