Finding Missing Values from an Array
Missing NumbersToday a developer came up to me and wanted help solving a problem he was running into with a...
2010-10-13
1,064 reads
Checking The Event Log With PowerShell
Good administrators work really hard so that they don’t have to work really hard. Well, that’s an oxymoronic statement if...
2010-10-13
811 reads
Birds of a Feather Lunch at PASS 2010 Summit
The volunteers at PASS (especially Mike Walsh) have organized another “Birds of a Feather” lunch event on Tuesday, November 9...
2010-10-13
705 reads
PASS Summit Birds of a Feather Lunch
The absolute biggest part of the PASS Summit is the one thing that most people don’t take advantage of, networking....
2010-10-13
604 reads
S–3–X Talk Week: Love, HR, and Sexy Shoes
We’re conducting S–3–X Talk Week here at the MidnightDBA #Awesomesauce blog. In the tradition of the first S-3-X week blog,...
2010-10-13
876 reads
MVP Birds of a Feather Lunch at PASS Summit 2010
The almost final list just posted by Mike Walsh, 50+ MVP’s will each host a lunch table at the PASS...
2010-10-13
546 reads
Take The Survey from the SQL Server Connection Team
Saw this today, a survey posted to the SQL Protocols blog by Principal Group Program Manager Raghu Ram. I took...
2010-10-13
536 reads
Tools I Use to Scan for SQL Servers
I was having a Twitter conversation on this yesterday and naturally Aaron Nelson (blog | twitter) popped in with "PowerShell!" I like PowerShell,...
2010-10-13
15,736 reads
Return of Index Analysis Part 3
Let’s Anaylze An Index!Time for part three of my continued Index Analysis query. The previous posts in this series are:...
2010-10-13
989 reads
SQLSaturday#59 Interview Series Continues...with Steve Jones
SQLSaturday#59 Speaker Interview Series #2
Yesterday, on the PearlKnows Blog, I kicked off the SQLSaturday#59 Speaker Interview Series, with a bit...
2010-10-13
823 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