List instances hosting similarly named databases
Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names
2016-06-03 (first published: 2016-05-06)
385 reads
Scripts
2016-06-02 (first published: 2016-05-10)
1,012 reads
Translate function for SQL Server
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
1,092 reads
Run a specific query across all servers using powershell
Run a specific query across all servers using powershell
2016-05-31 (first published: 2015-03-06)
3,283 reads
Testing all Linked Servers in all SQL SERVER servers with Powershell
This Script shows how to use powershell to test all linked servers in all SQL SERVER servers. previously registered in a txt.
2016-05-27 (first published: 2009-04-01)
3,418 reads
Report Alerts from SQL ErrorLog
Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]
2016-05-26 (first published: 2015-05-15)
2,523 reads
2016-05-25 (first published: 2014-03-06)
2,251 reads
Execute All .SQL Script easily
If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.
2016-05-24 (first published: 2015-05-18)
2,551 reads
Generate script to rebuild indexes in a database
Generate script for reconstgruir ena database indexes
2016-05-23 (first published: 2014-03-20)
2,652 reads
Split string using multiple delimiters
This script is used to split the string using multiple delimiters
2016-05-18 (first published: 2014-10-09)
6,091 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