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.
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.
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...
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.
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.
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.
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.
Let's talk about using SQL Server OUTPUT parameters!
What makes a really successful technology? Along with actually having a strong technology that's robust, flexible, and code-able, you also have to foster a strong community. Users come together and help each other in ways that continue to surprise me and that's why we're thrilled to be...
You want free licenses of Minion Enterprise. Yes, you do! Weâ€™re at the PASS Summit, and thatâ€™s as good a reason as any to give away more licenses of Minion Enterprise. We want EVERYONE to enjoy the benefits of set-based enterprise management! Better sign up now.
What's the most expensive cup of coffee you've ever bought? Was it $6, $8, $15? Try a cup of coffee that cost $2,000. And worst yet, it was made at home. Let me tell you a tale of disaster recovery...
The number one cause of instability in most database environments is SQL Server permissions. Specifically the problem is that people have more access to systems than they should. Let me walk you through a typical lockdown.
Many IT shops need multiple copies of a backup saved to multiple locations, for disaster recovery, or for testing and quality assurance. Here we discuss the difference between backup mirror and copy, and explain how to implement each in Minion Backup.
It's easy to backup the ResourceDB with Minion Backup. And while it's not a setting (yet), it only takes one step. Here, we show you exactly how to do it.
There are plenty of sites out there that show the syntax of using SQL Server OUTPUT parameters in your SPs, but not many take the time to explain the syntax in detail, or even why you should care. Here I'm going to show you why OUTPUT parameters are...