Salary Averages
I saw this posted on Twitter, yet another reason to have a variety of people you follow. Some very interesting...
2010-12-02
560 reads
December Question: What does it mean to be a Proactive DBA?
One of the things I promote in all my presentations is the importance of being a proactive DBA. Unfortunately, the...
2010-12-02
622 reads
SQL Craft Fair
Have you ever been “dragged” to a long weekend afternoon at a craft fair? Did it look something like this?
This...
2010-12-02
482 reads
Processing a Measure Groups Index Using SSMS
As I had mentioned in a previous blog (Creating and processing an Analysis Services partition), instead of processing an entire...
2010-12-02
1,271 reads
iPad Update
I updated the iPad tonight to iOS 4.2. I had no particular reason to upgrade, but I saw a few...
2010-12-01
542 reads
LiveWriter 2011
I recently upgraded to LiveWriter 2011 while upgrading to the final version of LiveMesh. After the upgrade I noted the...
2010-12-01
345 reads
RTFM365
Physicians have primum non nocere – a Latin phrase that means “First, do no harm”. (Thank you, WikiPedia.) I think for...
2010-12-01
596 reads
When Were The Statistics In SQL Server Last Updated?
When SQL Server receives a new query, the Query Optimizer undertakes the task of identifying a good plan to resolve the...
2010-12-01
692 reads
The Development DBA Role
The Development DBA role, though not as common as the more prominent DBA and Database Developer roles in the database...
2010-12-01
4,531 reads
Semi-Crippled
When it rains it pours.
Last week my Nano died. It won’t hold a charge, or at least it won’t...
2010-12-01
447 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