Speed up SQL Server backups with one word
Fast backups mean fast restores. SQL Server native backup compression makes that happen! Read on for the pros, the cons, and the how-tos.
Tech
Prevent the next data breach
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security. Consider: Uber in 2016 – Hackers downloaded more than 25 million drivers’ and customers’ personal information; the cover-up and resulting claims alone cost $148 million. Equifax …
Three big reasons T-SQL still beats the GUI
T-SQL Still beats the GUI 👊 The SQL Server Management Studio makes a lot of operations very simple. Creating a database takes three clicks. A new login is a minimum of two clicks. So why is it that we at MinionWare still write T-SQL over 90% of the time, instead of using the GUI? We …
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*.
Incoming: your SQL Server care package
We’re gifting you a few good things: MinionWare Office Hours, free enterprise software, and free things out in the wild. Plus pictures of puppies.
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 …
Protect your Environment with Real Enterprise Management
Contact our team at Sales@MinionWare.net for questions, demos, and trials. Databases aren’t well understood by folks outside of the data professional world. SQL Server especially has a nice-looking interface, which makes database administration look easy. It isn’t easy. So how does a small DBA team manage an enterprise of ten, or a hundred, or 500 …
Protect your Environment with Real Enterprise Management Read More »
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 …
Automate SQL Server error log alerting with Minion Enterprise
Minion Enterprise (ME) is our tool for auditing, managing, and alerting on SQL Server instances and servers. With ME, you can automate custom SQL Server error log searches! One of the features is the error log search alert. The Error Log Search module allows you to set up specific error log search terms in the dbo.ErrorLogSearch table. This …
Automate SQL Server error log alerting with Minion Enterprise Read More »