Electronic Health Records – What’s the Big Deal? (Part 2)
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-10-28
1,875 reads
My Schedule for the PASS Summit 2009
For the most part, I have an easy schedule. I’ll be in the 600 hallway most morning after the keynote...
2009-10-28
730 reads
How Many Rows Have Changed?
One of the things that I've asked DBAs, and I see asked often, is how much does your data change?...
2009-10-28
2,488 reads
My Schedule at the Summit/Let’s Connect
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...
2009-10-27
1,214 reads
2009 PASS Community Summit and SQL Server Connections Conference, Both in November
If you will be attending either the 2009 PASS Community Summit in Seattle, WA, from November 2-5; or the SQL...
2009-10-27
443 reads
Get Your SQL Server Questions Answered at ASK.SQLServerCentral.com
While the SQLServerCentral.com forums have always been a popular way to get your SQL Server questions answered, and to participate...
2009-10-27
825 reads
SQL Server Standard, Volume 6, Issue #1
It’s alive! It’s alive!
That’s enough from Colin Clive.
It’ll be out for the Summit. SQL Server Standard lives again! Although, not quite in...
2009-10-27
714 reads
SQL University: Diving into Authorization
It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...
2009-10-27
6,151 reads
Four New Zealand Cities are Final Stops on 30 Day Speaking Tour
After making seven presentations in Australia, I headed to New Zealand where I made four presentations in four cities, on...
2009-10-27
490 reads
Deterministic Functions
Do you know what determinism is? It's something that comes up periodically in Books Online as various SQL objects require...
2009-10-27
1,841 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