SQLDocKit 7 – Perform security management tasks across multiple SQL Servers

We are pleased to present the newest version of SQLDocKit! Considering all the challenges that every DBA faces, our primary goal for this release was to ease SQL management and deliver new features that will help you in keeping your SQL environment secure. Here’s a short overview of the novelties and new features delivered in this version. For more information, visit www.sqldockit.com.

Manage Permissions across SQL Servers

SQLDocKit allows you to perform security management tasks across multiple servers from one single UI, whether it’s granting server roles to principals, removing logins from assigned SQL Server roles, or deleting logins. Besides this, you can schedule management actions. You can specify the time when the grant and revoke actions are 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.

Support for Azure SQL Servers and Databases

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. Explore all firewall rules created on a server and its databases to see which IP addresses have external connectivity enabled.

Match your SQL Server settings according to more than 20 newly added best practices

We’ve received a lot of customer inquiries about adding more best practices in SQLDocKit. So now you’re able to match your SQL Server settings according to more than 20 newly added best practices. Resolve security issues in your SQL environment by following newly added security best practices. Visit our Best Practices library for a list of all available BP reports.

Detect SQL Servers on Workstations

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.

To see it in action, download a free 30-day trial, and for more details about improvements, read our official release note.