ApexSQL March 2018 newsletter - New version of ApexSQL Plan released, 3 products face-lifted and 75% cross-selling discount announced Click here to view this newsletter in your browser ApexSQL March 2018 newsletter The highlights of this newsletter are certainly the applications’ face-lifts, but we’re also happy to announce the new release of our free product, ApexSQL Plan, and a special cross-selling offer reserved for our ApexSQL Diff and ApexSQL Data Diff customers. New release ApexSQL Plan ApexSQL Plan is our free product, used for reviewing actual or estimated execution plan and for analyzing and optimizing SQL queries. The new version brings many important improvements, such as the possibility for comparing execution plans side by side, the ability to monitor execution plans from Query store and Query performance tabs with all available data, and the option to monitor query text errors with descriptions into separated tab. The full list of new features includes: Graphical execution plans: Dashboard intervals selection Query execution plan analysis: XML view Showplan node search Execution plan comparison Execution plan status bar Results for actual execution plan Viewing execution plans in Query store and Query performance tabs Other: Batch Hash Table Build Missing index creation Recently used file list Grid and execution plan nodes search option Query text errors tab Wait times descriptions Keyboard shortcuts Product face-lifts A few months ago we started releasing 2018 version of our software with new interfaces - including themes and icons matching the style of SQL Server Management Studio 17 (SSMS17) and latest Visual Studio. The latest products to join the party are ApexSQL Source Control, ApexSQL Diff and ApexSQL Refactor. ApexSQL Source Control The upcoming version of ApexSQL Source Control (to be released in the next 3 weeks) brings up the new look that completely matches the style of SSMS17. The new design, with its new themes, icons, high DPI and 4K support, allows a seamless visual integration into SSMS17 and highly improves the overall user experience when using the add-in. For more screenshots, please see ApexSQL Source Control gallery. Like what you see? Don’t wait for the new version to get your free licenses - help us improve the tool by providing feedback and get 3 free keys of ApexSQL Source Control in return. ApexSQL Refactor Our free SQL code formatter also got a new robe. New themes (the dark one being our favorite), new icons, and the visual identity that resembles the look of SSMS17 and the latest VS make the tool really pop. If you’re a fan of the dark theme too, but use the add-in with SSMS 2016 or 17, here’s a reminder of how you can set up the dark theme even though SSMS does not officially support it. For a sneak peek into the upcoming version (to be released this month), please see the ApexSQL Refactor 2018 - screen shot tour ApexSQL Diff ApexSQL Diff has experienced a make-over as well. With its new white, colorful and dark GUI themes, high DPI and 4K resolution support and Visual Language Dictionary for VS for iconography and other imagery concepts applied, ApexSQL Diff is all ‘dressed up’ for its 2018 release. See ApexSQL Diff gallery for more dark theme screenshots, and for the detailed overview of features planned for the 2018 release, take a look at the product roadmap. Discounts In this newsletter, we’re offering 75% cross-selling discount for existing ApexSQL Diff and ApexSQL Data Diff customers. If you have one of these tools and a current Support and Upgrades subscription, you can get the other one with 75% discount (or: $399 $100 for standard edition and $599 $150 for professional edition). Interested? Contact sales to claim your discount (the offer is valid until the next newsletter). Brian Lockwood Founder and CEO @FightingCEO What's new Here are our most recent releases ApexSQL Plan This release of ApexSQL Plan 2018 R2 offers dashboard intervals selection. User can view execution plans in Query store and Query performance tabs and there is grid and execution plan nodes search option. Also, missing index creation is now available, query text errors tab has been added, recently used file list, wait times description and SQL Server execution plan comparison. Standard quality and usability improvements are also part of this release, adressing the 3 known bugs which are fixed. 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 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 ApexSQL Refactor 2018 – Screen shot tour ApexSQL VM Monitor 2018 R2 – Product update alert ApexSQL Plan 2018 R2 – Product update alert Microsoft SQL Server historical sample database diagram tour ApexSQL Build 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 Visual tools for monitoring SQL Server query performance How to optimize SQL Server query performance – Statistics, Joins and Index Tuning How to optimize SQL Server query performance Documenting individual build changes (vs an entire database) in a SQL Server continuous integration pipeline How to create and use DML triggers in SQL Server using real world examples Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog Auditing SQL Server databases – initial configuration ApexSQL BI Monitor - Permissions and requirements ApexSQL VM Monitor - Permissions and requirements Searching data in grids Managing rows in grids SQL Shack Here is a list of all SQL Shack articles published since our last newsletter Automate documentation of SQL Server Analysis Server Tabular Model Reporting and alerting on job failure in SQL Server SQL Server data security feature RLS (Row-Level Security) and GDPR SQL Server formatting tools Replace bridge tables in a Data Warehouse with SQL Server 2017 graph database SQL Server Table Structure Overview How to upload multiple images to SQL Server SQL Server Query Execution Plan for beginners – Clustered Index Operators SQL Server documentation tools An overview of the process of SQL Server backup-and-restore 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 Pre-release ApexSQL Developer Jan 31, 2018 ApexSQL Job Pre-release 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 BI Monitor 2018 R2 – The new release of ApexSQL BI Monitor will offer SSAS Cube and objects performance monitoring, as well as the ability to create a new custom metric as a calculated ratio of predefined metrics. Usability and quality will be improved Read more ApexSQL Diff 2018 – The initial release of ApexSQL Diff will include mapping tables and columns, export dependencies, actions, warnings and executions results into different output types. It will include 3 new CLI switches, GUI themes, high DPI and 4K resolution support and Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved Read more ApexSQL Job 2018 - The initial release of ApexSQL Job will include detailed SQL Server job management, job history overview, job schedule management and overview, job alerts management, creating multiple step jobs, SQL Server agent service control, support for multiple script types and Export job history to CSV or XML 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 Read more ApexSQL Monitor 2018 R2 – Introducing in this release scheduled reports. Redesigned report viewer with interactive UI with redesigned custom report feature allows more flexibility and granularity in customization. Also, there are 16 new predefined reports and wait types monitoring customization for improved usability and quality Read more ApexSQL Refactor 2018 – In this release GUI themes are introduced along with high DPI and 4K resolution support for improved quality and usability. Visual Language Dictionary for Visual Studio for iconography and other imagery concepts is also applied ApexSQL Source Control 2018 R3 – The upcoming release of ApexSQL Source Control will include High DPI and 4K resolution support and Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will also 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 Steel City SQL Samford University, Birmingham - March 20 HRSSUG Virginia Beach, VA - March 21 SQL Malibu UG Los Angeles, CA - March 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
هیچ نظری موجود نیست:
ارسال یک نظر