These five SQL tools are essential for 2020
The tech world is just beginning to adapt to the “new normal”, and we’re all adjusting. Your best toolkit for 2020 will include these five downloads, which you should get and install *today*.
Minion CheckDB
Minion Maintenance: Just make it go!
Minion Maintenance has some seriously thorough documentation, but some weeks you don’t have time to read the darn manual. When it comes to backups, CheckDB operations, and index maintenance, you just want it to WORK. So here’s the “just make it go!” guide to Minion Maintenance! Don’t have Minion Maintenance? Download! Download the latest Minion …
Ten minute SQL Server backup and maintenance
We’re going to set up backup, DBCC CheckDB, and index maintenance for 5 servers in 10 minutes. Note that doing the same thing for 50 servers would take the same amount of time! Why do backups and CheckDB and index maintenance? Backups make a copy of the data or log records. This is vital for …
New “CheckDB Alert” script in the CZ!
This is just to announce that a home-grown Minion CheckDB alert procedure is up and happy and live on the Community Zone! The purpose of this SP is to email an alert if any allocation errors or consistency errors were found in the last (@LastNDays) days. For use with Minion CheckDB. I recommend you save …
Code that writes code
Code that writes code is one of the best productivity tips I can give you. And no, I’m not talking about ORMs. I’m specifically talking about YOU writing a query, which writes one or more queries.
We just upgraded the Minion Maintenance suite!
Welcome to the next version of Minion Maintenance! Now you have a single installer for all three modules, plus new features and fixes for the entire backup and maintenance suite!
Your Service Level Agreement is a Disaster
As a DBA, you’re in charge of getting systems up and running quickly in the event of an emergency. This is all right and proper, right up until you start defining SLAs. Let’s see what went wrong.
Integrity Checks are Useless*
Integrity checks have become more and more important over the years, as companies store more and more data. This data is absolutely critical, so when corruption happens, it can break a company. But in all but the smallest shops, running any kind of integrity check is all but completely useless. Unless you have Minion CheckDB.
Webinar: Introducing Minion CheckDB!
Minion CheckDB will be available for download on February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on Wednesday, February 1 and on Friday, February 3 at 12:00 PM.
Database snapshots for everyone!
If you’re lucky enough to have SQL Server 2016, go on and upgrade to SP1….you get extra-lucky special database snapshots in any version! Oh what’s that? You don’t use snapshots? Well let’s see a couple of good use cases for them.