Notes from SQLSaturday #227 in Charleston
My first time in Charleston! Quick notes:
Made the drive with the family in 7 hours, not bad, and easily the...
2013-10-13
564 reads
SQL Server Partitioning: Getting Started
Partitioning is a feature that has been around since SQL Server 2005. It allows for users to split a table...
2013-10-12
2,683 reads
What Does The PASS Community Mean To You?
In less than 72 hours I'll be in Charlotte with over 3,000 of my closest SQL Server friends for the...
2013-10-11
716 reads
Reblog: October 4 to October 10
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-11
609 reads
PASS Attack!
It’s Friday. Tomorrow I present two sessions at SQL Saturday #238 – Minnesota. Then I take off for PASS Summit 2013...
2013-10-11
721 reads
I’m 40 and I’ve Had Enough
I’m not old, but I did turn 40 today. If you ask my kids, they are likely to say that...
2013-10-11
812 reads
Slides for SQL Server Internals Presentation with PASS DC Chapter
For those of you that attended yesterday and are interested in the slides, you can download them here. Thanks! Topic:...
2013-10-11
747 reads
If you buy a Hyundai, don't expect BMW results
This sort of ties in to my last post on denying reality.
Managing expectations is the most important thing to success...
2013-10-11
700 reads
Carolina Whistle Stops
The SQL Crazy train continues chugging along this month. The next two whistle stops are back to back in the Carolinas. The first stop is coming up in just...
2013-10-11
10 reads
Carolina Whistle Stops
The SQL Crazy train continues chugging along this month. The next two whistle stops are back to back in the...
2013-10-11
667 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