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

ApexSQL Diff 2018 R2 – Product update alert

ApexSQL Diff 2018 R2 has been released

About ApexSQL Diff: ApexSQL Diff is a SQL Server and Azure SQL database comparison and synchronization tool which detects differences between database objects and resolves them without errors. It compares and synchronizes live databases, native or natively compressed database backups, database snapshots, scripts in source control and script folders and generates comprehensive reports on the detected differences.

July 13, 2018