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)
395 reads
Scripts
2016-06-02 (first published: 2016-05-10)
1,026 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,103 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,292 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,434 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,531 reads
2016-05-25 (first published: 2014-03-06)
2,256 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,558 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,655 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,105 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers