Searching Column Name in All Tables
Use this script to search for a specific column name in all tables in a current database.
2010-01-01 (first published: 2009-12-09)
1,983 reads
Scripts
Automated SQL Job to Backup Database(s)
Automate All Database Backups with this script. handle full, diff, and log backups.
2009-12-31 (first published: 2009-12-15)
2,701 reads
2009-12-30 (first published: 2009-12-15)
1,081 reads
2009-12-23 (first published: 2009-11-26)
653 reads
Reset count for all alerts
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
528 reads
Synchronize several stored procedure between two servers
Synchronize source code between two servers for multiple stored procedures
2009-12-21 (first published: 2009-11-26)
2,298 reads
2009-12-18 (first published: 2009-11-26)
630 reads
2009-12-17 (first published: 2008-07-13)
1,872 reads
Synchronize all stored procedures between two servers
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,224 reads
2009-12-14 (first published: 2007-10-19)
1,372 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Alamat BCA KCP Batu Ceper Telp:0821°8200°233
Telp/Wa 628218200233 Kawasan Pusat Niaga Terpadu Blok A No. 8 F, Jl. Daan Mogot...
Alamat BCA KCP AEON Mall BSD Telp:0821°8200°203
Telp/Wa 628218200203 AEON Mall BSD City Ground Floor Unit G-80, 81 & 81A, Jl....
Alamat BCA KCP Raya Serpong Telp:0821°7555°651
Telp/Wa 628217555651 Jalan Raya Serpong 06, RT 008 RW 02, Pondok Jagung, Serpong Utara,...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers