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 […]
New SQL Server clustering course (free!) Read More »
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 Backup: Restore to another server Read More »
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”.
Clone permissions between SQL instances with Minion Enterprise Read More »
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.
How to make a database request Read More »
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
RegEx in SSMS: A gift for quick code Read More »
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
How to use Minion Enterprise for the first time, part 3 Read More »
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
How to use Minion Enterprise for the first time, part 2 Read More »
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
How to use Minion Enterprise for the first time Read More »
Let’s have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.
PowerShell for fun (and profit?) Read More »