This is just to announce that a home-grown Minion CheckDB alert procedure is up and happy and live on the Community Zone! The purpose of this SP is to email an alert if any allocation errors or consistency errors were found in the last (@LastNDays) days. For use with Minion CheckDB. I recommend you save …
The short, short version: Minion Enterprise has a beautiful new GUI we want to show you! Sign up for the January 15 webinar here. And now, at normal speed… Minion’s command line origins Years ago, our resident visionary and original MidnightDBA Sean McCown was the only DBA for a company with over 1,000 SQL Server …
If you’re not familiar with it, the PASS Summit is an annual event, held this year in Seattle Washington November 6-9. PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. We at MinionWare will be there, just like the last umpteen years! We’ll be in the exhibitor area right …
Coming in November: PASS Summit in Seattle WA (plus discount code!) Read More »
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 »
Code that writes code is one of the best productivity tips I can give you. And no, I’m not talking about ORMs. I’m specifically talking about YOU writing a query, which writes one or more queries.
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 …