Common SQL Server Mistakes – Equals NULL
One thing that I don’t see a lot, but it still happens with people new to SQL Server is the...
2010-10-13
21,799 reads
TSQL Tuesday #11: Messages and the Clammy Seduction of the Print Statement
Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.
TSQL Tuesday #11: Misconceptions in SQL Server
This...
2010-10-12
1,015 reads
Why do I contribute to the SQL Server Community?
As an active speaker and volunteer in the SQL Server community I am often asked why do I do it? ...
2010-10-12
550 reads
TSQL Tuesday Misconceptions in SQL Server
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...
2010-10-12
1,078 reads
Slides and Demo from Midlands PASS Presentation - October 12, 2010
Here are the slides and demo script from the presentation on Understanding SQL Server Query Processing.
2010-10-12
553 reads
Lightening Talk On Covering Indexes Ka-chow! Ka-chow!
“I’m a precision instrument of speed and aerodynamics.” That’s what Lightning McQueen tells Mater when they first meet in Cars....
2010-10-12
405 reads
Lightening Talk Ka-chow! Ka-chow!
“I’m a precision instrument of speed and aerodynamics.” That’s what Lightning McQueen tells Mater when they first meet in Cars....
2010-10-12
1,325 reads
Speaker Gift for SQLSaturday #49
We’ve tried to move away from shirts as a speaker gift, most speakers have them so we only get them...
2010-10-12
510 reads
SQL Saturday New England: The New Date
The real world can get in the way of important things like SQL Saturday. In the case of SQL Saturday...
2010-10-12
570 reads
A Trio of Table Variables
So, it’s the second Tuesday of the month again, and it’s time for T-SQL Tuesday again. This month it’s hosted...
2010-10-12
1,275 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