Get Involved – This Week In PASS
We’re all busy people. We have jobs, families, and responsibilities out the wazoo. Little Timmy needs to be picked up...
2011-12-05
730 reads
Blog Posts
Meme Monday - What I Want for Christmas from Microsoft
This Christmas if I could get one thing from Microsoft it would be recognition that DBA's are not developers. This...
2011-12-05
757 reads
Powershell and Dynamic SSIS (or any for that matter) Config files
As I imagine that the majority of people who are reading this will have some level of SSIS knowledge, I’ll...
2011-12-05
1,225 reads
Registration Open for SQLRally 2012 in Dallas
On my list of things to get done this week is register for SQLRally 2012 in Dallas. It’s a quick...
2011-12-05
502 reads
Resolutions: Outcome
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked...
2011-12-05
1,602 reads
SQL Server 2012 Developer Training Kit
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here). This...
2011-12-05
1,132 reads
Upgrading Denali CTP3 to SQL Server 2012 RC0
When I started looking into the upgrade path for this, I saw a couple of notes online about the fact...
2011-12-05
803 reads
WAN Optimization–Part 2
After installing the WAN optimization appliances on all of our main sites, we have liked what we’ve seen thus far....
2011-12-05
686 reads
What Every DBA Should Get For Christmas
What is a brilliant gift at Christmas for a DBA? I mean apart from having the day off…..
For those new...
2011-12-05
595 reads
Scaling SQL Server – SQL Saturday #104 Precon
I will be presenting a day long preconference session on Scaling SQL Server for SQLSaturday #104 on Friday, January 6,...
2011-12-04
874 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