Minion Backup: Restore to another server
Minion Backup makes your SQL Server backups effortless, of course. And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look...
2018-06-28
468 reads
Blog Posts
Notes From SQLSaturday Houston 2018
Various and possibly amazing notes:
Because I waited too long the best flight I could get was into George Bush instead...
2018-06-28
408 reads
Query Store Usage and Adaptive Plan Tuning Usage
Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:
Brent Ozar...
2018-06-28 (first published: 2018-06-17)
2,341 reads
Replication Max Text Length
Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce...
2018-06-28 (first published: 2018-06-20)
11,052 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool to get into, write queries, do some monitoring, tuning,...
2018-06-28
788 reads
Use SSMS with a Different Windows Account – Back to Basics
Runas should be a very common tool in the toolbox of all IT professionals - not just Data Professionals. Learning how to test different accounts is essential to being...
2018-06-28
303 reads
File Growth Rate – The GUI Lies
If you are like me, you use the SSMS GUI for various things. Though, I tend to use scripts for...
2018-06-27 (first published: 2018-06-15)
1,182 reads
Revoke the permission(s) before dropping the server principal
As a remote DBA I often have to log in to client systems for a fixed amount of time and...
2018-06-27 (first published: 2018-06-15)
14,169 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool...
2018-06-27
1,699 reads
Update your production servers and stop making excuses about it
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...
2018-06-27
376 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