Script created by Syed Fahar Abbas. A Comprehensive Batch Script to: Verify/Request Administrator privileges and create a stable script copy. Grant NT AUTHORITY\SYSTEM database privileges and perform full SQL Server backup. Detect, or automatically download and silently install, WinRAR for compression. Compress the raw backup (.bak) into a high-compression RAR archive (.rar) and cleanup. Authenticate […]
2026-09-29
114 reads
This script creates a stored procedure that returns the following table size metrics in kilobytes, megabytes, and gigabytes for all tables in user-created databases (database ID > 4): Reserved space Used space Unused space Index size Data size
2026-09-14
56 reads
This script creates two stored procedures: One searches for the names of all user-created objects at the server level across all user-created databases (database ID > 4) based on a specified search expression. The other searches for column names in all user-created tables and views across all user-created databases (database ID > 4) based on […]
2026-09-09
50 reads
This script creates a table that will store the row counts of non-system tables and views across all user-created databases (database ID > 4) on the server, as well as a stored procedure that refreshes the row counts by recalculating them. The script uses the database ServerInfo to store the table and stored procedure. Replace […]
2026-09-04
70 reads
This script demonstrates step by step how to implement a dropped objects tracking flow. Important limitation to consider: The stored state of a dropped object is based on the most recent available snapshot and not necessarily on the state of the object immediately before it was dropped. The accuracy of the stored information depends on […]
2026-08-31
50 reads
The following script creates a procedure that returns a specified number of random columns and rows from a specified table or view. The number of columns and rows is determined by the @NumberOfColumns and @Rows parameters. The @RandomColumnOrder parameter specifies whether the selected columns are returned in random order or sorted by their ordinal position […]
2026-08-31
65 reads
This scripts creates a view containing data type information for columns in user-defined tables and views. It provides an overview of the data types in use and can help identify opportunities for data type optimization and standardization. The data types are formatted as they appear in Object Explorer in SSMS. For example, sysname is displayed […]
2026-08-25
67 reads
2025-12-29 (first published: 2025-12-25)
657 reads
This script will save your database permissions into a table.
2025-12-29
622 reads
This script is used to generate the output file as CSV format for list of server.
2025-11-03 (first published: 2025-10-20)
1,026 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
WhatsApp CS 628218520154 Ruko Atrium Blok E. 12-13, RT.5/RW.18, Sunter Agung, Kec. Tj. Priok,...
WhatsApp CS 628218520154 Jl. Bungur Besar Raya No.32 & 32A, RT.3/RW.1, Gn. Sahari Sel.,...
WhatsApp CS 628218520154 Jl. Cempaka Putih Raya No.118 B,C,D, RT.16/RW.3, Cemp. Putih Tim., Kec....
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers