Jennifer McCown

Xp_cmdshell isn’t evil, so get with the program

Many companies are worried that enabling xp_cmdshell is a security hole. In fact, xp_cmdshell is limited to SQL Server administrators by default. In order for a non-admin user to use xp_cmdshell, an administrator must specifically grant permissions to them. In short: xp_cmdshell is not a security hole.

ME Trial 12 – AD Group Members and Login Access Method Audit utility

A quick glance behind, and ahead So last time, we introduced the Objects, Tables, and Columns modules. This time we’ll look at the AD Group Members module, and the related Login Access Method Audit utility. This is one collection that we are super, totally, and completely in love with. The AD Group Members Module It …

ME Trial 12 – AD Group Members and Login Access Method Audit utility Read More »

ME Trial 11 – Objects, Tables, and Columns (and top 20 features!)

A quick glance behind, and ahead So last time, we introduced the Database Properties module, and had an op-ed on autogrow. This time we’ll look at the Objects, Tables, and Columns modules. These are three separate modules – with their own jobs, tables, and so on – but they’re similar enough to talk about together. …

ME Trial 11 – Objects, Tables, and Columns (and top 20 features!) Read More »

ME Trial 10 – Database Properties, and “To Autogrow or Not?”

A quick glance behind, and ahead So last time, we introduced the Databases module, and whether you should write your own custom objects. This time we’ll look at the Database Properties module, and talk a bit about autogrow. The Database Properties Module For each database, the Database Properties module collects a significant amount of data, …

ME Trial 10 – Database Properties, and “To Autogrow or Not?” Read More »

ME Trial 9 – Databases, and Custom Objects

A quick glance behind, and ahead So last time, we introduced the Wait Statistics module. This time we’ll look at the Databases module, and talk about writing your own custom objects. The Database Module The Database module collects database information from managed servers. This gives you a record of all databases – and their database IDs, …

ME Trial 9 – Databases, and Custom Objects Read More »

ME Trial 8 – Wait Statistics and FAQ

A quick glance behind, and ahead Last time, we introduced the Error Log Search module. This time we’ll look at the Wait Statistics module, and cover some frequently asked questions about Minion Enterprise. The Wait Statistics Module The Index Stats module collects detailed index information into the Minion Enterprise repository. It gets all data from sys.indexes …

ME Trial 8 – Wait Statistics and FAQ Read More »