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)
391 reads
Scripts
2016-06-02 (first published: 2016-05-10)
1,021 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,096 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,287 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,424 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,526 reads
2016-05-25 (first published: 2014-03-06)
2,255 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,553 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,096 reads
Blogs
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Forums
Alamat BCA KCP Rangkasbitung Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Sunan Kalijaga No.21, RT.2/RW.7, Muara Ciujung Bar., Kec. Rangkasbitung, Kabupaten Lebak,...
Alamat BCA KCP Cilegon Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Raya Merak No.42, Ramanuju, Kec. Purwakarta, Kota Cilegon, DKI Jakarta 42411
Alamat BCA KCP Aneka Subur Jatake Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Boulevard Business Center Blok A No. 2, Kel, RT.001/RW.001, Gandasari, Kec....
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers