Training in 2016

Posted by on Dec 29, 2015 in Articles, Minion by MidnightDBA |

The MidnightDBA team, will be out representing both the MidnightSQL – our consulting venture – and MinionWare – our software enterprise – at several events in 2016. We have paid pre-conference sessions, free conference sessions, webinars, and sponsor tables at multiple events. Come and see us: SQL Saturday Austin #461 on Jan 30 2016 Precon at SQL Saturday Chicago #484 on Mar 04 2016 SQL Saturday Chicago #484 on Mar...

Read More

Minion Enterprise bests OEM for SQL Server

Posted by on Dec 15, 2015 in Articles, Minion by MidnightDBA |

IT shops that use both Oracle and SQL Server need effective enterprise management. When we introduce these shops to Minion Enterprise, they typically have the same set of questions: first, about the product itself; and then, about the differences between MinionWare’s Minion Enterprise, and Oracle’s system monitoring plug-in, Oracle Enterprise Manager for SQL Server (or just, OEM). There are a great many differences between...

Read More

Customize how long Minion Backup retains backup files

Posted by on Dec 2, 2015 in Articles, Minion by MidnightDBA |

Let’s talk about changing the retention hours for your backup files.  We’ll see the proper way to do it, as well as discuss the rationale behind the way Minion Backup works in this regard. First of all, there are two settings that sound very similar, but do completely different things, which can be a source of confusion (and misconfiguration): HistRetDays and RetHrs. The HistRetDays in the dbo.BackupSettings table controls how long...

Read More

Video: Minion Reindex Print Statements

Posted by on Nov 25, 2015 in Articles, Minion by MidnightDBA |

This is a companion blog for the Minion Reindex video Print Statements (03:27 minutes, size 8170 KB, click here to download the video). You don’t have to alter the procedure in order to print reindex statements so you can run indexes manually. This is an excellent feature that we use all the time to help troubleshoot specific index issues. Download the latest version of Minion Reindex, take a look at the full documentation, and let us know...

Read More

Webinar: Security Scripting and Cloning with Minion Enterprise

Posted by on Nov 19, 2015 in Articles, Minion by MidnightDBA |

Join us on December 1 for the security edition of our Minion Enterprise Talk. This month we’re talking about one of biggest time drains on a database team: security. Minion Enterprise allows the DBA to effortlessly script security objects, like CREATE LOGIN and CREATE USER, to roles, and all the way down to column level permissions. We’ll also look at the User Cloning feature of Minion Enterprise, which allows you to duplicate...

Read More

Video: Minion Reindex Regex Exclude

Posted by on Nov 11, 2015 in Articles, Minion by MidnightDBA |

This is a companion blog for the Minion Reindex video Regex Exclude (03:27 minutes, size 8170 KB, click here to download the video). This video is about advanced exclusion, a very powerful feature. Regex exclude allows you to exclude entire groups of databases by defining patterns. So for example, if you want to exclude all databases from index maintenance that end in a date in the format yyyy-mm-dd, that’s possible with a single row...

Read More