SQL Saturday #87 Report
I drove the over 250 miles from my home in Edwardsville, IL, to attend the SQL Server 87 in Louisville,...
2011-11-02
1,345 reads
Blog Posts
WAN Optimization Solutions–Input Needed Please!
I was just wondering if anyone has a WAN optimization solution as part of their infrastructure. I have a few...
2011-11-02
773 reads
10 More Days Until Inspiration! - SQLInspireNYC 2011
Can't believe we're ONLY 10 days out from what's shaping up to be quite an extraordinary awesome event! We've been...
2011-11-01
1,300 reads
Backup/restore/checkdb/shrinkfile progress
Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you...
2011-11-01
1,132 reads
Being an Effective DBA Remotely
Do not let the phrase “out of sight, out of mind” apply to you.
As Data Professionals a lot of us...
2011-11-01
1,145 reads
BI Pyramid (read categories of users in a BI solution)
Purpose of any business intelligence solution is to provide users information and enable them to make intelligent decisions that benefit their...
2011-11-01
825 reads
Fame and Social Media
Reading this post about Alton Brown from Good Eats triggered me to think on the topic. It looks like initially...
2011-11-01
472 reads
Fatal Error Emails This Morning…
So every morning I check my email on my phone. Normally, I don’t see any error emails from SQL Server...
2011-11-01
723 reads
Free Business Intelligence Workshop
If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are...
2011-11-01
1,684 reads
Get Inspired – SQL Inspire 2011 New York
Coming up next week is the SQL Inspire 2011 event in New York City. It’s an event with a number...
2011-11-01
1,683 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