Master_Views: master_objects, master_tables, etc
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of...
2016-06-01 (first published: 2016-05-23)
1,588 reads
The Road to SQLSaturday Orlando – 2016
This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress...
2016-05-23
429 reads
How Do I Change My Domain Password on Windows Server 2012?
As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers...
2016-05-23
5,986 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an Microsoft Data Platform MVP, MCM, part of the...
2016-05-20
10 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an...
2016-06-01 (first published: 2016-05-20)
2,205 reads
SQL Server Exercise for Data Warehouse Candidates
Background
Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire...
2016-05-30 (first published: 2016-05-20)
2,604 reads
Simple Way to Decrypt SQL Server Stored Procedure
When stored procedures are created in SQL Server, their entire text body is accessible to all those who have the...
2016-05-20
51,683 reads
Objects dependency check up
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many...
2016-05-20
419 reads
Objects dependency check up in SSMS
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s)...
2016-05-20
10 reads
Objects dependency check up in SSMS
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s)...
2016-05-20
12 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