PASS Elections 2013
Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this...
2013-09-24
849 reads
One Year Later
Wow! It’s been one year since I launched my blog, and my how things have changed.
Accomplishments Over the Past...
2013-09-24
712 reads
Poor Microsoft Doesn’t Understand What Tablets Are For
That’s the title of an article i came across this morning in Slate.com. I am not a big fan of...
2013-09-24
662 reads
SQL Server Hardware and Storage Links
Being a DBA is more than just knowing about SQL: it’s about the technology which SQL runs on, which includes servers and storage. I’m naturally interested in hardware, so...
2013-09-24
22 reads
My upcoming Speaking Schedule
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Over the next...
2013-09-23
783 reads
PowerShell – Restart Service – Local or Remote Machines
This post is to start the services of local or remote computers. It also check for all its dependent services....
2013-09-23
1,589 reads
VMware vSphere 5.5 Enhancements That DBAs Should Care About
Last month at VMworld, VMware announced the upcoming release of their virtualization suite, vSphere 5.5. As you all know, I...
2013-09-23
1,233 reads
Encryption and Full Text Search at The Mandalay Bay (DevConnections)
It’s just a week until Dev Connections. This is one of the great conferences for the hybrid technology person, with...
2013-09-23
689 reads
Last Weeks Top “Reading” Links #50
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-09-23
1,000 reads
PASS Elections
I as well as many others have a decision to make on who I am voting for the PASS Board...
2013-09-23
587 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