ApexSQL December 2017 newsletter II - New major releases for Defrag, Compare, Data Diff and CICD toolkit, 5 for 5 discount Click here to view this newsletter in your browser ApexSQL December 2017 newsletter II We have some exciting news in this cycle with the release of several new products ApexSQL Defrag ApexSQL Defrag 2018, a DBA tool for index analysis, reporting and defragmentation, was released on Dec 21st, with the following enhancements: Index fragmentation and size prediction Missing index alerts Custom severities for policy alerts Resource check parameters for executing job count, active transaction count and transaction log usage percentage Email notification events for policy execution success, failed, warning, expired, cancelled. High DPI and 4K resolution support Usability improvements Improved quality with 16 bug fixes For more information about ApexSQL Defrag 2018, see the product page ApexSQL Compare ApexSQL Compare is a tool for file and folder comparison that is tightly coupled with SQL Server and can be implemented as an add-in in both SQL Server Management Studio and Visual Studio. Enhancements in the new 2018 version include: Integrated file editor Save as batch feature is added under the Save button from the Home tab High DPI and 4K resolution support CLI switches: Set the file size type for the files that will be ignored with the /ignore_bigger_than switch [/fst]: Byte KB MB GB TB Default [dft] – MB Set the author name for the comparison report [/auth] Set the legal information for the comparison report [/leg] For more information about ApexSQL Compare 2018, see the product screen shot tour and/or the product page ApexSQL Data Diff ApexSQL Data Diff 2018 has been released with a new look and feel, including new icons, High DPI and 4K resolution support. The new version also includes 19 bug fixes. For more information about ApexSQL Data Diff 2018, see the product screen shot tour and/or the product page ApexSQL CI/CD toolkit Although not versioned as a major/2018 release, the new version of the ApexSQL CI/CD toolkit PowerShell scripts has several, major new features including integration of the new “Review” step using ApexSQL Enforce and more: The pipeline job summary log file contains more detailed and descriptive information E-mail notifications contain more detailed and descriptive information about start/end time, executed steps and created output files Review step is added to check database objects and scripts by pre-configured rules Documentation step can now document database changes only NuGet package output Support for pushing/fetching NuGet packages to/from a NuGet feed Beep sound is added upon the pipeline completion/failure Step in-line new switches to include/exclude output files: [-NoScript] – exclude script output files for the Build, Populate, Schema sync, and Data sync steps [-NoReport] – exclude report output file for the Test, Review, Schema sync, and Data sync steps [-NoSummary] – exclude summary output files for the Schema sync and Data sync steps [-NoWarnings] – exclude warning output files for the Schema sync and Data sync steps Switch for creating output for SQL scripts files added to the populate step [/on] Pipeline return codes: 0 – Success – all steps in the pipeline were executed successfully 1 – Failure – one of the steps in the pipeline has failed or an error is encountered The ApexSQL CICD toolkit PowerShell scripts are free, open sourced and fully documented. The toolkit allows you to quickly and easily create Continuous integration (CI) and Continuous deployment (CD) pipelines, using ApexSQL developer tools. To help new users get stated, we’ve create the article, ApexSQL CI/CD toolkit PowerShell scripts initial setup and configuration All of our CICD technical content can be see via ApexSQL CI/CD knowledgebase – Table of contents Discounts 5 for 5. We are offering a special on 5 licenses of ApexSQL DBA for $5,000, a savings of $3,745, until the end of the year. Contact us to get a quote and lock in this offer for 30 days. Recently added keys/products If you have an ApexSQL bundle that is currently under subscription, we have some new keys for you! Just go to the Resend keys page to have them emailed to you for free Dec 18, 2017 ApexSQL Model ApexSQL Developer Dec 07, 2017 ApexSQL Analyze ApexSQL Developer Nov 22, 2017 ApexSQL BI Monitor ApexSQL DBA Nov 16, 2017 ApexSQL VM Monitor ApexSQL DBA Sep 29, 2017 ApexSQL Enforce ApexSQL Developer * All products are included in ApexSQL Universal Brian Lockwood Founder and CEO @FightingCEO What's new Here are our most recent releases ApexSQL Data Diff 2018 The release of ApexSQL Data Diff 2018 now supports high DPI and 4K resolution. We fixed 19 bugs and known issues. Usability and quality are improved ApexSQL Defrag 2018 The release of ApexSQL Defrag 2018 offers index fragmentation and size prediction, missing index alerts, custom severities for policy alerts, resource check parameters for executing job count, active transaction count and transaction log usage percentage. ApexSQL Defrag also provides email notification events for policy execution success, failed, warning, expired, cancelled. ApexSQL Defrag now supports high DPI and 4K resolution. We fixed 16 bugs and known issues. Usability and quality are improved ApexSQL Compare 2018 The release of ApexSQL Compare 2018 offers integrated file editor, Save as batch option and 3 new CLI switches. ApexSQL Compare now supports high DPI and 4K resolution. We fixed 23 bugs and known issues. Usability and quality are improved ApexSQL CI/CD toolkit 2017 R2 The release of ApexSQL CI/CD toolkit 2017 R2 offers flexible pipeline creation, reviewing database based on built-in and custom written rules, publishing NuGet packages using PowerShell, documentation of database changes only, scripting folder as datasource. ApexSQL CI/CD toolkit now features a new CI step called Review step. We fixed 12 bugs and known issues. Usability and quality are improved ApexSQL Generate 2017 R2 The release of ApexSQL Generate 2017 R2 offers the granularity option to create one SQL script or one SQL script per object. It also features 2 new CLI switches. We fixed 17 bugs and known issues. Usability and quality are improved See What's new for descriptions for all of our recent releases Videos Take a look at our most recent videos Advanced auditing techniques – using the Watches feature Automatically creating SQL Server CRUD procedures An introduction to ApexSQL Unit Test An introduction to ApexSQL Trigger An introduction to ApexSQL Data Diff Blog Here are our most recent blog posts ApexSQL Data Diff 2018 – Screen shot tour ApexSQL Data Diff 2018 – Product update alert ApexSQL Source Control 2018 – Product update alert ApexSQL Monitor 2017 R6 – Product update alert ApexSQL Defrag 2018 – Product update alert ApexSQL Compare 2018 – Product update alert ApexSQL Compare 2018 – Screen shot tour ApexSQL CI/CD toolkit 2017 R2 – Product update alert ApexSQL Plan 2017 R3 – Product update alert ApexSQL Generate 2017 R2 – Product update alert ApexSQL Doc 2017 R7 – 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 monitor and detect SQL Server round-trip performance issues using custom designed metrics How to update a SQL database from source control while avoiding dependency errors How to add self data change auditing capabilities to commercial, shrink-wrapped software with a SQL Server backend How to analyze query performance characteristics in SQL Server How to execute an unattended best practices review against a database Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog ApexSQL CI/CD toolkit PowerShell scripts initial setup and configuration Manual review of CI/CD pipeline outputs Inventory of the CI/CD pipeline output files ApexSQL CI/CD toolkit FAQs about notifications, outputs and summaries How to calculate baseline for less than seven days of historical data SQL Shack Here is a list of all SQL Shack articles published since our last newsletter What’s new in SQL Server Management Studio 17.4; SQL Vulnerability assessment and more 6 methods to write PowerShell output to a SQL Server table How to use sargable expressions in T-SQL queries; performance advantages and examples SQL Server read-ahead mechanism; concept and performance gains How to enable and disable the Identity Cache in SQL Server 2017 How to implement a graph database in SQL Server 2017 How to create Excel reports based on SSAS information What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL Audit 2018 – The upcoming release of ApexSQL Audit will offer Relative date filter and support for multiple clients and High DPI and 4K resolution. Usability and quality will be improved. Read more ApexSQL BI Monitor 2018 – The new release of ApexSQL BI Monitor will offer SQL Server Analysis, Integration and Reporting Services performance monitoring, system performance monitoring, custom configuration for all metrics, storing historical data in a central repository database, real-time and historical graphical presentation of monitored metrics, automatic and manual data purging, alerting with actions, performance baselining, baseline threshold adjustment, reporting, maintenance period scheduling, user authentication. Usability and quality will be improved. Read more ApexSQL Build 2018 – The new release of ApexSQL Build will offer Include static data from a script folder, support for SQL Server 2017 and High DPI and 4K resolution. Usability and quality will be improved ApexSQL Complete 2018 – The new release of ApexSQL Complete will offer support for high DPI and 4K resolution. Usability and quality will be improved. Read more ApexSQL Enforce 2018 R2 – The upcoming release of ApexSQL Enforce will include Ignore options for object pairs, objects and script blocks, Customize user preferences for different options, Multi-object type rules, Larger best practices rules library, support for SQL Server Management Studio and Visual Studio integration, and Graphical and tabular resultset reports. Usability and quality will be improved Stay tuned for more releases and new products on our What's next page Events Here are some upcoming events we are sponsoring FairfieldPASS UG Stamford, CT - January 9 HRSSUG Virginia Beach, VA - January 17 NetPASS Tyler, TX - January 17 SQL Malibu UG Los Angeles, CA - January 17 SQL Saturday 708 Cleveland, Ohio, United States - February 3 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
هیچ نظری موجود نیست:
ارسال یک نظر