Active Directory Users and Computers (ADUC) - A Handy Tool for DBAs
Active Directory Users and Computers (ADUC) is a very common tool over on the Active Directory side. As the name...
2010-10-14
8,566 reads
Speaking at SQL Saturday #49 Orlando, Florida
After making the trip last weekend to Houston for Houston Techfest with the kids I am off again, but this...
2010-10-14
565 reads
Working the Door
You know those guys that work the door at clubs, seperating the wheat from the chaff, culling the herd, Choosing the Slain, sifting...
2010-10-14
714 reads
SQLSaturday#59 Speaker Interview Series - with Kevin S. Goff
SQLSaturday #59 Speaker Interviews Series #3 - Kevin S. Goff
You can catch all the speaker interviews on this upcoming event, on...
2010-10-14
920 reads
SQL Saturday Advice – Speaker Communication
Recently I was at an event and a speaker wasn’t able to make a session. There was a minor scramble,...
2010-10-14
755 reads
4-Weeks to PASS Summit 2010 Countdown – Lunch
There are now 4 weeks until the PASS Summit and a few times now I’ve discussed ( 1, 2, 3 ) some...
2010-10-14
786 reads
SQLSaturday #49 Reminder & Notes on Event Prep
First, a reminder that our fourth annual SQLSaturday is this Saturday, October 16, 2010, at Seminole State College in Lake...
2010-10-14
601 reads
List Indexes For Database using TSQL
A while ago, I showed you how to find out what indexes were on a table using the GUI. Today,...
2010-10-14
35,340 reads
Join us at PASS 2010!
Please join as at the 2010 global summit for the Professional Association for SQL
Server in Seattle. The conference is the...
2010-10-13
494 reads
Speaking at SNESSUG
I’ll be presenting tonight at the Southern New England SQL Server Users Group (SNESSUG). The topic is “Using DMVs as...
2010-10-13
690 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