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 »
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 »
There are many ways to kill performance in a script or stored procedure. However, not many think about the possibility that adding columns to a temporary table can kill performance. Here, I’m going to show you how a simple design decision – using INSERT vs ALTER TABLE – can have a huge impact on your procedure
Which is the performance killer: SELECT INTO or INSERT INTO? 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 »
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 »
The Minion backup and maintenance modules are free, and completely open. So it’s really easy for our target audience (DBAs) to write their own queries, alerts, reports, and whatever else they could possibly need. And now, they can share those solutions online at the MinionWare Community Zone. We can’t wait to see what’s next!
Share custom solutions in the MinionWare Community Zone Read More »