Is Microsoft attempting to "de-skill" IT Pros in its attempt to increase its Cloud business?
When I first heard of the MCM program termination discontent, I reacted by sympathizing with my fellow Database Professionals but...
2013-09-05
971 reads
A T-SQL query to get current job activity
I recently had the task of collecting job activity for the purposes of turning it into a report for some...
2013-09-05
16,091 reads
Job: SQL Server DBA (Permanent UK)
A client of mine are looking for a good SQL Server DBA on a permanent basis, the location is flexible...
2013-09-05
712 reads
A Better Braindump (#mcm #mcmstudy)
I’m studying my butt off for the soon-to-be-deprecated Microsoft Certified Master cert’s lab – and the three unfinished prerequisite certs I’ve...
2013-09-05
711 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter. The abstract is...
2013-09-04
719 reads
Azure Capabilities Expand
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
637 reads
SQL Server events in the UK September 2013
Sorry things are a little later this month…Summer (like the MCM program) may be coming to an end, but we...
2013-09-04
688 reads
How to become a better, well-rounded SQL Server DBA
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
People are sometimes...
2013-09-04
873 reads
Why Blog?
The main reason I started blogging was a community thing. I leeched from the community to get me to where...
2013-09-04
1,014 reads
Is Microsoft's Certification Program Value Microsoft's Fault?
I'd be interested if anyone says, "No," to that question. Gail Shaw raised a few points in this post about...
2013-09-04
2,004 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