Blog

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.

Read More

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.

Read More

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...

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

Using SQL Server OUTPUT Parameters

Let's talk about using SQL Server OUTPUT parameters!

Read More

Building Minion Community

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...

Read More

For the joy of the #SQLSummit: free #MinionEnterprise Licenses!

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.

Read More

The $2,000 cup of coffee

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...

Read More

SQL Server permissions issues destabilize environments

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.

Read More

Back up databases to multiple locations

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.

Read More

Backup the ResourceDB with 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.

Read More

Learn SQL Server OUTPUT Parameters

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...

Read More

Posts Navigation

Categories

Archives