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!
Get started in under 2 minutes!
Database Objects Overview and Documentation7.1
Get a complete overview of all SQL Server database objects, including tables, views, functions, stored procedures, and table indexes in one place. Check the size of each table in a database, and determine which one is consuming the most disk space. List the associated indexes and index information for the selected tables. Check out all the details on database views, and more. Document all database objects in just a few clicks.
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). 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.
Keep track of what you scheduled. If you change your mind about executing a scheduled action, use the Scheduled Actions Manager to cancel it.
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.
Document Always On Availability Groups7.1
Keep track of your Always On availability groups inventory from a single UI. Create documentation with all the information you need to know what’s going on within configured availability groups. Check the health of all availability groups, replicas, and databases.
Examine the replicas’ roles and possible failover modes for which the availability replica is configured. Check all availability databases’ states, as well as whether databases are synchronized with the primary replica. Read more here.
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.
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.
Detect SQL Servers on Workstations7.0
In this version of SQLDocKit, 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.