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 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
ApexSQL is happy to announce that very soon all of our tools/add-ins will support the first public preview version of Visual Studio 2019.
Add-in only products should support Visual Studio 2019 in December 2018.
December 12, 2018
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 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 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 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 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 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
This article will represent the recommended working model for database DevOps to create SQL Server database continuous integration and continuous delivery pipelines with a set of SQL developer tools.
November 21, 2018