Quest.Software.ApexSQL.Trigger.v2019.01.0279
Quest.Software.ApexSQL.Unit.Test.v2019.02.0179
Quest.Software.ApexSQL.VM.Monitor.v2019.01.0331
Quest.Software.ApexSQL.Analyze.v2020.02.0210
Quest.Software.ApexSQL.Audit.v2021.01.2082
Quest.Software.ApexSQL.Backup.v2018.07.0205
Quest.Software.ApexSQL.Bi.Monitor.v2018.07.0420
Quest.Software.ApexSQL.Build.v2021.01.0345
Quest.Software.ApexSQL.Compare.v2022.01.0292
Quest.Software.ApexSQL.Complete.v2021.02.0631
Quest.Software.ApexSQL.Data.Diff.v2022.01.0564
Quest.Software.ApexSQL.Defrag.v2019.02.0210
Quest.Software.ApexSQL.Diff.v2022.01.1167
Quest.Software.ApexSQL.Discover.v2020.01.0067
Quest.Software.ApexSQL.Doc.v2020.03.1151
Quest.Software.ApexSQL.Enforce.v2019.03.0299
Quest.Software.ApexSQL.Generate.v2020.03.0384
Quest.Software.ApexSQL.Job.v2019.03.0104
Quest.Software.ApexSQL.Log.v2019.02.1245
Quest.Software.ApexSQL.Manage.v2020.07.0205
Quest.Software.ApexSQL.Mask.v2020.08.0345
Quest.Software.ApexSQL.Model.v2020.01.0193
Quest.Software.ApexSQL.Monitor.v2018.12.1013
Quest.Software.ApexSQL.Propagate.v2021.01.0118
Quest.Software.ApexSQL.Pump.v2020.02.0124
Quest.Software.ApexSQL.Recovery.v2019.2.1245
Quest.Software.ApexSQL.Refactor.v2021.02.0453
Quest.Software.ApexSQL.Script.v2020.02.0486
Quest.Software.ApexSQL.Search.v2021.01.0188
Quest.Software.ApexSQL.Source.Control.v2021.02.2119

Find out who changed what and when. Review values before and after a change as well as the complete history of row changes, from initial insert to all subsequent updates or deletion. Identify and isolate rogue transactions and easily reverse them to repair damaged data without risk of additional data loss. Easily record loads on production and then replay them on staging, simulating a production environment.

Automate SQL database documentation as well as SSIS, SSAS, SSRS and Tableau.

Document SQL Server databases
Documenting in CHM, HTML, Word, MD and PDF
Automate and schedule documentation unattended
Include graphical relationship and Data model diagrams
Document SSAS Multidimensional and Tabular models
Document SSIS Control flow and Data flow diagrams
Fully customize documentation output
Document SSRS reports in Native & SharePoint mode
Continuously document schema changes
Document Tableau servers
Document SSIS packages
Document SharePoint farms

Seamlessly integrate a SQL query formatter directly into SSMS and Visual Studio.

SQL formatter with over 160 optionsQualify objects and expand wildcards
Encapsulate SQL into proceduresAdd surrogate keysReplace one-to-many relationshipsChange procedure parametersSafely rename SQL objectsLocate & highlight unused variablesFormat SQL objectsObfuscate SQL

ApexSQL Model is a SQL data modeling tool. Using this tool, a database can be created or imported from SQL Server. Among the various importing settings, there is a way to import only selected objects from a database to model.

Recover deleted, dropped and truncated data
Reverse inadvertent or malicious database changes
Rollback or replay any DDL or DML change
Recover deleted data and files from SharePoint
Extract data directly from backup files
Extract BLOBs stored as files
Recover deleted BLOBs
Isolate specific SQL Server operations

Find out who changed what and when. Review values before and after a change as well as the complete history of row changes, from initial insert to all subsequent updates or deletion. Identify and isolate rogue transactions and easily reverse them to repair damaged data without risk of additional data loss. Easily record loads on production and then replay them on staging, simulating a production environment.

It is not that uncommon to find yourself in a situation when some inadvertent delete operations have deleted important data from a SQL Server database. The highest priority in these situations is to discover what exactly was deleted and how to get the deleted data back as quickly as possible. In this article, we are going to show you how to quickly recover data lost due to inadvertent delete operation using ApexSQL Log and ApexSQL Recover tools. Even though both tools generate the same output, a recovery script which rollbacks unintended deletes, the mechanisms used by them to acquire recovery information and create rollback script are quite different, so if the recovery with one tool doesn’t help, the other tool may.

It is not that uncommon to find yourself in a situation when some inadvertent delete operations have deleted important data from a SQL Server database. The highest priority in these situations is to discover what exactly was deleted and how to get the deleted data back as quickly as possible. In this article, we are going to show you how to quickly recover data lost due to inadvertent delete operation using ApexSQL Log and ApexSQL Recover tools. Even though both tools generate the same output, a recovery script which rollbacks unintended deletes, the mechanisms used by them to acquire recovery information and create rollback script are quite different, so if the recovery with one tool doesn’t help, the other tool may.

85 meaningful predefined data generators. Meaningful distribution across columns by default. Generate data in one column based on the data in another. Inter-column dependency support. Choose the file containing the value list. Set the percentage of each value being used in result. Create, save and use custom user-defined generators. Share user defined generators by setting the share folder. Populate rows based on percentage of other table's row count. Populate rows by setting the execution time. Disabling DELETE triggers. View the action plan before starting generation. GUI warnings. Command Line Interface full support. Choose additional script to be executed before generation. Choose additional script to be executed after generation. View the database table creation script. Sentence generator. Text shuffler. Lorem ipsum generator. Import values from SQL view. Include dependent database objects. Post-generation summary. SQL Server 2016 CTP2 support. SQL Server Management Studio integration. Usability improvements. Improved quality.

FULL CREDITS TO DrAww AliEn!