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 Reindex
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 …
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.
Which is the performance killer: SELECT INTO or INSERT INTO?
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 »
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!
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.
Share custom solutions in the MinionWare Community Zone
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!