Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR

midnightsqlYou are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday, July 31, and if you register before June 30 you’ll get the Early Bird rate of $99…it’s $125 to attend: not bad at all for a full day’s training.

Oh, and don’t forget to register for SQL Saturday #423 Baton Rouge, too!

Abstract

The DBA life is frustrating: you rarely have time to innovate, because the same tasks fill up your time day after day. Your users are unhappy about how long it takes to resolve “simple” tickets. You have to put big items on hold because special requests come in. As careful you are, mistakes creep in as you get busier.

We’ve been there.

In this workshop, the MidnightDBAs show you how to develop enterprise scripts with a huge range of uses. A good set of reusable scripts will reduce task time from hours – or even days – to just a few minutes, and eliminate mistakes from your environment.

You’ll learn:

  • Enterprise philosophy – tackle simple tasks with the whole environment in mind
  • Single data store – define the benefits and uses of a single central database for common-use data and metadata
  • Choice of tools – choose the best tool (Powershell, T-SQL, SSIS, or other) for the job
  • Environment ground work – prepare your environment for enterprise scripting
  • Real world scripts – work through dozens of enterprise scripting issues (like alerting, error handling, multiple SQL versions, and more) as we develop a real enterprise script in class

This session is for database administrators, with a basic understanding of Powershell. It’s for anyone who touches backups or security, maintains databases, troubleshoots performance, monitors disk space, or any of a hundred other DBA tasks. Enterprise scripting is for anyone who has more tasks than time.

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

Check out Minion Enterprise, our new enterprise management solution for centralized SQL Server management and alerting! 

“What users are in this group?”

minion enterpriseWe solved this question.

Update: Sign up for one of our Minion Enterprise demos this coming Friday, July 3!

Minion Enterprise collects SQL Server login data, as well as Active Directory information, for an entire enterprise. The AD expansion module ties this data together to provide so much insight:

  • Find out what users are in a Windows group…especially those groups that have sysadmin privileges!
  • List all users that have SA rights on any instance in the environment.
  • Discover which SQL Server instances a specific user has access to, and via what groups.
  • Filter by environment, location, SLA, server, login type, or any combination of the data available.

These are the exact questions we’ve always needed answered, in every single shop. So, we know this will be immensely useful in your shop.

One client was recently able to reduce their SQL access on one server by two-thirds. They simply used the AD expansion module to identify the rogue group with hundreds of members, and removed that group’s rights.

Take a look at the AD expansion module demo below, and then get in touch for your own 90 day trial license of Minion Enterprise.

 

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

Register now for a Minion Enterprise demo June 30

minionware_logo

Update: Thanks for those who registered for demos! The date is past now, but feel free to contact us for your own Minion Enterprise demonstration. Just email us at MinionWareSales@MidnightDBA.com!

We’ve cleared a full day – Tuesday, June 30 – for giving free 30 minute demos of Minion Enterprise, our SQL Server enterprise management system.

What do we mean by “enterprise management”? Among other things, we mean:

  • Gathering and expanding AD group information to find out exactly who has SA on your servers. (We’re VERY excited about this new feature; read on at the end of this article.)
  • Collecting disk space usage data across the enterprise.
  • Setting and enforcing sp_configure values from a central location, for all your instances.
  • And about a thousand other things.

We will set up as many 30 minute demos during June 30 as the day allows, and answer your individual questions. Sign up now! We’ll get with you ASAP to nail down a specific time. (And if you can’t make it on June 30, just let us know of a better day in the form comments.)

Update: Registration is now closed. Email us at MinionWareSales@MidnightDBA.com to set up a demo.

Now, about that AD Expansion…

The AD expansion module allows you to query a specific user, and find out which SQL Server instances they have permissions in. What’s more, it tells you where they got those permissions.

So for example, user “Jim” has rights to 7 SQL Server instances:

  • Server1 – as Jim
  • Server2 – through the Sales AD group.
  • Server3 – through the Marketing AD group.
  • Server4 – through the Region1 AD group, but not directly; Region1 is part of the Marketing group.

And so on.

With the AD expansion module, you’re able to see how many servers he can get into, and through what groups. Minion Enterprise even shows you the nested chains of ownership. So, for Server4 above, you would see something like this:

Sales < Marketing < Region1 < Jim

You not only see that he’s got rights, but also which AD group chain gave him those rights.

We’re pretty excited about this new functionality. Now let us show it to you!

Happy days,
Jen McCown

 

Real news, real tech.