We are excited to announce the imminent release of another member of the ApexSQL Developer family – ApexSQL Model a new database modeling tool.
ApexSQL Model is used for creating database model diagrams and synchronizing changes to and from existing databases.
January 17, 2018
ApexSQL Monitor 2018 has been released
About ApexSQL Monitor: ApexSQL Monitor is a Windows and SQL Server monitoring tool with a wide range of monitored metrics. It tracks Windows, SQL Server, AlwaysOn Availability Group and Failover Cluster instances, and database metrics on multiple local and remote machines and SQL Server instances. It monitors the most important SQL Server statistics, memory, buffer, and page metrics – batch requests per second, user connections, target and total server memory, buffer cache hit ratio, batch requests, page life expectancy, page reads and writes per second, and more. ApexSQL Monitor also tracks SQL Server wait statistics including the individual query wait statistics. Monitoring these metrics enables you to identify and troubleshoot performance problems, establish trends, set baselines, and generate built-in or custom reports.
January 16, 2018
ApexSQL Trigger 2017 R3 has been released
About ApexSQL Trigger: ApexSQL Trigger is an auditing tool for SQL Server databases which captures DML/DDL changes that have occurred including information on who made the change, which objects were affected by it, when it was made, as well as information on the SQL login, application, and host used to make the change.
January 11, 2018
After the installation, ApexSQL Complete add-in will appear in the SQL Server Management Studio or Visual Studio main menu. The screen shots in this article were taken from Visual Studio. Main menu:
January 9, 2018
We are excited to announce that ApexSQL Audit 2018 has just been published. In the latest version of ApexSQL Audit, we have added several features that will enhance our users experience and allow even better auditing and reporting by using the following:
Relative date filter
Run scheduled reports on demand
Auditing configuration and out-of-the-box reports for GDPR
Multiple client support
New interface, themes and icons, High DPI and 4K resolution support
January 8, 2018
ApexSQL Backup 2018 has been released
About ApexSQL Backup: ApexSQL Backup is a tool that enables management and automation of backup jobs while preserving the backup chain for easy point-in-time restoration (database rollback). In addition, it offers automation of backup, restore, and log shipping jobs, stores details of all backup activities and enables easy cross server backup management and maintenance. ApexSQL Backup offers instant backup creation, as well as instant backup restoration, and backup security is enhanced by automatically performing backup verification. All captured metric values and backup activities are automatically stored in a central database repository.
January 5, 2018
Once ApexSQL Audit installer is started, installation wizard offers several choices:
Install ApexSQL Audit, which includes full installation of all services, GUI and central repository which allows full auditing and other jobs to be performed
Install ApexSQL Audit GUI option will install only user interface on different workstation which will be able to access and configure auditing and other tasks
Install ApexSQL Audit Reports option will install a limited user interface which only allows reporting tasks
Install server-side components option will install windows services which are required to allow remote auditing
January 5, 2018
ApexSQL Audit 2018 has been released
About ApexSQL Audit: ApexSQL Audit is a SQL Server auditing tool with a wide range of features for auditing access, changes, and security on SQL Server instances, databases, and objects. It audits queries, DDL and DML operations, security events (authentication changes, permissions changes, and attempted logins), events on stored procedures and functions. ApexSQL Audit saves captured information in a centralized auditing repository and provides comprehensive reports.
January 5, 2018
Upon starting ApexSQL Defrag, we are greeted with the main grid with indexes and their appropriate information, such as fragmentation, to which table they belong, schema they belong to, type, size and other relevant information.
January 3, 2018
ApexSQL Complete 2018 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.
December 29, 2017