When we are asked what is the purpose of our tool and what value we want to provide to SQLDocKit users, we can say it’s all about making their life easier by simplifying their daily time-consuming administration tasks. While creating SQLDocKit, we were aware of how difficult it sometimes is for DBAs to deal with the large number of SQL servers in their environment and to collect all the data and always be up to date with everything. Keeping an SQL environment secure is, for sure, a challenging task and that’s where SQLDocKit comes to the rescue.
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.
So, your favorite SQL administration tool just got even better. Here’s a short overview of the novelties and new features delivered in this version. To see it in action, download a free 30-day trial.
Perform security management tasks across multiple SQL Servers
Maintaining a high level of security by assigning roles to principals across SQL Servers in your environment can be a tedious job. Every day you’re faced with changes in your company. Some people leave, new people arrive. It’s challenging to keep track of who has what permissions across multiple servers. If you have hundreds of servers and you have to create a new login on several servers, assign different role permissions to logins, or remove logins from server(s), we are sure you’ll be pleased to have a tool that can help you with these tasks. SQLDocKit has you covered in these situations.
It 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, for example, if you need to grant someone a role on server(s) for a few days only and then revoke that role. Use the Scheduled Actions Wizard to keep track of what you scheduled as well. We’re sure you’ll be thrilled with this new feature.
Match your SQL Server settings according to 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. Let’s highlight a few best-practices checks that will help you to be sure that your servers are aligned with Microsoft best practices:
- Since remote access is an obscure SQL Server to SQL Server communication feature that is deprecated, you probably shouldn’t be using it. Check which servers have remote access enabled.
- Configure database files to the size needed by applications and maintenance usage. Avoid using the Auto Shrink option to manage database file sizes.
- 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.
- List all SQL Server users who have a simple password. We check the following rules: the password is not blank, the password is not the account name of the user, and the password isn’t one of the most common passwords.
- Check that server permissions are not granted to the public role.
- Check the SQL Agent Job owners against a login to validate which jobs do not match their owner, and much more.
Select the best practices you wish to monitor on your dashboard and configure the settings for built-in best practices. Visit our Best Practices Library to check the full list of available reports.
Support for Azure SQL Servers and Databases
SQLDocKit now lets you collect all the information about SQL Servers hosted in Azure, as well as all the databases associated with Azure SQL Servers, including server name, version, memory info, logins, database list, and role membership. You can get an insight into all firewall rules created on a server and its databases to see which IP addresses have external connectivity enabled. Explore Azure SQL Server inventory, create documentation, and easily manage Azure databases.