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,079 reads
2009-12-23 (first published: 2009-11-26)
651 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,297 reads
2009-12-18 (first published: 2009-11-26)
629 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
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
Alamat Telp BCA KCP Cirendeu +62 838-4945-0961
Wa:083849450961 Jl. Raya Cirendeu No.14, Cireundeu, Kec. Ciputat Tim., Kota Tangerang Selatan, DKI Jakarta...
Alamat BCA KCP Altira Sunter Telp 0821 6277 387
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, RT.9/RW.11, Sunter Jaya,...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers