SQL Server Agent Schedule Decoder
This script will break job schedules down into a readable format (msdb.dbo.sysschedules)
2010-01-06 (first published: 2009-12-16)
1,971 reads
Scripts
Find weak login passwords in your server
Use this script to search for SQL Server logins who use weak password
2010-01-05 (first published: 2009-12-16)
4,353 reads
Script to Compress Tables and Indexes
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
15,886 reads
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,972 reads
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,684 reads
2009-12-30 (first published: 2009-12-15)
1,062 reads
2009-12-23 (first published: 2009-11-26)
600 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)
491 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,263 reads
2009-12-18 (first published: 2009-11-26)
602 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Alamat Kantor BCA KCU Asemka Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Asemka No.27-30, RT.1/RW.6, Pinangsia, Kec. Taman Sari, Kota Jakarta...
Alamat Kantor BCA KCU Kalimalang Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec....
Alamat Kantor BCA KCU Rawamangun Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...