SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,902 reads
Scripts
Backup Database Size calculation Report - Monthwise
The script helps to calculate the size of the backup of the databases monthwise. This will help to understand the database growth rate from the backup file if we do not have any data collection utility to find the exact details of the DATA File growth.
2012-09-24 (first published: 2012-08-20)
1,639 reads
Run SQL Hosted VBS Script from SQL
This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.
2012-09-20 (first published: 2012-08-21)
1,010 reads
Show all Objects used by Linked Server
Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.
2012-09-17 (first published: 2012-08-23)
1,082 reads
Query to check whether my Full Database Backup is running fine.
The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.
2012-09-13 (first published: 2012-08-25)
1,251 reads
ASCII Character Groups in String
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,073 reads
2012-09-07 (first published: 2007-11-15)
3,510 reads
2012-09-04 (first published: 2008-04-24)
1,165 reads
Find Mismatched Views and Stored Procs
Find missing and mismatched views and stored procs between 2 Databases
2012-09-03 (first published: 2008-05-29)
1,737 reads
Insertion Query Creation of a Table in Milliseconds
This script helps you to constitute insertion procedures for tables in a millisecond.
2012-08-30 (first published: 2007-11-05)
2,340 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
BCA KCP Millennium Centennial Telp:0821-8200-233
Telp/Wa 62 8218200233 Gedung Millennium Centennial Ground Floor Unit C, Jl. Jenderal Sudirman No.Kav....
Alamat BCA KCP Pasar Cipulir Telp:0821-8200-203
Telp/Wa 62 8218200203 Komp. Cipulir Permai, E Jl. Ciledug Raya No.9, RT.9/RW.5, Ulujami, Kec....
Alamat Kantor BCA KCP Manhattan Tlp:0821-8200-233
Telp/Wa 62 8218200233 The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers