ApexSQL January 2018 newsletter - ApexSQL BI Monitor released, major new versions for ApexSQL Backup, Audit and Complete Click here to view this newsletter in your browser ApexSQL January 2018 newsletter We have several new releases since the last newsletter and one new product, so let’s get busy ... ApexSQL BI Monitor The biggest news is the virgin release of ApexSQL BI Monitor, a web based tool for monitoring Microsoft Reporting (SSRS), Analysis (SSAS) and Integration services (SSIS) performance. Features in this initial release include: Supports SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, and 2005 Monitoring the most important SQL Server Analysis, Integration and Reporting Service performance metrics on multiple SQL Server instances Monitoring the most important operating system performance metrics on multiple machines Select performance metrics to monitor for each SQL Server service Custom configuration for all performance metrics A central repository database for storing historical data Graphical presentation of real-time and historical data Configurable historical data retention policy Manual data purging Three configurable alerting levels Performance metrics data baselining Automatic alerting when a user-defined or baseline threshold value is breached Security with three user profile permission levels Baseline threshold adjustment Predefined and custom reports Maintenance period scheduling GUI themes See the product update alert or the product page for more information. For an overview of the product, features and screen shots see What’s new in ApexSQL DBA: ApexSQL BI Monitor – Microsoft SQL Server services monitoring ApexSQL Backup 2018 We’ve released a new version of ApexSQL Backup with the following enhancements: High DPI and 4K resolution support New SSMS 17, Visual Studio 17 icons Added activity filtering by job status, event type, event time, event details Added activity exporting to PDF, HTML and XML formats Additional exporting options for Statistics Added alerts for all supported jobs Added intelligent old backup cleanup Added duration estimates for running jobs as well as 15 bug fixes See the product update alert or the product page for more information. Remember, you can get 3 free keys, no strings attached, just for filling out a short survey evaluating the product. Learn more ApexSQL Audit 2018 We released a major new version of ApexSQL Audit with the following enhancements: High DPI and 4K resolution support New SSMS 17, Visual Studio 17 icons Relative date filter Multiple client application instances support Auditing configuration for GDPR standard is added Out-of-the-box report for GDPR standard is added Scheduled reports can now be run on demand as well as 20 bug fixes See the product update alert or the product page for more information. To browse through some of the new features and screen shots, see the following articles: What’s new in ApexSQL Audit 2018 ApexSQL Audit 2018 – Screen shot tour ApexSQL Complete 2018 Last but not least, we’ve released a new version of ApexSQL Complete including: High DPI and 4K resolution support New SSMS 17, Visual Studio 17 icons Auto-complete hints list appearing time has been improved by up to 50% SQL database objects loading time has been improved by up to 10% as well as 26 bug fixes See the product update alert or the product page for more information. To browse through some of the new features and screen shots, see ApexSQL Complete 2018 – Screen shot tour ApexSQL Defrag Although we announced this new version last newsletter, we didn’t have the screen shot tour ready at the time, so here it is ApexSQL Defrag 2018 – Screen shot tour Brian Lockwood Founder and CEO @FightingCEO What's new Here are our most recent releases ApexSQL Monitor 2018 The release of ApexSQL Monitor 2018 offers support for High DPI and 4K resolution. We fixed 16 bugs and known issues. Usability and quality are improved ApexSQL Backup 2018 The release of ApexSQL Backup 2018 offers Additional filtering and exporting options for activities and for reports, Alerts for all supported jobs, Intelligent old backup cleanup, and Backup jobs duration estimates. Support for high DPI and 4K resolution is included. We fixed 15 bugs and known issues. Usability and quality are improved ApexSQL Audit 2018 The release of ApexSQL Audit 2018 offers Relative date filter and Support for multiple clients. ApexSQL Audit now supports high DPI and 4K resolution. We fixed 20 bugs and known issues. Usability and quality are improved ApexSQL Complete 2018 The release of ApexSQL Complete 2018 now supports high DPI and 4K resolution. We fixed 26 bugs and known issues. Usability and quality are improved ApexSQL BI Monitor 2018 The initial release of ApexSQL BI Monitor 2018 offers SQL Server Analysis, Integration and Reporting Services performance monitoring, System performance monitoring, Custom configuration for all metrics, Store historical data in a central repository database, and Real-time and historical graphical presentation of monitored metrics. Also, the release includes Automatic and manual data purging, Alerting with actions, Performance baselining, Baseline threshold adjustment, Reporting, Maintenance period scheduling, User authentication, and GUI themes See What's new for descriptions for all of our recent releases Videos Take a look at our most recent videos An introduction to ApexSQL Enforce Advanced auditing techniques – using the Watches feature Automatically creating SQL Server CRUD procedures An introduction to ApexSQL Unit Test An introduction to ApexSQL Trigger Blog Here are our most recent blog posts What’s next in ApexSQL Developer: ApexSQL Model – database diagramming ApexSQL Monitor 2018 – Product update alert ApexSQL Trigger 2017 R3 – Product update alert ApexSQL Complete 2018 – Screen shot tour What’s new in ApexSQL Audit 2018 ApexSQL Backup 2018 – Product update alert ApexSQL Audit 2018 – Screen shot tour ApexSQL Audit 2018 – Product update alert ApexSQL Defrag 2018 – Screen shot tour ApexSQL Complete 2018 – Product update alert ApexSQL BI Monitor 2018 – 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 create and use DML triggers in SQL Server using real world examples SQL Server true detective – Solving the case of the broken database 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 Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog Customizing rulebase and resultset grids for grouping, filtering, sorting, searching and displaying 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 SQL Shack Here is a list of all SQL Shack articles published since our last newsletter Top 8 new (or enhanced) SQL Server 2017 DMVs and DMFs for DBAs How to implement array-like functionality in SQL Server Using production data for testing in a post GDPR world How to integrate SQL Server and Azure Machine Learning Ola Hallengren’s SQL Server Maintenance Solution – Database integrity check How to plot a SQL Server 2017 graph database using PowerBI The importance of Python in SQL Server Administration Get more out of Python on SQL Server 2017 SQL Server Query Execution Plan for beginners – Types and Options How to plot a SQL Server 2017 graph database using SQL Server R SQL Server Query Store – Overview What’s new in SQL Server Management Studio 17.4; Always On AG dashboard enhancements and more Recently added keys We keep increasing the value of our bundles with new releases and pre-releases. Recently added keys include Dec 07, 2017 ApexSQL Analyze Available ApexSQL Developer Nov 22, 2017 ApexSQL BI Monitor Available ApexSQL DBA Nov 16, 2017 ApexSQL VM Monitor Pre-release 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 Enforce 2018 R2 – The new release of ApexSQL Enforce will offer Ignore options for object pairs, objects and script blocks, Customize user preferences for different options, Larger best practices rules library, and support for SQL Server Management Studio and Visual Studio integration. Usability and quality will be improved ApexSQL Model 2018 – The initial release of ApexSQL Model, a new database modeling tool will include database model diagrams, model diagrams customization, forward and reverse engineering, model history navigation, grouping, diagram layout and edge routing options, object appearance customization, and autosave option. This tool will be able to print model diagrams and export them into BMP, JPEG and PNG formats. Also, ApexSQL Model will offer support for Azure SQL Database, Amazon RDS for SQL Server and GUI themes ApexSQL Plan 2018 – The upcoming release of ApexSQL Plan will include History chart for live query execution, Execution plan comparison, Customizable keyboard shortcuts, Export execution plans from SQL Server to disk, Highlighted warnings, and High DPI and 4K resolution support. Usability and quality will be improved. Read more ApexSQL VM Monitor 2018 – The initial release of ApexSQL VM Monitor, a new virtualization monitoring tool will include Microsoft Hyper-V and VMware ESXi system and hardware performance monitoring along with virtual machine performance monitoring. This tool will be able to store metric historic data in a central repository database, show graphical presentation of historic data and provide real-time graphical presentation of monitored metrics. Also, ApexSQL VM Monitor will include custom configuration for all metrics, automatic and manual purging of historic data, automatic alerting with actions, individual alert management, performance baselining, baseline threshold adjustment, reporting, maintenance period scheduling, user authentication security, and GUI themes. 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 SQL Saturday 708 Cleveland, Ohio, United States - February 3 FairfieldPASS UG Stamford, CT - February 13 SQL Saturday 706 Wellington, New Zealand - February 17 HRSSUG Virginia Beach, VA - February 21 NetPASS Tyler, TX - February 21 SQL Malibu UG Los Angeles, CA - February 21 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
هیچ نظری موجود نیست:
ارسال یک نظر