Hey Habr! We work a lot with , and this year they have acquired is a manufacturer of solutions for managing and monitoring Microsoft SQL Server databases. In Russia, it seems to us, little is known about these guys. On their main site, they write "Killer tools for SQL Server". Sounds menacing. We had an idea to present this vendor and find out what is so deadly in their decisions. Let's start with the hype part - free products. After them there will be a short part about commercial products. I hope you find these programs useful. Please under cat.
In this article:
- is a tool for comparing SQL code, files and folders. Works also as an extension for SSMS or Visual Studio.
- - streaming decryption of objects in SQL Server: procedures, functions, triggers and view (view). Works also as an extension for SSMS or Visual Studio.
- - Discovery of SQL Server instances and related SSRS, SSAS, and SSIS services.
- is a tool for refactoring and formatting SQL code. Works as an extension for SSMS or Visual Studio.
- β creating diagrams of SQL Server objects. Works also as an extension for SSMS or Visual Studio.
- - a tool for optimizing Execution plans. Works also as an extension for SSMS.
- - the tool automatically completes SQL statements and allows you to add your own snippets (keyboard shortcuts for autocompletion). Works also as an extension for SSMS or Visual Studio.
- - a tool for executing SQL code on several databases at a time.
- - a utility for searching data and objects in the bowels of SQL Server. Works as an extension for SSMS or Visual Studio.
- β a tool for creating CI/CD pipelines. The only product listed here has a web console.
Each product is part of the functionality of paid ApexSQL solutions. At the end of the article, we will briefly describe what they have from commercial solutions.
A short video about the mechanism of operation and capabilities
Compare lets you compare files, folders, and SQL Server objects. Supports bidirectional comparison and further generation of a script for merging differing objects. In the interface, the utility can highlight the syntax of C#, C++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML.
Key features include integration with SSMS and Visual Studio, calling objects from different DB instances for comparison directly from Object Explorer, and .
A short video about the mechanism of operation and capabilities
In Decrypt, from the SSMS interface or Visual Studio, you can decrypt a procedure, function, trigger, or view in one click.
In the interface, you can view the DDL decryption script. Simultaneous connection to multiple instances of SQL Server is supported.
Identify existing instances of SQL Server, SSRS, SSAS, and SSIS services by IP address range and view detailed information.
From the interface, you can configure scheduled database discovery. ApexSQL Discover can send notifications with discovery results to email.
A short video about the mechanism of operation and capabilities
Code formatting can be based on a boxed profile, or you can customize your own to make the code look more familiar to you. Refactor can highlight unused variables in code, encapsulate blocks of code into procedures, expand "*" into a complete list.
One useful feature is splitting tables to separate the least used columns. Objects that will be affected by such a separation will be reported by Refactor.
Also in the Refactor interface, you can safely change the names of objects with a change in all dependencies.
These and other features can be found in more detail on the page with .
The utility visualizes SQL Server objects and the relationships between them. In the same interface, you can change the configuration of objects and generate the corresponding DDL code. All visualizations can be exported as images.
Model functionality is extended with commercial products ΠΈ . Using the first product, you can compare the model with the current state in the database or compare models of two different databases, and the second product is needed to document database objects.
A short video about the mechanism of operation and capabilities
It is a performance optimization tool. Also, using ApexSQL Plan, you can export plans to reports in HTML and XML formats. A frequent case of using this utility is to compare the current plan and the one modified according to various characteristics.
ApexSQL Plan supports unloading from the query store and presenting the characteristics of these queries in the form of dashboards.
A short video about the mechanism of operation and capabilities
Code accelerator. In the utility interface, you can configure aliases, snippets, and code highlighting.
In ApexSQL Propagate, you can configure the execution of code on various SQL Server databases, and determine the order of execution.
The results of the executed code are parsed by the utility and recorded for easy viewing of the execution results.
A short video about the mechanism of operation and capabilities
The tool searches the database structure. From here, you can safely rename objects and track their relationships. Search results are exported to HTML, CSV and Excel.
A short video about the mechanism of operation and capabilities
PowerShell code works under the hood of the utility. Build, Review, Document and Deploy are available to the developer from the ApexSQL DevOps Toolkit interface. Here you can also generate synthetic data, automatically run unit tests, document changes. Can be connected as a plugin to TeamCity, Jenkins and others.
The ApexSQL Knowledge Base has DevOps in a database environment.
Now that we have dealt with free solutions, here is a short list of paid solutions, which, of course, have more powerful functionality.
- - a tool for auditing the database for compliance with security requirements, incl. HIPAA, GDPR, PCI are supported. Reports and viewing the history of changes are supported.
View screenshot and video
- β automating the creation of incremental backup, transaction log and full backup. Point-in-time recovery is supported, you can create templates for creating a backup and flexibly configure backup plans.
View screenshot and video
- - a utility for monitoring and managing defragmentation.
View screenshot and video
- - a tool for managing tasks, including history, schedule and notifications.
View screenshot
- - a tool for reading the transaction log for auditing, replicating or rolling back changes.
View screenshot and video
- β recovery of damaged, deleted or lost data.
View screenshot and video
- - a tool for analyzing relationships in the database.
View screenshot and video
- - a tool for automating the creation of a database. Can connect to version control systems.
View screenshot and video
- - SQL code improver.
View screenshot and video
- is a tool for generating millions of rows of data in one click. Export of test data to SQL, XML, CSV, JSON and Excel is supported.
View screenshot
- - a tool for searching, classifying and masking sensitive data in the database. Has 220+ predefined masks and 55+ built-in filters for classification.
View screenshot
- β a tool for creating DDL and DML scripts and executable installation packages.
View screenshot and video
- is a tool for integrating version control systems with SSMS.
View screenshot and video
- - data audit in the database and translation into DML.
View screenshot and video
- is a tool for running unit tests directly from the SSMS console.
View screenshot and video
Write in the comments what tools for audit and database management you already use and what tasks you solve with them.
To ask questions about ApexSQL products, get commercial products for testing or clarify the price, leave a request in .
If you are solving a complex task of monitoring and managing, read our previous articles on HabrΓ©:
You can also subscribe to our .
Source: habr.com