2016-06-08 (first published: 2016-04-28)
913 reads
Scripts
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,057 reads
Replication-Quick way to determine the articles
Replication related script- quick way to determine the publication name, Article and column which are part of the different publications.
2016-06-06 (first published: 2016-05-09)
879 reads
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)
361 reads
2016-06-02 (first published: 2016-05-10)
974 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,071 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,268 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,391 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,493 reads
2016-05-25 (first published: 2014-03-06)
2,231 reads
Blogs
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
Forums
ALAMAT KANTOR BCA KCP Arundina Cibubur Telp:083831618008
WhatsApp:0838-3161-8008 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24, RT.2/RW.11, Cibubur,...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers