Announcing Minion Enterprise: the new SQL Server Management Solution

minion enterpriseA company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances. Even more, there is no good way to push standardized settings out to the enterprise. The database administrator must spend a large amount of time to set up alerts and configure settings, and even then the solution itself is time consuming and often incomplete.

We are very pleased to announce the release of Minion Enterprise 2.0.  Minion Enterprise, or “ME”, is an enterprise management solution for centralized SQL Server management and alerting.

This solution allows your DBA to manage an enterprise of one, hundreds, or even thousands of SQL Servers from one central location. ME provides not just alerting and reporting, but backups, maintenance, configuration, and settings enforcement.

Case Studies

In our client installations, ME has accomplished wonders. Here are a few of them:

  • Allowed a single DBA to manage over 900 servers.
  • Produced a high level and detailed database space projection for the following two years.
  • Standardized file growth rates across the enterprise, saving hundreds of GB of disk space.
  • All but eliminated space management issues, saving 8 hours of DBA work per week.
  • Aided the passing of a security audit in a few minutes, instead of a few days, due to the Active Directory group expansion feature.
  • Audited server group membership from a central location.
  • Determined which accounts didn’t meet AD security policy, and which accounts have weak passwords.
  • Performed rapid impact analysis on SQL Server service account password changes; this determined which servers would be impacted by the change.
  • Reviewed which data and log files reside on the same drive, using a single query for the entire enterprise.
  • Reported on replication latency, to easily tell across the entire enterprise which replication scenarios were lagging behind or failing.
  • Accurately proved how much additional disk space was required, for SAN requests.

Download Minion Enterprise today:

  1. Download the solution from the Minion Enterprise page.
  2. Email us at Support@MidnightDBA.com for the 90 day trial license to activate your download, and for a demonstration.
  3. Check out the Minion Enterprise Introduction document (DOCX | PDF | RTF (zip)).

 

 

This article is reposted from www.MidnightSQL.com

 

SQL Server 2014 SP1 released, and revoked

sql2014sp1Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has been released, and then pulled almost immediately:

The problem is there was a problem with the patch. I can’t go into details until there is something formally announced by Microsoft but the MVPs were alerted to the issue overnight and shortly thereafter the URL for the download provided in that tweet from last night had been rendered unavailable for the time being.

The article goes on to say that if you happened to be one of the few fast-fingered folk who’ve already downloaded the patch, um, don’t install it, mm’kay?

The current word on MSDN.com is:

The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are currently investigating this issue including possible workarounds and fixes. We have temporarily put the package download on hold and will provide an update with a solution.

So, there’s that.
Happy days,
Jen
http://www.MidnightDBA.com/Jen

SSMS regular expressions: format text into a block

Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a RegEx thing in SQL Server Management Studio.

Here’s the problem: Sometimes I document an SP in MS Word, then copy-paste the paragraph into a comment block in the SP. Of course, when I do this, the paragraph is in one big long string:

sp1

It’s a little thing, but I really want to be able to READ the comments. What I want, then, is to go about 40 characters, find a space, and start a newline. But not by hand.

That’s the pseudocode for the RegEx solution, as it turns out.

 

sp3

The breakdown of “Find what”, {.^40} :

  • “.^40″ says “find any 40 characters”.
  • The curly braces “tag” the expression found – we can then reference those found characters later.
  • The space after the closing curly brace (which you can’t really see) says “I want to find 40 characters, but they MUST BE FOLLOWED by a space”.  If I didn’t add the space, we’d insert newlines in the middle of words, instead of at the end.

The breakdown of “Replace with”, \1 \n:

  • “\1″ references that found expression, the 40 characters discovered in the curly braces above. I want to keep those, so I start my “replace with” with the actual characters found.
  • “\n” is a newline.

The result:

sp4

SO SUPER AWESOME.

Happy days,
Jen McCown
http://www.MidnightDBA.com/Jen

Have you checked out Minion Reindex yet? It’s our free, easy, comprehensive index maintenance solution. You’ll love it, seriously.

Real news, real tech.