ApexSQL Analyze 2018 R2 – Product update alert

ApexSQL Analyze 2018 R2 has been released

About ApexSQL Analyze: ApexSQL Analyze analyzes graphical SQL Server database object dependencies and the impact of potential deletions on your SQL database. It determines object interrelationships within the database, and allows dependency diagrams appearance customization

August 10, 2018

ApexSQL Doc 2018 R2 – Product update alert

ApexSQL Doc 2018 R2 has been released

About ApexSQL Doc: ApexSQL Doc is a documentation tool for SQL Server instances, databases, objects, SQL Server Integration Services packages, SQL Server Analysis Services cubes, SQL Server Reporting Services reports, Tableau server sites and SharePoint Server farms. It generates comprehensive documentation in a number of formats including CHM, HTML, Microsoft Word’s DOC and DOCX, and PDF.

August 2, 2018

ApexSQL Data Diff 2018 R4 – Product update alert

ApexSQL Data Diff 2018 R4 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.

July 31, 2018

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