Azure SQL Database Auditing and Documenting

SQLDocKit supports auditing SQL Servers and databases hosted in Azure!

Since more and more users are now hosting SQL databases in Azure, the SQLDocKit team decided to step up the game with the SQLDocKit 7.0 and include the Azure in the SQL Server documentation.

Microsoft Azure is a managed cloud database for application developers. It offers a simple way to create and host SQL databases and what it essentially means is that it’s convenient for users who would like to avoid investing in hardware and the hassle with SQL Server licenses. Of course, one of the benefits being that databases hosted in a cloud are globally accessible.

Document Azure SQL Servers and Databases

For that purpose, users found it convenient if they could make an inventory of their Azure environment.

This cannot be done by connecting to the database via SQL Server Management Studio unless you’ve made an exception to the firewall rules which states that your IP and account have appropriate permissions.

So how do you perform Azure SQL Server and database auditing? How do you know which firewall rules have been set?

Azure SQL database auditing with SQLDocKit

SQLDocKit can document all the Azure SQL Server and database settings such as server versions, memory, processor info and a list of all databases associated with an Azure SQL server, editions, and statuses.

Apart from that, SQLDocKit can provide valuable information about SQL Server logins, roles, and previously established firewall rules at the server and database level.

This means SQLDocKit can track and inventory Azure SQL databases, as well as create snapshots which you can later use to compare your Azure inventory, database growth and memory over a certain time frame.

A tool, such as SQLDocKit best comes in handy so that you don’t have to track the Azure SQL Server settings by foot and rather have the whole process automated and documented.

Along with the Compare feature, SQLDocKit is the best solution when you need to keep up with your Azure expenses. As changes occur, you can decide whether or not you need to change the edition.

SQLDocKit gathers the following information from Azure:

  • Role membership
  • Security (enable common criteria compliance, enable C2 audit tracing, and cross database ownership changing)
  • Processors info (automatically set a processor affinity mask for all processors, automatically set I/O an affinity mask for all processors, maximum worker threads, boos SQL Server priority, and use Windows fibers)
  • Memory (minimum server memory in MB, maximum server memory in MB, Index creation memory in KB, and minimum memory per query in KB)
  • Database settings
  • Logins
  • Advanced settings (databases are enabled, the FILESTREAM access level, the FILESTREAM share name, whether triggers to fire others are allowed, values for the blocked process threshold, cursor threshold, default full-text language, default language, full-text upgrade option, max text replication size, optimize for ad hoc workloads, scan for startup procs, two-digit year cutoff, network packet size, remote login timeout, cost threshold for parallelism, locks, max degree of parallelism, and query wait)
  • Connections
  • Server-level firewall rules
  • SQL Server info
  • Database list (database name, owner, edition, read-only, status, and recovery model)
Gather information for all SQL Servers hosted in Azure, as well as all the databases associated with an Azure SQL server.

Gather information for all SQL Servers hosted in Azure, as well as all the databases associated with an Azure SQL server.

More about SQLDocKit

SQLDocKit is a server management tool developed for DBAs to inventory SQL Servers and document the entire SQL server environment – making SQL server management easier. The tool creates a comprehensive SQL inventory with valuable information about SQL, as well as SQL best practices, to help DBAs maintain system reliability.

SQLDocKit comes with a 30-day trial. So, hop on to the download page to start you free trial today.