Generate RESTORE DATABASE Script without Using CMDSHELL
Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.
2016-08-31 (first published: 2014-12-10)
3,987 reads
Query to find tables with Forwarded Records
Use below query to find tables that need to be optimized based on number of forwarded records.
2016-06-16 (first published: 2016-05-05)
588 reads
Fix Orphan Users for Instance Migration
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,587 reads
Script to configure Log File Size for Large DBs
Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,228 reads
Disk Space Alerts Based on Threshold Value
This script will drop a mail for sql drives if space on drives is below set threshold value. Log drives with 15 and data files drives with value of 10% as threshold value of free space.
2015-11-19 (first published: 2015-10-27)
2,689 reads
Copy Latest Backups from Backup Path
This script is useful to copying latest backup files from job Backup path during Instance/Database Migration
2015-01-29 (first published: 2014-12-15)
977 reads
Script to remove Backup Files except Recent One for Same Day
This script is useful to remove SQL backup files except latest one for same day from Backup Path.
2015-01-26 (first published: 2014-12-12)
1,102 reads
Dynamic Script to Generate Backup Script
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,299 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts