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*.
These five SQL tools are essential for 2020 Read More »
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
Minion Maintenance: Just make it go! Read More »
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
Ten minute SQL Server backup and maintenance Read More »
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
New “CheckDB Alert” script in the CZ! Read More »
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.
Code that writes code Read More »
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!
We just upgraded the Minion Maintenance suite! Read More »
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.
Your Service Level Agreement is a Disaster Read More »
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.
Integrity Checks are Useless* Read More »
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.
Webinar: Introducing Minion CheckDB! Read More »
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.
Database snapshots for everyone! Read More »