Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has some connection with the Holiday season for Christians. Fewer are aware that this song is […]
Tag: SQL Administration
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL 2005 box. I have updated it […]
Differential Restore Fail
We have all heard that backup is not complete until you test it by restoring it. We also know that part of a DR plan involves the testing of those backups through restores. I recently […]
Last Known Good CheckDB
Diligent DBAs like to check their databases for a little thing called corruption. Some of those DBAs are masterful at keeping records and logging that the database was checked and came up with a clean […]
A Trio of EachDB
When administering a larger database environment, sometimes one needs to perform repetitive tasks. Performing repetitive tasks becomes more and more painful (maybe even demoralizing) with the larger the number of databases that might exist on […]
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say if it could be more like […]
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times we inherit some things that are just plan annoying. Yet other times, we inherit things that may be annoying and we probably just haven’t discovered them yet.
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along – the transaction log on the primary […]
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then possibly a manager or client. Usually this comes up when evaluating for missing indexes or […]
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken on a new job. Suppose you […]