Rebuilding the system databases
The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is...
2016-03-02
1,939 reads
Quick Folder Size with PowerShell
This is a fairly simple idea, and one I’m sure many people have done in the past. Personally, I have...
2016-03-02
1,295 reads
Cross-database queries in Azure SQL Database
A limitation with Azure SQL database has been its inability to do cross-database SQL queries. This has changed with the...
2016-03-02
713 reads
How do I grant someone the ability to create a stored procedure?
The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s...
2016-03-11 (first published: 2016-03-02)
2,324 reads
How to Use Parameters Like a Pro and Boost Performance
Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals...
2016-03-01
318 reads
SWITCHing IDENTITY in the Pub
I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY...
2016-03-01
672 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
8 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
10 reads
NULLs to Not NULLs
I have found many columns in many tables of many databases that are defined to allow NULLs but have non NULL...
2016-03-01
110 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an...
2016-03-01
119 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