SQLSaturday Advice - Scheduling
One of the things that I’ve seen cause a few headaches at SQL Saturday events is the scheduling. First, before...
2010-10-07
500 reads
Speaking at the Houston Techfest
I am heading down to Houston, TX to speak at the Houston Techfest this weekend. Being a Houston native makes...
2010-10-07
405 reads
VMWare vSphere database maintenance
I recently did a VMWare/SAN assessment for a client. The expressed reason, or the reason relayed to me (not always...
2010-10-06
3,938 reads
SQLSaturday #49 (Orlando) Is Right Around The Corner - Have You Registered?
As I write this SQLSaturday #49 in Orlando is right around the corner - October 16, to be exact. My friends...
2010-10-06
466 reads
Stop Forgetting the DAC
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
972 reads
SQL Saturday 58 Schedule Released
We technically released it on Monday but I didn’t want to blog about it for a couple days since we...
2010-10-06
748 reads
One Meel-ee-yon Posts
We crossed the 1,000,000 post mark on SQLServerCentral today and that’s very cool to me. A few others as well...
2010-10-06
431 reads
Connection Strings: Database Mirroring Failover Partner Setup & Sample Backup/Restore Preparation Script
After having setup my first SQL 2008 R2 Enterprise (build level 10.50.1702) database mirror as High Safety with automatic failover,...
2010-10-06
6,260 reads
So I Got Promoted, Now What? Get To Know Your Peers
[This is part four in a series of posts about how to effectively transition to your new role after being...
2010-10-06
806 reads
Upcoming October Events
During October I’ll be presenting at several online and in-person events
LocationDateSessionSQL Saturday #49 Orlando 2010Oct 16th ETL with PowerShellPASS PowerShell...
2010-10-06
862 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