Home
You get all SQL Server good maintenance practices through a single main stored procedure, from backups to optimizations and database check integrity.
YourSqlDba stemmed from the need to provide to my customers' part-time DBAs a free tool that help them to perform reliable database maintenance good practices.
It comes as a single big SQL script, that creates a database called YourSqlDba, that contains all the SQL code related to the tool.
This is all about it. A database with a script that contains a main stored procedure that handles all maintenance tasks easily and effortessly. Fancy database names filter, helps YourSqlDba main procedure to handle selectively new databases. Filtering masks can be very generic, as long as you use a database naming scheme that helps deduce databases usages, which usually govern very much the maintenance required for them.
Selecting type of maintenance to perform is just a matter of setting parameter values of YourSqlDba main stored procedure.
Last of all, and not the less, YourSqlDba makes available, through SQL Server database mail, a report on all on its activities, and reports especially on problems that may arise, it a more catching way than the usual daily maintenance reports. It also memorizes all queries to detail maintenance actions on each object through internal YourSqlDba database tables. It is one of its many stenghts, steemmed from the fact that SQL Server own maintenance plan are poor when it come to problem reporting.
The next question that may arise in your DBA mind is how it behaves and/or where do I get to du set up.