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.
Articles
Managing Backup Issues in Availability Groups
Let’s talk about some of the challenges that DBAs face when managing backups with Availability Groups. Then we’ll talk about solving these issues with Minion Backup.
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.
Proper Backup Alerting
Today I’d like to talk about two topics that get overlooked quite often, the “backups” to the backup, so to speak. First up: proper backup alerting. And second, missing backup recovery.
What Really Causes Performance Problems?
Every IT shop has its problems with performance: some localized, and some that span a server, or even multiple servers. Technologists tend to treat these problems as isolated incidents – solving one, then another, and then another. This happens especially when a problem is recurring but intermittent. When a slowdown or error happens every so often, it’s far too easy to lose the big picture.
Some shops suffer from these issues for years without ever getting to the bottom of it all. So, how can you determine what really causes performance problems?
Announcing Minion CheckDB release date!
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup and Minion Reindex…and it’s coming in early 2017.
Avoid this sp_executesql issue
If you don’t use this feature very often, you can come across some unexpected sp_executeSQL issues. This time we’ll look at an sp_excuteSQL output issue.
The set-based enterprise: a force multiplier for IT
Set-based enterprise (n.) – An environment in which you can administer multiple servers as if they were one server. Minion Enterprise makes your shop into a set-based enterprise, and you’re going to love it.
Important: MS16-136 Security Patch
Microsoft has released what looks like a pretty important security patch for SQL Server: MS16-136. Right now seems like an OUTSTANDING time to look that over and see if it applies to your systems.
Using SQL Server OUTPUT Parameters
Let’s talk about using SQL Server OUTPUT parameters!