This is a list of all the articles posted on this blog about user defined reports that help in database administration.
Disk Space Usage For Analysis
The following implementation helped me in analyzing the disk space usage. There are many ways to get the available disk space in the server and using SCOM we can get the alerts whenever the disk space reaches below the threshold levels. This implementation fetches the available space information and stores it in a table on
Database Restore Information with Restore Start and Completed Date Time
Following points to be accomplished – Get all the databases restoration information From all reporting, staging or testing environments Information about when the database restoration started and completed If the restoration is a full restore or differential When the backup file was ready Above said information is to be received through Email in a tabular
Big Data and SQL 