Database Drops in SQL 2012
In the previous article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who dropped...
2015-07-01
32 reads
Database Drops in SQL 2012
In the previous article on this topic (which can be read here), I discussed the problem of having a database get...
2015-07-06 (first published: 2015-07-01)
2,081 reads
Microsoft SQL Server MVP
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year....
2015-07-01
1,240 reads
How to Grant limited permissions to create views in another schema?
How to Grant limited permissions to create views in another schema?
In SQL Server 2005 and 2008R2 you can grant permissions...
2015-07-08 (first published: 2015-07-01)
3,272 reads
Reporting Services Subscriptions in “Pending” Status
Ran into this issue today. A subscription that had been working failed. Looking at it in the RS portal it...
2015-07-01
9,788 reads
What is Polyglot Persistence?
Polyglot Persistence is a fancy term to mean that when storing data, it is best to use multiple data storage technologies,...
2015-07-01
1,368 reads
Speaking at PASS Summit 2015 & SQL Live360! - WaterOx Consulting
Reading Time: 2 minutesSeattle, here we come! I am excited, and honored that it is...
The post Speaking at PASS Summit...
2015-07-01
409 reads
Updating Extended Properties on a Table
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-07-01
1,970 reads
SQL Saturday Field Notes
As you walk toward the entrance the door opens and there stands a volunteer smiling welcoming you in. You make...
2015-07-01
230 reads
SQL Saturday Field Notes
As you walk toward the entrance the door opens and there stands a volunteer smiling welcoming you in. You make...
2015-07-01
493 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