“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

 

Free training right now: 24 Hours of PASS

The training: it is in The Cloud
The training: it is in The Cloud

Just a quick reminder that 24 Hours of PASS is going on right now, so go get you some free training right here:

http://www.sqlpass.org/24hours/2015/goc/Schedule.aspx

Happy days,

Jen

Real news, real tech.