ApexSQL June 2018 newsletter - ApexSQL CI/CD Web dashboard and new major version of ApexSQL Diff released, new ApexSQL Enforce features highlighted with a 50% discount offered to all subscribers Click here to view this newsletter in your browser ApexSQL June 2018 newsletter In this newsletter, we’ll be highlighting the first release of ApexSQL CI/CD Web dashboard and new, improved versions of ApexSQL Diff and ApexSQL Enforce. We also prepared a 50% discount on all ApexSQL Enforce purchases, for all newsletter subscribers. ApexSQL CI/CD Web dashboard We are proud to announce the release of ApexSQL CI/CD toolkit Web dashboard, a standalone Web dashboard for configuration and execution of CI and CD workflow pipelines via point and click graphical interface This release includes the following features: Standalone graphical web user interface Continuous integration Build a SQL Server database directly from source control, and optionally include static data Fill empty tables with synthetic data Integrate trigger-based audit trails and reporting into change sensitive database objects Generate full or differential documentation for the SQL Server database Test SQL Server database using unit tests Enforce database best practices by reviewing, detecting and fixing issues Create a clean database package for easy deployment Publish package to a designated NuGet feed Continuous delivery Compare SQL Server database schemas and create a script for schema synchronization Compare SQL Server static data and create a script for data synchronization Push schema and data changes to a target database Archive all output files in a central folder Fill empty tables with synthetic data Support for multiple data source types SQL Server database Source control (Git, Mercurial, Perforce, Team Foundation Server, Subversion) SQL script Script folder NuGet package (local or feed) Automatically create rollback scripts Flexible pipelines Predefined user roles Per user CI/CD pipeline access Visual themes See the product update alert or What’s new in ApexSQL SQL Developer: ApexSQL CI/CD toolkit Web dashboard for more info ApexSQL Diff 2018 We’ve also released a new version of ApexSQL Diff, with several significant new features and improvements: Export dependencies, actions, warnings and executions results into 6 different output types: Text file (*.txt) Web page (*.html) PDF (*.pdf) CSV (Comma delimited) (*.csv) Excel workbook (*.xlsx) XML file (*.xml) Visual themes Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. New UI features and functionality SQL Server Management Studio 17 version is added as an option to open the synchronization script in the Options window under the Output tab SSIS package store for SQL Server 2017 is added under the Add integration services packages window The dataspaces [ids] and data compression [idc] attribute values are added for the /ignore_table_attributes CLI switch To learn more, please visit the ApexSQL Diff product page and/or see the recent product update alert ApexSQL Enforce 2018 R2 In the last newsletter, we’ve unjustly neglected our new, much improved version of ApexSQL Enforce. To make up for this, we’re bringing it to you now in full detail, and with 50% discount… 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. The 2018 R2 release brings many important enhancements: High DPI and 4K resolution support Applied concepts of Visual Language Dictionary for Visual Studio for iconography, imagery, colors, menus, fonts, formatting and other GUI elements Ignore options for object pairs, objects and script blockSupport for SQL Server Management Studio 2012 integration and higher Support for Visual Studio 2010 integration and higher Project file can now be saved as a batch file CLI switches: Run all rules from the selected rulebase [/rar] Specify the ignore file path [/if:arg] Run only checked rules [/rcr:arg] In the Result summary form the following is now available: Graphical representation of the resultset Detailed rule execution results by category and type Added more than 30 new rules To learn more, please visit the ApexSQL Enforce product page and/or see the recent product update alert Discounts As already announced, we are offering 50% discount on ApexSQL Enforce purchases for all our subscribers. This means that until the next newsletter, you can purchase ApexSQL Enforce Professional edition for only $249 $499, while you can get ApexSQL Enforce Standard edition for as little as $149 $299. Interested? Contact sales to claim your 50% discount or use ENFORCE50 promo code for online purchases Kristina Stanisavljevic Marketing team @kicko_kiki What's new Here are our most recent releases ApexSQL Diff 2018 This release of ApexSQL Diff 2018 comes with an option to export dependencies, actions, warnings and executions results into 6 different output types. Visual themes, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts have been applied. New UI features and functionality are added. SQL Server Management Studio 17 version is added as an option to open the synchronization script in the Options window under the Output tab. SSIS package store for SQL Server 2017 is added under the Add integration services packages window. The dataspaces [ids] and data compression [idc] attribute values are added for the /ignore_table_attributes CLI switch. Beside these features, usability and quality are improved with 39 bugs and known issues fixed. ApexSQL CI/CD toolkit 2018 R2 This release of ApexSQL CI/CD toolkit 2018 R2 comes with the Web dashboard. Users now get notified when changes are detected in source control, before a build starts. Automated build can be triggered on changes in source control. Beside these features, usability and quality are significantly improved. ApexSQL Complete 2018 R4 In this release of ApexSQL Complete 2018 R4 password authentication support has been added to the active directory. Beside these improvements, usability and quality are improved with 5 bugs and known issues fixed. ApexSQL Monitor 2018 R4 In this release of ApexSQL Monitor 2018 R4 report generation performance has been improved up to 350% for large datasets. Beside these improvements, usability, quality and performance are improved with 18 bugs and known issues fixed. ApexSQL VM Monitor 2018 R3 The new feature of ApexSQL VM Monitor 2018 R3 is baseline threshold adjustment. Along with this new feature, usability, quality and performance are significantly improved with 73 bugs and known issues fixed. ApexSQL Enforce 2018 R2 Some of the new features of ApexSQL Enforce 2018 R2 include more than 30 new rules, ignore options for object pairs, objects and script blocks, support for SQL Server Management Studio and Visual Studio integration, project file can now be saved as a batch file, High DPI and 4K resolution support, improved the Result summary form, additional CLI switches. Along these new features, usability and quality are also improved with 6 known bug fixes See What's new for descriptions of all of our recent releases Videos Take a look at our most recent videos An introduction to ApexSQL Decrypt An introduction to ApexSQL Diff An introduction to ApexSQL BI Monitor An introduction to ApexSQL VM Monitor An introduction to ApexSQL Enforce Blog Here are our most recent blog posts ApexSQL Diff 2018 – Product update alert ApexSQL CI/CD toolkit 2018 R2 – Product update alert ApexSQL Model and ApexSQL Diff; better together New user interface features and functionality in ApexSQL 2018 versions What’s new in ApexSQL CI/CD toolkit - TeamCity build server plugin ApexSQL Complete 2018 R4 - Product update alert ApexSQL Monitor 2018 R4 - Product update alert ApexSQL Model 2018 - Screenshot tour ApexSQL VM Monitor 2018 R3 - Product update alert ApexSQL BI Monitor 2018 R3 - Product update alert Solution center Our Solution center is a content site with in-depth articles focusing on tough nuts that DBAs and developers are challenged with Here are our most recent articles How to troubleshoot SQL Server performance problems using the SSMS Performance Dashboard How to master SQL Server performance baselining to avoid false positives and/or missing alerts How to implement compliance with GDPR for SQL Server How to create and optimize SQL Server indexes for better performance Visual tools for monitoring SQL Server query performance Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog Reverse engineering a data source to a new model Exporting schema comparison results to Excel How to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio How to enforce best practices rules against your database How to integrate ApexSQL CI/CD toolkit with Bamboo server SQL Shack Here is a list of all SQL Shack articles published since our last newsletter SQL Server Database Backup and Restore reports How to handle the SQL Server WRITELOG wait type Top 50 collection of SQL Server interview questions How to “debug” a Linked Server from SQL Server to an Oracle Database instance Partial stored procedures in SQL Server The Difference between CROSS APPLY and OUTER APPLY in SQL Server Batch Requests/sec or Transactions/sec: what to monitor and why How to Sync Azure SQL databases and on-premises databases with SQL Data Sync Data science, data understanding and preparation – basic work with datasets What is SQL Data Sync Tail-Log Backup and Restore in SQL Server Maintaining SQL Server indexes Query optimization techniques in SQL Server: the basics Real-time streaming in Power BI SQL Server Database Backup and Restore operations using the Cloud Gathering SQL Server indexes statistics and usage information Connecting to Azure SQL Database Step by step installation of SQL Server 2017 Backup Linux SQL Server databases using PowerShell and Windows task scheduler Understanding benefits of Graph Databases over Relational Databases through Self-Joins in SQL Server Securing access for SQL Server auditing Tracing and tuning queries using SQL Server indexes How to perform a page level restore in SQL Server Restricting and monitoring SQL Server data access with views and procedures Recently added keys We keep increasing the value of our bundles with new releases and pre-releases. Recently added keys include Feb 14, 2018 ApexSQL Model Available ApexSQL Developer Jan 31, 2018 ApexSQL Job Available ApexSQL DBA Jan 24, 2018 ApexSQL Pump Pre-release ApexSQL Developer Dec 07, 2017 ApexSQL Analyze Available ApexSQL Developer Nov 22, 2017 ApexSQL BI Monitor Available ApexSQL DBA Nov 16, 2017 ApexSQL VM Monitor Available ApexSQL DBA Sep 29, 2017 ApexSQL Enforce Available ApexSQL Developer All pre-releases can be pre-ordered with a 50% discount using the code PREORDER2018 What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL Script 2018 - The upcoming release of ApexSQL Script includes a variety of Visual themes and high DPI 4K resolution support. Along with these features, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts are also applied. Usability and quality are also improved. ApexSQL Generate 2018 - The upcoming release of ApexSQL Generate will offer High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved ApexSQL Search 2018 - The upcoming release of ApexSQL Search will offer Visual themes, High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved ApexSQL Source Control 2018 R4 - The upcoming release of ApexSQL Source Control will offer High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved ApexSQL Doc 2018 - The upcoming release of ApexSQL Doc will offer Active directory authentication, Azure SQL Database - Managed Instance, High DPI and 4K resolution support. Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved. Read more ApexSQL Monitor 2018 R5 - The upcoming release of ApexSQL Monitor will offer basic support for both Azure SQL Database and Amazon RDS for SQL Server. Usability and quality will be improved. Read more Stay tuned for more releases and new products on our What's next page Events Here are some upcoming events we are sponsoring HRSSUG June 2018 Meeting Hamptons Road, USA - Jun 20 AWS EC2 and RDS by Richard Waymire Malibu, CA - Jun 20 Steel City SQL June Meeting Birmingham, AL - Jun 19 ApexSQL LLC | 11312 US 15-501 N, suite 107-212 | Chapel Hill, NC, 27517 | USA Phone: +1 (866) 665-5500 Email: sales@apexsql.com To unsubscribe from further mailings, please click here
from Gmail
via IFTTT
هیچ نظری موجود نیست:
ارسال یک نظر