ApexSQL October 2017 newsletter - Big new versions of query plan analysis and recovery tools, fatal attraction and free upgrade promotion Click here to view this newsletter in your browser ApexSQL October 2017 newsletter In this newsletter we’ll be highlighting three major new releases along with some other fun stuff ApexSQL Plan In this, our second release of ApexSQL Plan, a new, free query execution analysis tool we have released a host of new features including History statistics comparison Save and open XML plans Open Query Store support Optimized Query Store Query Store dashboard Resource cost profile bars Stored procedure analysis See What’s new in ApexSQL Plan 2017 R2 or the ApexSQL Plan product page for more info ApexSQL Recover We also released a major new version of ApexSQL Recover. For years, customers have had to determine which tool to use for a recovery scenario, a transaction log approach the covered certain things like rogue updates or deletes or a non-transaction log approach for things like dropped or truncated tables. We even created a flow chart to help customers decide. Now that is all in the past. All recovery features and options have been consolidated in one tool, ApexSQL Recover. See What’s new in ApexSQL Recover 2018 or the ApexSQL Recover product page for more info What about ApexSQL Log? Well, we didn’t remove these features from ApexSQL Log and we are enhancing the log based features like forensic auditing (full row history, before and after), as well as continuous auditing, writing log history data directly to a database. Stay tuned for some features and enhancements coming out soon To mark the occasion, we are offering free upgrades to any customer interested in ApexSQL Recover (or ApexSQL Log) to ApexSQL DBA. So for the price of one of these individual tools, you can get the whole bundle of 8 tools. Contact sales, until the end of the month, if you are interested in this promotion ApexSQL Backup We have also recently released a new version of ApexSQL Backup with the following features Agentless deployment on remote servers Script generation for all supported jobs Backup plan for new databases Network resilience for all supported jobs Intelligent scheduling Restore individual objects See What’s new in ApexSQL Backup 2017 R5 or the ApexSQL Backup product page for more info Keep in mind that you can still get 3 licenses to ApexSQL Backup for free, just by filling out a simple survey Fatal attraction Ever fat fingers a SQL statement that resulted in lost or damaged data? Wouldn’t it be nice to have a guard against such fatal actions? In a recent article we posted, we cover three ways to deal with this including Before – fixing statements before they make it to production During – stopping execution of statements After – reversing the effects of such statements, when/if they happen See the full article here: Fatal action guard: guarding against inadvertent execution of code that may damage or destroy data in SQL Server Branches If you’ve been following our newsletter and using our products, you should be an expert on SQL source control now and ready for the next level! Branching is a great feature for teams that are really looking to get the most out of their source control setup. Here is a new article that covers this topic How to make SQL database version control safer with branches SSMS connection colors A neat new trick introduced recently in ApexSQL Complete is how setting connection colors. Here is a recent article on how to implement this feature: How to set different connection colors in SSMS GDPR is coming! Don’t get caught short with the new GDPR requirement. ApexSQL has you covered with a recent article General Data Protection Regulation (GDPR) compliance for SQL Server Brian Lockwood Founder and CEO @FightingCEO What's new Here is our most recent release ApexSQL Recover 2018 With the new release of ApexSQL Recover, you can read and analyze transaction log files and backups, load and filter auditing results in grid for forensic recovery and analysis, rollback and forward DML and DDL changes. It offers SQL Server 2017 support. We fixed 11 bugs and known issues. Usability and quality are improved ApexSQL Plan 2017 R2 The new ApexSQL Plan offers history statistics comparison, extended Query store, Query store dashboard, Resource cost profile bars and Stored procedure analysis. With the new release you can save and open XML plans and open Query Store support. We fixed 9 bugs and known issues. Usability and quality are improved ApexSQL Backup 2017 R5 The new ApexSQL Backup offers agentless deployment on remote servers, script generation for all supported jobs, backup plan for new databases, network resilience for all supported jobs, intelligent scheduling. You can restore individual objects. We fixed 11 bugs and known issues. Usability and quality are improved ApexSQL Source Control 2017 R6 The new ApexSQL Source Control provides support for Team Foundation Server 2018 RC2. We fixed 25 bugs and known issues. Usability and quality are improved ApexSQL Monitor 2017 R4 The new ApexSQL Monitor offers baseline threshold adjustment and Dashboard panel view. We fixed 22 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 How to use ApexSQL Source Control with local file system repositories How to link a SQL Server database to a Subversion repository ApexSQL Doc – Documenting SharePoint server farms ApexSQL DBA – General overview An introduction to ApexSQL Doc Blog Here are our most recent blog posts What’s new in ApexSQL Plan 2017 R2 What’s new in ApexSQL Recover 2018 ApexSQL Recover 2018 – Product update alert ApexSQL Complete 2017 R9 – Product update alert ApexSQL Plan 2017 R2– Product update alert ApexSQL Diff 2017 R4 – Product update alert What’s new in ApexSQL Backup 2017 R5 What’s New in ApexSQL Developer: ApexSQL Enforce, rules based best practices review ApexSQL Backup 2017 R5 – Product update alert ApexSQL Source Control 2017 R6 – Product update alert What’s next in ApexSQL DBA: ApexSQL VM Monitor – VMware and Hyper-V monitoring ApexSQL Monitor 2017 R4 – Product update alert ApexSQL Enforce – Screen shot tour 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 Fatal action guard: guarding against inadvertent execution of code that may damage or destroy data in SQL Server How to make SQL database version control safer with branches How to set different connection colors in SSMS General Data Protection Regulation (GDPR) compliance for SQL Server SQL Server performance monitoring – identifying problems using wait statistics and query wait analysis How to export SQL Server data to a CSV file Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog ApexSQL Doc – Permissions and requirements ApexSQL Enforce Command Line Interface CLI switches ApexSQL Audit main features overview How to fail at running rulebases Rules 101 – getting started with ApexSQL Enforce How to import new rules into an existing rulebase SQL Shack Here is a list of all SQL Shack articles published since our last newsletter SQL Server utilities you probably didn’t know about – SQLdiag, osql and SqlLocalDB Commonly used SQL Server Constraints: NOT NULL, UNIQUE and PRIMARY KEY ETL optimization using SQL Server TRY Functions Why would a SQL Server DBA be interested in Python? How SQL Server selects a deadlock victim How to import a flat file into a SQL Server database using the Import Flat File wizard Working with the SQL Server command line (sqlcmd) Monitoring SQL Server database status changes using T-SQL and PowerShell scripts Introduction and FAQs about Microsoft Azure technologies How to choose and check the right Database Recovery Model in accordance to your backup strategy Managing A Slowly Changing Dimension in SQL Server Integration Services The evolution of SQL Server towards Digital Transformation challenges Top 10 questions and answers about SQL Server Indexes How to automatically refresh a SQL Server database SQL Server Data Type Conversion Methods and performance comparison How to configure Always Encrypted in SQL Server 2016 using SSMS, PowerShell and T-SQL Review of SQL Cop unit tests collection What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL Audit 2017 R5 – The upcoming release of ApexSQL Audit will include AlwaysOn availability group support, dedicated before-after report and scheduler for exporting reports and data collection. Usability and quality will be improved. Read more ApexSQL CI/CD toolkit 2017 R2 – The upcoming release of ApexSQL CI/CD toolkit will offer Native plugins for Bamboo, Team Foundation Server, and Visual Studio Team Services. You'll be able to get notified when changes are detected in source control, before a build starts, trigger an automated build on changes in source control, review database based on built-in and custom written rules, publish NuGet packages using native plugins and PowerShell. Flexible pipeline creation. Usability and quality will be improved. Read more ApexSQL Enforce 2018 - The initial release of ApexSQL Enforce will include policy based rules enforcement for database objects and scripts covering configuration, performance, security, naming conventions, best practices and more. It will allow rulebases importing, rule changes and code differences viewing, along with multiple customizable warning thresholds, reports, imports/exports. It will be able to be run automatically as part of a continuous integration 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 - November 14 HRSSUG Virginia Beach, VA - November 15 SQL Malibu UG Los Angeles, CA - November 15 NetPASS Tyler, TX - November 15 SQL Saturday Parma, Italy - November 18 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
