Congratulations to the New PASS Board Members (And Some Advice)
Just released on the PASS site is that news that Tom Larock, Jeremiah Peschka, and Brian Moran are the new...
2009-10-21
627 reads
I’m a Bingo Square!
If you meet me at PASS, you can win prizes!
OK, so maybe there’s a little more to it than that. ...
2009-10-21
715 reads
Birds Of a Feather Lunch
The PASS Summit agenda is shaping up and it’s already looking to be much busier than last year. The latest...
2009-10-21
560 reads
SQLSaturday #21 – Orlando Recap
In my previous post I discussed the week that led up to the SQLSaturday event. In this post I’ll tell...
2009-10-21
685 reads
Do You Trust Google?
I have a friend, he’s a technology guy and fairly savvy with hardware and software. We were talking recently and...
2009-10-21
872 reads
Wildcard – Match One Character using Underscore (_)
I was recently contacted by a developer with what I would consider to be a very simple question. How do...
2009-10-21
2,708 reads
Operations Manager Shell
I've started using SCOM 2007 R2, which has given me a chance to try out the Operations Manager Shell. The Ops Mgr Shell...
2009-10-21
1,018 reads
PASS Connector Editorial for October 21, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-10-20
542 reads
PASS Summit – My List of Tips
It’s easy to think of the Summit as just work, but I can tell you that you’ll have more fun...
2009-10-20
677 reads
SQL Server 2005 SP3 CU6 Released
Microsoft released Cumulative Update 6 for SQL Server 2005 SP3 yesterday (and the KB link is working today). This is...
2009-10-20
1,044 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