ApexSQL Monitor 2018 R6 – Product update alert

ApexSQL Monitor 2018 R6 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.

July 30, 2018

ApexSQL Generate 2018 – Screen shot tour

Once ApexSQL Generate is started, the New project window is shown. In the first Data source tab, the source of metadata can be defined. It can be chosen between a live a database of SQL script. If the Live database data source is chosen, SQL Server, the way of authentication and a database can be provided:

July 26, 2018

ApexSQL Generate 2018 – Product update alert

ApexSQL Generate 2018 has been released

About ApexSQL Generate: ApexSQL Generate is a tool that can populate SQL databases with test data using multiple generators for each column. It supports a full range of SQL data types and has an ability to recognize them in a loaded SQL database and provide real-world test data based on contained data types. It can generate: randomized test data using the Random generator and various options, and using the Regular expression generator, sequential data using the Incremental generator, and much more.

July 26, 2018

Why you need to integrate data auditing into your SQL Server database continuous integration process

Why auditing?

Providing a detailed, accurate and current audit trail for your database is no longer optional. With GDPR and other corporate governance requirements, as well as regular risk-mitigation, auditing is a requirement that can no longer be ignored, especially if it can be integrated quickly and easily, even in a dynamic environment using continuous integration and delivery.

July 26, 2018

ApexSQL Audit 2018 R5 – Product update alert

ApexSQL Audit 2018 R5 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.

July 23, 2018

Visual dependency viewer feature deprecated in ApexSQL Search 2018

The Dependency viewer is a feature that allows you to visualize all SQL objects’ dependencies, including relationships affecting encrypted objects, system objects, SQL 2014 objects or objects stored in databases encrypted with Transparent Data Encryption (TDE).

Unfortunately, this feature has been discontinued in ApexSQL Search along with the new 2018 release. We apologize for any inconvenience this may cause to existing users. The good news is that the newer feature is faster, more robust, offers more features as well as a modern UI, 4K/high resolution support etc

July 19, 2018

ApexSQL Search 2018 – Product update alert

ApexSQL Search 2018 has been released

Type: Major feature release

About ApexSQL Search: ApexSQL Search is a SQL Server Management Studio and Visual Studio add-in, for SQL object and data text search, managing extend properties, rename objects without breaking dependencies.

July 19, 2018

ApexSQL Enforce 2018 R3 – Product update alert

ApexSQL Enforce 2018 R3 has been released

About ApexSQL Enforce: ApexSQL Enforce is a best practices enforcement tool for SQL Server database objects and scripts. It comes with an integrated editor featuring code auto-complete for writing custom rules and has more than 100 out of the box rules covering SQL best practices, naming conventions, potential configurations and more.

July 19, 2018

Announcing performance monitoring for Azure SQL Database and Amazon Web Service RDS for SQL Server

Starting with the latest 2018 R5 release of ApexSQL Monitor, ApexSQL is now offering support for performance monitoring for Azure SQL Database, Azure SQL Database Managed Instance and Amazon Web Service RDS for SQL Server. While end users do not have control over the cloud hardware and operating system, ApexSQL Monitor allows database Administrators to gain the control over database performance.

July 17, 2018

ApexSQL BI Monitor 2018 R4 – Product update alert

ApexSQL BI Monitor 2018 R4 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

July 16, 2018