ApexSQL June 2017 newsletter - New query plan viewing and analysis tool released, new major release of ApexSQL Complete with export to Excel, CRUD and execution alerts Click here to view this newsletter in your browser ApexSQL June 2017 newsletter New, free product: ApexSQL Plan We have big news to announce in this newsletter with the general availability of a new, and free, product, ApexSQL Plan, a SQL Server query plan analysis and viewing tool that can be used stand alone or as an SSMS add-in. Here is a brief summary of features: Layouts panel Live query plans Manipulation with the query plan graphical elements Query execution plans Customized data flow properties Customized operation properties Operation cost highlight Join diagram Line level statements analysis Query plan XML viewer Missing index details Table I/O Expressions Parameters Plan tree and top operations Query columns Wait stats Deadlock analysis Multiple query tabs History and comments Query performance Query store Customizable data flow line thickness Even though this product will roll off the assembly line with a ton of features, we still have an aggressive roadmap of additional features planned. For more information please see the product page. New major version: ApexSQL Complete We have also released a new, major version of ApexSQL Complete (still free) with three new features: CRUD procedure generation Export to Excel And query execution alerts New feature version: ApexSQL Defrag The last of our major releases, this newsletter cycle is ApexSQL Defrag with the following new features: Limited, sampled and detailed index scanning modes Fast and deep index analysis, Cancel pending jobs Predefined policies and policy templates Separate section for alerts Filter, group and export alerts Filter activities You can learn more about this features via the following article, What’s new in ApexSQL Defrag 2017 R3. Other new releases We have released 8 new versions of existing tools to add support for SQL Server 2017 CTP 2, SSMS 17 and Amazon RDS along with various bug fixes. You can see the full list below in the “What’s new” section. What’s next As announced last newsletter, ApexSQL will be releasing a new, free product on or before June 21st, ApexSQL Compare, a SQL script comparison and merging tool with stand-alone and SSMS/VS add-in versions. For more information see the Product page and/or ApexSQL Compare 2017 – Screen shot tour. 3 Free licenses to ApexSQL Monitor Have you been holding off on ApexSQL Monitor until it got a web interface? With the new 2017 version, there are no more excuses to not try this new tool, especially as we are still offering 3 free licenses, just for filling out a short (10 minute long) survey with various questions about its features and functionality. What do you have to lose? See more details on this offer here: Fill out a survey, get 3 FREE keys to ApexSQL Monitor for your company! Note that we offer free keys for ApexSQL Source Control and ApexSQL Backup as well. SQL DLM news Interested in SQL Server database continuous integration and delivery? Does your company already use a 3rd party build server like Jenkins or TeamCity? If so, we’ve got some great new articles for you: How to integrate the ApexSQL CI/CD toolkit with Jenkins serverHow to integrate the ApexSQL CI/CD toolkit with TeamCity server Each month we’ll be adding more articles covering other build servers. The ApexSQL CI/CD toolkit is a free collection of opensource PowerShell scripts hosted on our GitHub account that allow you to automate CI/CD workflows using ApexSQL tools. Soon we’ll be offering two more implementation of the CI/CD toolkit: Web UI dashboard and build server plug-ins. Brian Lockwood Founder and CEO @FightingCEO What's new Here are our most recent releases ApexSQL Plan 2017 Initial release of ApexSQL Plan offers support for SQL Server Management Studio 2012 integration and higher, Data flow line thickness, Layouts panel, Live query plans, Manipulation with the query plan graphical elements, Query execution plans, Customized data flow properties, Customized operation properties, Operation cost highlight, Join diagram, Line level statements analysis, Query plan XML viewer, Show missing index details, Table I/O, Expressions, Parameters, Plan tree and top operations, Query columns, Wait stats, Deadlock analysis, Multiple query tabs, History and comments, Query performance, Query store, and GUI themes ApexSQL Defrag 2017 R3 The new ApexSQL Defrag offers the following: SQL Server 2017 CTP 2 support, Limited, sampled and detailed index scanning modes, Fast and deep index analysis, Cancel pending jobs, Predefined policies and policy templates, Separate section for alerts, Filter, group and export alerts, and Filter activities. We fixed 17 bugs and known issues. Usability and quality are improved ApexSQL Complete 2017 R7 In the new ApexSQL Complete, we added CRUD procedures, Execution alerts and Export result grid data to Excel. We fixed 15 bugs and known issues.Usability and quality are improved ApexSQL Diff 2017 R3 The new ApexSQL Diff offers SQL Server Management Studio 17 integration and Include new objects in the synchronization process switch. We fixed 11 bugs and known issues. Usability and quality are improved ApexSQL Log 2017 The new ApexSQL Log offers support for SQL Server 2017 CTP 2. We fixed 7 bugs and known issues. Usability and quality are improved ApexSQL Recover 2017 In the new ApexSQL Recover, we added support for SQL Server 2017 CTP 2. Usability and quality are improved ApexSQL Unit Test 2017 The new ApexSQL Unit Test offers support for SQL Server 2017 CTP 2 and SQL Server Management Studio 17 integration ApexSQL Search 2016 R5 In the new ApexSQL Search, we added support for SQL Server 2017 CTP 2. We fixed 2 bugs and known issues. Usability and quality are improved ApexSQL Generate 2016 R6 The new ApexSQL Generate offers SQL Server Management Studio 17 integration. We fixed 3 bugs and known issues. Usability and quality are improved ApexSQL Trigger 2017 R2 The new ApexSQL Trigger offers support for SQL Server on Amazon RDS. We fixed 4 bugs and known issues. Usability and quality are improved ApexSQL Monitor 2017 R2 In the new ApexSQL Monitor, we added Configurable idle timeout period for the Web client, and Navigation from metrics charts to query waits. We fixed over 60 bugs and known issues. Usability and quality are improved ApexSQL Data Diff 2016 R5 The new ApexSQL Data Diff offers support for SQL Server 2017 CTP 2 and SQL Server Management Studio 17 integration. We fixed 9 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 ApexSQL Refactor formatting options– Parameters, columns, joins, and flow control An introduction to ApexSQL Refactor ApexSQL Refactor – How to safely rename database objects without breaking dependencies Working with ApexSQL Source Control in the shared model – Object status Working with ApexSQL Source Control in the shared model – Database change log Blog Here are our most recent blog posts What’s new in ApexSQL Defrag 2017 R3 ApexSQL Defrag 2017 R3 – Product update alert ApexSQL Log 2017 – Product update alert ApexSQL Recover 2017 – Product update alert ApexSQL Generate 2016 R6 – Product update alert ApexSQL Search 2016 R5 – Product update alert ApexSQL Unit Test 2016 R5 – Product update alert ApexSQL Monitor 2017 R2 – Product update alert ApexSQL Trigger 2017 R2 – Product update alert ApexSQL Data Diff 2016 R5 – Product update alert ApexSQL Plan 2017 – Product update alert ApexSQL Complete 2017 R7 – Product update alert ApexSQL Diff 2017 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 automatically compare and synchronize SQL Server database objects with a shared script folder How to automate and schedule SQL Server index defragmentation Two ways to rename SQL Server database objects How to detect whether index maintenance affects SQL Server performance How to synchronize specific rows on a SQL remote database using a database installer package Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog How to change SQL object selections for automated processes/jobs How to change the idle timeout of the web client How to migrate the repository database to a different SQL Server How to integrate the ApexSQL CI/CD toolkit with Jenkins server How to associate a changeset with a Team Foundation Server work item ID How to perform an advanced data search in the results grid How to configure ApexSQL Monitor SSL web access (https) manually How to integrate ApexSQL CI/CD toolkit with TeamCity server How to link a SQL Server database to a Mercurial repository How to manage monitored queries SQL Shack Here is a list of all SQL Shack articles published since our last newsletter Considerations for On-premises data in PowerBI Understanding the Impact of NOLOCK and WITH NOLOCK Table Hints in SQL Server Deep dive into SQL Server Extended events – The Event Pairing target How to identify slow running queries in SQL Server Analysis Services (SSAS) Multidimensional Design Tips – Creating Dimensions Compression and decompression functions in SQL Server 2016 Initial Attributes and Measures in SSAS Multidimensional Cubes SQL Server Database Architecture and Audits for Enhanced Security Microsoft Build Conference 2017 – Recap for SQL Developers How to install SQL Server on Ubuntu How to migrate MySQL tables to Microsoft Azure SQL database What are SQL Server deadlocks and how to monitor them Parallel Nested Loop Joins – the inner side of Nested Loop Joins and Residual Predicates Understanding Skewed Data in SQL Server How to create an Azure SQL Database using the Cloud Shell How to Create a Clustered Columnstore Index on a Memory-Optimized Table Deep dive into the Extended Events Histogram target A T-SQL design pattern for logging process execution Digital certificates: when and where to use them What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL Compare 2017 – Initial release of ApexSQL Compare will include: Compare SQL Server objects directly from SQL Server Management Studio and Visual Studio, Two-way compare and merge, Line-by-line compare, Block-by-block compare, Syntax highlighting, Ignore script option. Read more ApexSQL Defrag 2017 R4 – The upcoming release of ApexSQL Defrag will include: Five new graphical reports, Three new tabular reports, Create custom reports, Filter items in the tree view, and Filter fragmentation grid items. Usability and quality will be improved ApexSQL Doc 2017 R4 – The upcoming release of ApexSQL Doc will offer support for Tableau server (HTML, CHM). 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 FairfieldPASS UG Stamford, CT - June 13 SQLSaturday #627 Davie, Florida - June 10 Steel City SSUG Birmingham, AL - June 20 HRSSUG Virginia Beach, VA - June 21 SQL Malibu UG Los Angeles, CA - June 21 SQLSaturday #609 Caxias do Sul, Brasil - June 24 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