Delete Backups Older than N Days
SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED,
IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION.
2019-05-03 (first published: 2015-03-16)
5,609 reads
Scripts
Delete SQL Instance name from default backup location
IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.
2019-05-03 (first published: 2015-03-23)
726 reads
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2019-05-03 (first published: 2015-06-03)
1,655 reads
Enable Email Notification to all SQL Jobs
If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.
2019-05-03 (first published: 2016-09-20)
1,062 reads
Execute All .SQL Script easily
If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.
2019-05-03 (first published: 2015-05-18)
2,526 reads
Extract default & Named Instance from @@servername
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2019-05-03 (first published: 2015-04-15)
1,155 reads
Extract SQL Server Key details
Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.
2019-05-03 (first published: 2014-10-13)
6,121 reads
Extracting only Deadlock details from ErrorLog
If you want to extract only deadlock details, use the script.
2019-05-03 (first published: 2014-12-03)
3,889 reads
Find no of records in each table in database (against Clustered Index)
If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.
2019-05-03 (first published: 2014-12-26)
1,513 reads
2019-05-03 (first published: 2016-11-22)
798 reads
Blogs
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
The Burrito Bot: AI-Powered Search in SQL Server 2025
A while back I posted about a couple of side projects that I’ve been...
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers