What’s New

December 2016

We’re happy to present to you the improved SQLDocKit with exciting new features. In this version, you can discover SQL Server instances across multiple domains, get an inventory of the SQL Server Business Intelligence services (SSIS, SSAS, and SSRS) running in your environment, audit all database users and their roles, and much more. Be informed and keep your SQL Server environment secure. Give it a try!

Download SQLDocKit

Get started in under 2 minutes!

Auto-discover SQL Servers across multiple domains6.4

With this SQLDocKit version, you have the ability to discover all SQL Server instances across multiple domains. We’ve added the ability to specify credentials for each of the domains in your environment as well. In case your domains are not trusted, you can define different credentials for any domain you have so that SQLDocKit can impersonate on the non-trusted domains and discover SQL Servers.

Auto-discover SQL Servers across multiple domains.

Improved SQL Server detection6.4

SQLDocKit will search for all SQL Servers in your domain. If anybody installs SQL Server on a particular server, SQLDocKit will automatically detect that SQL instance. However, if you have servers that use only SQL authentication or are sitting on nonstandard ports, you can add these servers manually.

SQLDocKit will search for all SQL Servers in your domains or you can add SQL Servers manually.

SQLDocKit will take a snapshot of those servers as well. It will easily auto-detect all SQL Server Database Engine instances in all trusted and non-trusted domains.

Generate XLSX documentation and filter data6.4

The entire SQL Server documentation and the overview of SQL environment differences is now exportable to Excel. You can filter, explore, and analyze your data efficiently using Excel’s capabilities. This will give you a better overview of the most important details of your SQL Server environment that you need to analyze. Check out a sample of this documentation.

Inventory and document SQL Server BI services6.4

Get complete insight into your SQL Server Business Intelligence environment by auto-discovering all Integration Services, Analysis Services, and Reporting Services. Retrieve information such as version, service accounts, role and members, cubes used by analysis services, and create professional-looking documentation.

Create inventory of SQL Server Business Intelligence Services, including SSIS, SSAS, and SSRS.

Audit role permissions for databases6.4

Concerning database security, it’s crucial to retrieve the database roles associated with each user. SQLDocKit provides you with a list of all database users and their roles on any instance of SQL Server. Quickly check who has db_owner permission, and who can read/write data to any database.

Use SQLDocKit to list and report on all database users and their predefined, fixed, or assigned roles.

Find out if someone has access to a database that they shouldn’t, as well as if everyone is granted the appropriate permissions.

Detailed SQL Server agent job information6.4

There are usually a number of jobs created around an SQL Server. Collect all the information about executed and scheduled jobs. Check the status of the jobs, and whether they are enabled or disabled. Find out when a job was last executed and modified, its owner, and more details.

Collect all the information about executed and scheduled jobs around an SQL Server.

Think of SQLDocKit as the central dashboard for all the jobs across all SQL Servers in your environment.