What’s New – 7.0

April 2017

We’re proud to present SQLDocKit 7. It lets you gather information for SQL Servers hosted in Azure, manage SQL Server role permissions across multiple SQL Server instances, match your SQL Server settings according to more than 20 newly added best practices, and much more. Give it a try! Enhance your admin superpowers with SQLDocKit!

Download SQLDocKit

Get started in under 2 minutes!

Manage Permissions across SQL Servers7.0

Maintain a high level of security by assigning roles to selected principal(s) across multiple SQL servers from one central UI. Even if a login that you want to grant server permissions to doesn’t exist on a selected server, it will be created. You can easily remove login(s) from fixed server role(s).Select server role(s) you wish to revoke for principal(s).If you need to prevent access to an instance(s) of SQL Server for a login(s), just drop the login. Time saving, right?

Automated Server Permission Management7.0

Choose to run management actions immediately or to a schedule. Specify the exact time when grant, revoke, or drop actions will be executed. Logins will be added to or removed from selected server roles at the chosen time by the SQLDocKit service.

Specify an exact time when grant and revoke actions will be executed.Keep track of what you scheduled. If you change your mind about executing a scheduled action, use the Scheduled Actions Manager to cancel it.

Detect SQL Servers on Workstations7.0

In this SQLDocKit version, we’ve added the option to detect SQL Servers on workstations in case your developers have installed multiple SQL Server instances on their machines and you want to keep track of them.

Support for Azure SQL Servers and Databases7.0

Gather valuable information and create documentation for all SQL Servers hosted in Azure, as well as all the databases associated with an Azure SQL server. Gain insight into server versions, memory, and logins. List all the databases and database users.

Gather information for all SQL Servers hosted in Azure, as well as all the databases associated with an Azure SQL server.Explore all firewall rules created on a server and its databases to see which IP addresses have external connectivity enabled.

Security Best Practices Reports7.0.

Resolve security issues in your SQL environment by following newly added security best practices. Get a list of all databases that have the “connect” permission granted to a guest account. Revoke the permission for a guest user to access the database if it is not required. Determine whether the public server role has server permissions, check that the passwords for your SQL Server users are not easy to guess, and more.

Guest Permissions Report - Get the list of all databases that have CONNECT permission granted to the Guest account.

Count Virtual Log Files (VLF) in Databases7.0

Having a large number of small VLFs can slow down the recovery of a database on startup or after restoring a backup. Prevent that from happening by managing the number of VLFs in all databases.

Visit our Best Practices library for a list of all available BP reports.