Create a complete SQL Server inventory, and keep your SQL environment secure

It’s been a while since our last release, in which we presented you with SQLDocKit Live Explorer and Database Management. Now it’s time to announce version 6.4 of our SQL Server administration tool, with lots of improvements and exciting new features.

Because SQLDocKit is the newest member of the Acceleratio family, we continuously invest a lot of love and effort to make it even better for users. Big thanks go out to all SQLDocKit customers and everyone who has tried it and given us feedback. Our team has been working hard to improve the tool and add features that will help you with SQL Server administration and management.

We want to provide you complete insight into your SQL server environment and help you with auditing all server logins and database-user roles to keep your SQL environment secure. We’ve already filled our backlog with new items that we’re preparing, but for now, let us highlight the novelties of this release.  We hope you’ll try it and send us your comments and suggestions.

The mighty SQL Server discovery

If you love how quickly and easily SQLDocKit can auto-detect all SQL Servers in your domain, just wait: Now it can detect all SQL Servers in multiple domains. You can even specify credentials for each domain in your environment. In case your domains aren’t trusted, you can define different credentials so that SQLDocKit can discover SQL Servers in them. SQLDocKit will search for all SQL Servers in your domain. If you have servers that use only SQL authentication or are sitting on non-standard ports, you can add them manually.

Complete visibility into your SQL Server inventory

So far, we’ve provided you with a detailed inventory of SQL Servers, databases, and Windows Servers that are hosting these databases. We’re sure that made your SQL administration a lot easier. But something has been missing. So with this version, SQLDocKit offers you the ability to discover, inventory, and document SQL Server Business Intelligence services (SSIS, SSAS, SSRS) for complete visibility of your SQL environment. Explore it live without creating snapshots of your environment first, or check out detailed inventory reports on versions, service accounts, role permissions, cubes used by analysis services, and more. Besides BI services, report on agent jobs created or scheduled to run across instances and databases. Set up and export professional-looking documentation that contains all the info you need. Export, filter, and analyze documented data, and present it to your boss or clients.

No need to wonder who uses your databases and how anymore

To audit security on SQL servers, every DBA needs to be aware of the permissions that are granted at the server and database levels. With SQLDocKit you can get a look at all users with access to a specific database and their role permissions. Explore all databases across SQL server instances, even those that you didn’t know existed, and find out who is using them and how, or who’s not using them anymore. Find out whether someone has access to the database where they shouldn’t, and make sure everyone is granted appropriate permissions.

Go ahead and try it!

This was just a quick overview of the new SQLDocKit version. If you want to see new features in action, download the free trial, and give it a shot.

Get complete control over SQL Server instances running in your organization.