A centralized place for management of groups, domains, SQL Servers, and instances. Manage and monitor all your servers from a central location.
You will be able to restore SQL Server permissions from a specific date and recreate those based on an earlier snapshot.
Collect and monitor information about your environment health from the Windows Event Log and SQL Server Logs across all SQL Servers from one centralized place.
You will be able to manage database permissions and set up a schedule for automatic security management.
Get a quick overview of the most important information about your SQL Server environment in one place.
You’ll be able to add custom comments about your SQL Servers and databases and set tags to help you organize your environment.
Compare and track changes to SQL role permissions and user memberships.
Compare and track changes made on the structure of your databases.
We will add more information about SQL Server Always On.
Graphical representation of all tables participating in at least one foreign key relationship.
Document settings for all your databases across all your Azure SQL Servers.
Document settings for all your databases across all your SQL Servers.
Discover and document all databases on Always On Availability Groups.
Running different services under the same account is considered a security risk. The Different SQL Service Account report checks whether separate accounts are used for different SQL Server services. Visit our Best Practices Library to check the full list of available best practices reports.
Avoid poor system performance by following new configuration best practices. The SQL Server Max Memory report shows the percentage of memory assigned to an SQL Server and checks whether the operating system has memory available. Visit our Best Practices Library to check the full list of available best practices reports.
Perform security management actions (grant, revoke, drop) across multiple SQL Servers from a single UI. Run management actions immediately, or schedule them. Track all scheduled actions, and check their statuses.
We added more than 20 new Best Practices reports to help you audit your SQL Server settings even better.
Visit our Best Practices library for a list of all available BP reports.
Document all settings for your Windows Azure SQL servers and databases.
We added the ability to discover all SQL Server instances across multiple domains. If your domains are not trusted, you can define different credentials for any domain you have, so SQLDocKit can impersonate on the non-trusted domain and discover all SQL servers within.
Get complete insight into your SQL Server Business Intelligence environment by auto-discovering and documenting all Integration Services, Analysis Services, and Reporting Services.
We added a report which lists all database users, logins mapped to database user accounts, and roles. Find out if someone has access to a database that they shouldn’t, as well as whether everyone is granted the appropriate permissions.
Collect all information about executed and scheduled jobs. Check the status of jobs, and whether they are enabled or disabled. Find out when a job was last executed and modified, its owner, and more details.
We added a new export option for comparing results and SQL Server documentation. All data will be sorted out through sheets, and Excel filtering options will allow you to explore the information you need more efficiently.
We added the ability to explore SQL Server settings and databases in live mode, without having to create a snapshot.
Manage not only single, but multiple databases across servers.
We have released the following actions: Show Connections, Kill Connections, Detach Database, Drop Database, Change State (to make a database read only), and Change Owner.
Note: Please bear in mind that this is a high-level roadmap without feature details; everything listed here is subject to change without prior notice.