SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...
2011-12-08
848 reads
Data Usage
This is somewhat shocking to me. I was reading about ATT’s decision to throttle some high bandwidth users, and there...
2011-12-08
1,113 reads
The #Meme15 On Social Networking
During a recent conversation with a few fellow bloggers, the conversation turned to how we each got started with blogging...
2011-12-08
479 reads
SQL Server A to Z – XML
I can’t believe it’s already December. This year has just flown by. The rush of holiday events has already started,...
2011-12-08
1,753 reads
DBA in Space: Behind the Scenes—Question 14
Part 1 of Question 14—The question.Part 2 of Question 14—The follow up to the question.This is a continuation of my...
2011-12-08
718 reads
SQL Saturday 99 – Data Education
Welcome to the third of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-08
482 reads
When training is just that good!
I have the privilege of attending SQL Skills Immersion Event week one in Atlanta GA this week. My expectations were...
2011-12-08
508 reads
Book Review: Sixkill
Sixkill is the 39th Spencer novel, and the last that was written by Robert Parker before his death. The plot...
2011-12-08
650 reads
Junior DBA
At our company we have two DBAs to take care of all the databases in the production and QA. It...
2011-12-08
1,514 reads
The Day-to-Day Tasks of the Average DBA
DBAs (Database Administrators) perform many different tasks, and one way to explain what a DBA is, is to describe the...
2011-12-08
2,179 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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