Mid-year update on my goals
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
375 reads
Shrinking the Log
It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to...
2009-07-07
1,853 reads
SQLSaturday Blog Launched
Since the beginning of SQLSaturday I’ve covered most of the news here on my blog, beginning this week I’ll be...
2009-07-06
467 reads
So Now I’m Gilligan, Finally
Okay I was tagged by Tim Mitchell on the Deserted Island scenario started by Tim Ford which goes like this:
So...
2009-07-06
494 reads
Object Grouping Best Practices: Using Schemas for Logical Separation
Originally written in French last year, now revised for you in my native language below:
You've probably all noticed a change...
2009-07-06
3,503 reads
Behind on Blogging
One of the things I recommend to people that are looking to get into blogging is that they write 10...
2009-07-06
356 reads
Presenting at SQL Saturday Baton Rouge
I'll be presenting two sessions at the SQL Saturday event in Baton Rouge on August 1. I'll be presenting a...
2009-07-06
491 reads
Recovering Missing Templates in Visual Studio
Recently I decided to expand my coding knowledge and picked up a Visual Basic book. I’ve been working in this...
2009-07-06
788 reads
Episode #3 It's All About The Tools TV Show
Russ Fustino from Microsoft just sent me the link to episode #3 that was filmed at SQLSaturday #14 in Pensacola....
2009-07-06
487 reads
Richmond SQL Server Users Group
Actually a combination meeting of the Richmond .NET and SQL groups, put together for me. They normally meet on consecutive...
2009-07-06
743 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