This is quick script to ascertain datafile headroom based on current size of the data in a file against the max size (which needs to be set for this to work!)
2017-05-02 (first published: 2017-04-19)
375 reads
A script to be used as part of development deployments where new databases are required, so as to provide standardisation.
2017-01-23 (first published: 2017-01-18)
448 reads
Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.
2016-06-09 (first published: 2016-05-05)
1,689 reads
An enhanced version of a script originally posted by Robert Pearl some time ago. It now takes into account changes in the tabelresults for CHECKDB in latter versions of SQL Server.
2016-05-04 (first published: 2016-04-20)
1,179 reads
This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!
2016-03-16 (first published: 2016-02-25)
1,100 reads
This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.
2016-03-15 (first published: 2016-02-25)
1,567 reads
A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.
2016-03-14 (first published: 2016-02-25)
824 reads
To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.
2016-02-18 (first published: 2016-02-04)
708 reads
Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.
2016-02-17 (first published: 2016-02-04)
1,754 reads
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
365 reads
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hi, I'm working on cleanup activity of deleting databases that aren't in use or...
Good morning campers! I'm hoping to pick your collective hive brain wrt Veeam /...
How do I disable all the indexes on the dbo.Logger table?
See possible answers