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, 2018ApexSQL Propagate 2018 R2 – Product update alert
ApexSQL Propagate 2018 R2 has been released
About ApexSQL Propagate: ApexSQL Propagate is a tool that can execute multiple SQL scripts on multiple SQL databases located over multiple SQL Server instances with one-click. Before SQL scripts execution it can parse the scripts to check if their execution will pass or fail. SQL script execution results can be exported into plain text or CSV files.
November 20, 2018ApexSQL Complete 2018 R7 – Product update alert
ApexSQL Complete 2018 R7 has been released
About ApexSQL Complete: ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in, that speeds up coding by automatically completing SQL code statements, filling in SQL code fragments and more.
November 20, 2018ApexSQL Search 2018 R4 – Product update alert
ApexSQL Search 2018 R4 has been released
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.
November 13, 2018ApexSQL Unit Test 2018 R2 – Product update alert
ApexSQL Unit Test 2018 R2 has been released
About ApexSQL Unit Test: ApexSQL Unit Test is a SQL Server Management Studio add-in, to maintain and run SQL database unit tests. It allows you to create unit tests and organize them in test classes. In addition, a single test case can be executed, as well as all tests from a single class or all tests against a single database with just a single click. Test execution can be automated using the CLI, along with exporting test execution results to XML, SQL script, or SQL database table.
November 9, 2018ApexSQL Log 2018 R3 – Product update alert
ApexSQL Log 2018 R3 has been released
About ApexSQL Log: ApexSQL Log is an auditing and recovery tool for SQL Server databases that reads database transaction logs and audits, reverts, or replays data and object changes affecting the database. It restores updated or missing data and objects, and captures information on the user, application and host used to make each change.
November 8, 2018ApexSQL Audit 2018 R7 – Product update alert
ApexSQL Audit 2018 R7 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.
November 7, 2018ApexSQL BI Monitor 2018 R6 – Product update alert
ApexSQL BI Monitor 2018 R6 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
November 7, 2018ApexSQL Refactor 2018 R4 – Product update alert
ApexSQL Refactor 2018 R4 has been released
About ApexSQL Refactor: ApexSQL Refactor is a SQL Server Management Studio and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 15 refactors such as table partitioning, safe rename, wildcard expansion and more.
November 5, 2018ApexSQL DevOps toolkit 2018 R5 – Product update alert
ApexSQL DevOps toolkit 2018 R5 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 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.
November 1, 2018