ApexSQL Script 2018 R2 – Product update alert

ApexSQL Script 2018 R2 has been released

About ApexSQL Script: ApexSQL Script is a SQL Server tool that scripts database objects and data into a SQL scripts, C# solutions and executable installers. It can export live databases directly to source control and can automate and schedule the migration processes.

December 18, 2018

ApexSQL Monitor 2018 R8 – Product update alert

ApexSQL Monitor 2018 R8 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, Azure SQL Database, 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 and AzureSQL Database 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.

December 18, 2018

Unit testing in ApexSQL tools / add-ins

What is unit testing

Unit testing is a software testing method where individual functional source code units are tested to determine if each unit (i.e. procedure, function) works the way it was intended to.

December 11, 2018

ApexSQL Build 2018 R3 – Product update alert

ApexSQL Build 2018 R3 has been released

About ApexSQL Build: ApexSQL Build is a SQL database deployment tool that builds new databases and updates existing ones by packaging SQL scripts, SQL script folders, database snapshots, and scripts under version control into a single deployment SQL script, a C# solution, or an executable installer. It allows specifying the objects to be created or updated, ensures error-free deployment, and more.

December 10, 2018

ApexSQL DevOps toolkit 2018 R6 – Product update alert

ApexSQL DevOps toolkit 2018 R6 has been released

About ApexSQL DevOps toolkit: ApexSQL DevOps toolkit is a set of open source PowerShell cmdlets for automating work flow pipelines to integrate database changes, test and deliver to production. It supports integration with Bamboo, Jenkins, TeamCity, AppVeyor, GoCD, CruiseControl, Hudson, Visual Studio Team Services, Team Foundation Server, and other CI/CD servers. It contains predefined Continuous Integration (CI) and Continuous Delivery (CD) PowerShell script templates for standalone use where all pipeline steps can be customized, reordered, added and removed. It also contains a native TeamCity, a native Atlassian Bamboo, a native Jenkins continuous integration server plugin and a standalone Web dashboard for configuration and execution of CI and CD workflow pipelines via point and click graphical interface.

December 4, 2018

ApexSQL Search 2018 – Screen shot tour

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

December 3, 2018

ApexSQL Diff 2018 R3 – Product update alert

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

November 29, 2018

ApexSQL Plan 2018 R5 – Product update alert

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

November 22, 2018