ApexSQL Audit 2018 R2 has been released
About ApexSQL Audit: ApexSQL Audit is a SQL Server auditing and compliance 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, and provides out-of-the-box compliance templates such as HIPAA, GDPR, PCI. ApexSQL Audit saves captured information in a centralized auditing repository and provides comprehensive reports.
March 27, 2018
This article shows a quick overview of ERD aka data model diagrams created by reverse engineering most commonly used SQL Server sample databases. The models are shown in different layouts and styles, using the reverse engineering capabilities of ApexSQL Model which we plan to release in the nearby future.
March 22, 2018
ApexSQL Monitor 2018 R2 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.
March 21, 2018
The ApexSQL CI/CD toolkit Web dashboard is a standalone web dashboard that allows quick set up, configuration and execution of CI/CD workflow pipelines initiated manually, on a schedule or on a commit.
March 20, 2018
ApexSQL Source Control 2018 R3 has been released
About ApexSQL Source Control: ApexSQL Source Control is a SQL Server Management Studio add-in to version control SQL databases and objects. It integrates with all major source control systems and allows database developers to work together on a shared or a dedicated database copy. ApexSQL Source Control provides full object versioning features such as object locking with team policies management, detailed view of changes history, conflict resolution, labeling and more.
March 15, 2018
ApexSQL BI Monitor 2018 R2 has been released
About ApexSQL BI Monitor: ApexSQL BI Monitor is an agentless SQL Server Analysis, Integration, Reporting services and Windows performance monitoring tool. It is designed for monitoring performance metrics in real-time with built-in performance metrics information and tuning advice. It tracks performance counter categories such as MDX, a storage engine for SQL Server analysis services (SSAS), the pipeline for SQL Server integration services (SSIS), and web and windows service categories for SQL Server reporting services (SSRS) including a drill-down ability with time slicing for detailed performance analytics. ApexSQL BI Monitor provides configurable real-time alerting and alert notifications. ApexSQL BI Monitor generates detailed reports with information about the monitored system and on collected metrics data with the highest impact on the monitored SQL Server services.
March 15, 2018
ApexSQL Refactor is a SSMS and Visual Studio add-in which formats and refactors SQL code and objects using 15 code refactors and over 200 formatting options; locates and highlights unused variables, qualifies objects and expands wildcards, encapsulates SQL into views, procedure, safely renames SQL database parameters and objects and splits SQL tables without breaking dependencies.
March 14, 2018
ApexSQL VM Monitor 2018 R2 has been released
About ApexSQL VM Monitor: ApexSQL VM Monitor is an agentless virtualization monitoring tool that supports monitoring of Microsoft Hyper-V and VMware ESXi hypervisors. It tracks system performance metrics of monitored hypervisor hosts, host devices, and virtual machines. ApexSQL VM Monitor comes with the ability of real-time performance alerting based on predefined threshold values or established baselines. It is also able to generate detailed reports with information about the monitored hypervisors, virtual machines and their performance during specified periods of time.
March 9, 2018
ApexSQL Plan 2018 R2 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.
March 8, 2018
This article presents an overview of graphical dependency diagrams generated from most commonly used SQL Server sample databases shown in different layouts and styles, using the dependency rendering capabilities ApexSQL Analyze.
March 7, 2018