ApexSQL Audit fault tolerant auditing – part I

What is fault tolerant auditing and why it is important

One of the characteristics a SQL Server auditing solution must have is to be reliable. It means that it is a solution you can trust, that doesn’t provide a false sense of security while in fact it is not auditing the parameters set, has information leak, data loss, or in some situations it’s not running at all

ApexSQL Audit is designed to be fault tolerant and handle the situations which can bring to auditing breakdowns

August 12, 2013

ApexSQL Complete 2013 released

Raleigh – July 26, 2013 – ApexSQL, a Microsoft Gold Certified Partner and major provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Complete 2013. The new version includes performance improvements as well as many other new features

July 26, 2013

SQL Solution center round-up – July 5th, 2013

In the latest SQL Solution center articles we focused on SQL Server database auditing techniques and recovery options

Here is the aggregated summary for the past two weeks:

July 12, 2013

5 new views of ApexSQL Diff

Here are some new screen shots for ApexSQL Diff we recently cut, highlighting various UI features

July 11, 2013

SQL Server data comparison customized for performance – vertical filtering and Comparison options

As the previous post indicated, we will focus now on vertical filtering and comparison options.

ApexSQL Data Diff also provides the ability to choose only specific columns to be analyzed aka vertical filtering. By default, all columns are analyzed. You can choose which columns to analyze by selecting the object containing those columns clicking on the appropriate Columns field, and deselecting the columns you want to exclude.

July 11, 2013

SQL Server data comparison customized for performance – the data cache location and Object filter

Comparison and synchronization of SQL Server database data from different data sources can be very time and resource demanding. It is highly dependant on hard drive writing speed, network bandwidth, memory size and speed, CPU speed, and the size of the data. Therefore, ApexSQL Data Diff, a SQL tool for data comparison, incorporates some options that could help you get better performance and increase comparison speed.

July 9, 2013

ApexSQL Version 2013 – Product update alert

ApexSQL Source Control 2013 has been released

Type: New version

About ApexSQL Source Control: ApexSQL Source Control is a SQL Server Management Studio add-in, which allows you to version control SQL databases and objects directly inside SSMS. It integrates with all major source control systems and provides you with all object versioning features, without the need for an additional source control client.

July 7, 2013

ApexSQL Complete 2012 R3 – Product update alert

ApexSQL Complete 2012 R3 has been released

Type: Maintenance release

About ApexSQL Complete: ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in which speeds up coding. It completes SQL code statements automatically, fills in SQL code fragments, highlights syntax errors and much more.

July 7, 2013

ApexSQL Profile 2012 R2 – Product update alert

ApexSQL Profile 2012 R2 has been released

Type: Maintenance release

About ApexSQL Profile: ApexSQL Profile is a SQL Server Management Studio add-in which allows performance profiling of stored procedures and user defined functions. It tracks SQL code performance at the line level and generates comprehensive reports containing statement execution times, variable and parameter changes and more.

July 7, 2013