MinionWare president Sean McCown released an entire training course on SQL Server clustering for FREE over at MidnightDBA.com! This series is meant to show you how to create a clustered environment in Virtual Machines, so you can test them and learn clustering. Series videos: Intro to Clustering– This video starts the process off by explaining what clusters …
Minion Backup makes your SQL Server backups effortless, of course. And even better, it makes your restores effortless! Today we’ll look at configuring a common, repeatable scenario: take the latest backup of MyDB from ProdServer1 and restore it to DevServer1.
Minion Enterprise provides you the ability to script and clone permissions in a variety of ways. Today we want to script out all permission for DB1 on the dev server, “Dev1”.
Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean SQL Server instances. So how do we go about this? Well, there’s the easiest way – you knew I’d be mentioning Minion Enterprise, right? – and then there’s the hard way. The easiest way If you have Minion …
When was my last backup / CheckDB / index maintenance? Read More »
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is slow.
I’m going to let you in on the secret of the best method to get what you want out of your DBA: Ask clearly. Include all details.
I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought I’d share. What I HAD was a set of DELETE statements that might or might not have been executed recently: DELETE FROM dbo.Table1 WHERE val = 1 DELETE FROM dbo.Table2 WHERE val = 1 DELETE …
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
Let’s have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.