ApexSQL Plan 2018 has been released
About ApexSQL Plan: ApexSQL Plan is a SQL query analysis and optimization tool. It identifies performance issues and deadlocks, analyzes stored procedures, SQL Server query issues and query execution plans, and helps you understand query performance characteristics.
February 6, 2018
ApexSQL Audit is an enterprise level product with a ton of features. Although this is good, users can sometimes fail to see the proverbial forest for the trees, in navigating the user experience. One key impediment has been the implementation of panels on the interface, without segmentation.
This is a summary of panels (SDI) vs forms (MDI) research and proposals of a new design for configure auditing in ApexSQL Audit.
February 5, 2018
When the application is started, the main window is shown, along with the Home tab, that contains actions which are grouped in the Projects, Database, Script, Data source and Tools sections:
February 1, 2018
ApexSQL Defrag 2018 R2 has been released
About ApexSQL Defrag: ApexSQL Defrag is an enterprise SQL Server tool used for analyzing, monitoring and managing SQL Server index fragmentation. The application allows detailed index fragmentation analysis on server, database and table level. With ApexSQL Defrag you can rebuild or reorganize fragmented indexes in real time, as well as create policies and apply them to multiple databases or servers.
February 1, 2018
When starting the application, the Connect to SQL Server window is shown where we can select Server and the Authentication type we want to use to load the databases for object decryption:
January 31, 2018
The ApexSQL GDPR Compliance Relief Program is designed to help organizations that use SQL Server for processing and holding personal identifiable information (PII) reduce the cost of complying with GDPR.
GDPR took full legal effect on May 25, 2018 and is intended to protect personal identifiable information (PII) of EU citizens. It applies to all organizations, in or outside the EU, that handle, process, collect and store personal identifiable information of data subjects residing in the European Union.
January 29, 2018
ApexSQL Data Diff 2018 R2 has been released
About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server data comparison and synchronization tool that detects data differences and resolves them without errors. It compares and synchronizes live databases, database backups, and data under source control. ApexSQL Data Diff integrates with SQL Server Management Studio and has a command line interface, to allow for unattended execution.
January 26, 2018
ApexSQL Compare 2018 R2 has been released
About ApexSQL Compare: ApexSQL Compare is a tool that can compare files, SQL Server objects, and folders. It can also be integrated as an add-in into SQL Server Management Studio and Visual Studio or it can be used directly from command line interface. It can perform two-way script comparison and create a merged file. Three comparison modes include Character, Line and Block comparison modes, along with the appropriate syntax highlighting.
January 26, 2018
ApexSQL Complete 2018 R2 has been released
About ApexSQL Complete: ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in, that speeds up coding by automatically completing SQL code statements, filling in SQL code fragments and more.
January 25, 2018
ApexSQL Refactor 2017 R5 has been released
About ApexSQL Refactor: ApexSQL Refactor is a SQL Server Management Studio and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 6 refactors such as table partitioning, safe rename, wildcard expansion and more.
January 22, 2018