PASS Nominating Committee Update
Today PASS released a bunch of stuff for the upcoming election including the attributes of an “ideal candidate”. We put...
2016-06-22
422 reads
Names From the Past
Can you guess what all of these people have in common?
Shawn WeisfeldJoe HealyBarry RalstonTrey JohnsonJon WinerWes DumeyDonnie ReynoldsKevin JacobsJoseph MemmoBrian...
2016-06-22
487 reads
I am speaking at SQL Saturday Indy 2016!
That’s right, back-to-back roll. I will be presenting my second SQLSaturday session at the upcoming Indianapolis #530, Saturday, Aug. 13th, 2016. My session, Stretch Database and Managed Backups: Cloud...
2016-06-22
12 reads
I am speaking at SQL Saturday Indy 2016!
That’s right, back-to-back roll. I will be presenting my second SQLSaturday session at the upcoming Indianapolis #530, Saturday, Aug. 13th,...
2016-06-22
145 reads
SQLSaturday Orlando 2016 Call for Speakers Closes July 17, 2016
We’ve advanced the closing date for the SQLSaturday Orlando call for speakers to July 17. That’s to give us time...
2016-06-22
398 reads
Not a Great Search
Tldr: A bit of a rant. I’m not spending a bunch of time crafting this.
I have mixed feelings about searching...
2016-06-22
501 reads
Starting ReadyRoll with an Existing DB
I’ve been working with ReadyRoll quite a bit the last few months, and wanted to start putting out some information....
2016-07-01 (first published: 2016-06-22)
1,588 reads
Microsoft finally got SQL setup right!
This past week, Microsoft revealed that SQL Server 2016 will be available in June. Exciting news indeed! With that said,...
2016-06-22
478 reads
SQL Server Security Series, part 1
In the first entry in this SQL Server security series, we will demonstrate a brute force attack against SQL Server...
2016-06-22
493 reads
Database snapshots
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating....
2016-06-22
584 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