ApexSQL May 2018 newsletter - TITLE Click here to view this newsletter in your browser ApexSQL May 2018 newsletter In this newsletter we’re presenting the virgin release of our new Developer tool - ApexSQL Model and the first of our SQL Server CI/CD Build server plug-ins, ApexSQL CI/CD toolkit TeamCity plugin. We’re giving a sneak peek at our soon-to-be-released tool - ApexSQL Discover, and offer additional 25% ‘lapsed customer forgiveness’ discount for all customers interested to get back under active support and upgrade subscription. ApexSQL Model We are excited to announce the first release of ApexSQL Model - a powerful developer tool used for database diagramming. The virgin release includes the following features: Database modeling Data model diagrams Forward engineering Reverse engineering Model history navigation Object grouping options Diagram layout customization Edge routing customization Autosave models Snapshot models Export model diagrams into BMP, JPEG and PNG formats Print model diagrams Export model as snapshot Create executable custom tasks Customizable keyboard shortcuts GUI themes For more information, see the ApexSQL Model product page and for a full review of all features and screen shots see What’s new in ApexSQL Developer: ApexSQL Model – database diagramming ApexSQL Discover ApexSQL Discover is a SQL Server discovery and basic health monitoring tool It scans all available SQL Server instances located in a specific domain or IP range and keeps track of basic health parameters and statistics for all registered SQL instances. It allows for various filters to be applied at column level for easier search and also allows for the automation of the search process - by allowing users to schedule discovery with predefined options. Apart from discovery options, the application also has ability to keep track of basic health parameters and statistics for all registered SQL instances, such as CPU utilization, RAM memory and disk space usage. The results can be reported and exported to PDF, HTML or image formats The tool is expected to be released by the end of this quarter, and the best news is that it will be completely free. ApexSQL CI/CD 2018 - TeamCity plugin released We are proud to announce the release ApexSQL CI/CD toolkit TeamCity plug-in, the first of our SQL Server CI/CD Build server plug-ins. This release includes the following features: Continuous integration: Build a SQL Server database directly from source control and optionally include static data Fill empty tables with synthetic data Integrate trigger-based audit trails and reporting into change sensitive database objects Generate full or differential documentation for the SQL Server database Test SQL Server database using unit tests Enforce database best practices by reviewing, detecting and fixing issues Create a clean database package for easy deployment Publish package to a designated NuGet feed Continuous delivery: Compare SQL Server database schemas and create a script for schema synchronization Compare SQL Server static data and create a script for data synchronization Push schema and data changes to a target database Archive all output files in a central folder Automatically create rollback scripts Flexible pipelines Discounts You own an ApexSQL individual tool or bundle but you missed renewal deadline? Don’t worry as we prepared additional 25% discount (on top on our standard 25% lapsed customer discount) for you to get back under active support and upgrades. This means that you can get the much improved 2018 versions of ApexSQL tools (or even get additional tools if you are a bundle customer) with 50% discount. Sounds good? Send us an email at sales@apexsql.com before the next newsletter hits your mailbox! Kristina Stanisavljevic Marketing team @kicko_kiki What's new Here are our most recent releases ApexSQL Enforce Some of the new features of ApexSQL Enforce 2018 R2 include more than 30 new rules, ingnore options for object pairs, objects and script blocks, support for SQL Server Management Studio and Visual Studio integration, project file can now be saved as a batch file, High DPI and 4K resolution support, improved the Result summary form, additional CLI switches. Along these new features, usability and quality are also improved with 6 known bug fixes ApexSQL Diff In this release of ApexSQL Diff 2017 R6 Export differential snapshot to capture schema changes only options is added in the Synchronization wizard under the Output options step when a destination is database, script folder or source control project. Two more enhancements in this release are Export differential snapshot to capture schema changes only switch [/dsn] and Export any data source using the connection switches with the /export switch in the CLI. Usability and quality are improved with 17 bugs and known issues fixed ApexSQL CI/CD toolkit Open source PowerShell cmdlets ApexSQL CI/CD toolkit 2018 now supports integration with TeamCity server ApexSQL Model This release of ApexSQL Model 2018 offers Database modeling, Database model diagrams, Forward engineering, Reverse engineering, Model history navigation, Object grouping options, Diagram layout customization, Edge routing customization, Autosave models, Snapshot models, Export model diagrams to BMP, JPEG and PNG formats, Print model diagrams, Export model as snapshot, Create executable custom tasks, Customizable keyboard shortcuts, Support for Azure SQL Database and Amazon RDS for SQL Server and GUI themes. Usability and quality are improved with 5 bugs and known issues fixed ApexSQL Monitor This release of ApexSQL Monitor 2018 R3 offers 7 new predefined reports and Redesigned reporting categories. Usability and quality are improved with 31 bugs and known issues 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 Diff An introduction to ApexSQL BI Monitor An introduction to ApexSQL VM Monitor An introduction to ApexSQL Enforce Advanced auditing techniques - using the Watches feature Blog Here are our most recent blog posts ApexSQL Complete 2018 R3 – Product update alert ApexSQL Backup 2018 R2 – Product update alert ApexSQL Diff 2017 R6 – Product update alert ApexSQL CI/CD toolkit 2018 – Product update alert ApexSQL Model 2018 - Product update alert ApexSQL Enforce 2018 - Screen shot tour 4K resolution and high-DPI scaling support in ApexSQL tools/add-ins ApexSQL Enforce 2018 R2 - Product update alert ApexSQL Monitor 2018 R3 - Product update alert ApexSQL Audit 2018 R3 – Product update alert What's next in ApexSQL DBA: ApexSQL Discover - SQL Server instance search and inventory ApexSQL Propagate 2018 - 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 How to master SQL Server performance baselining to avoid false positives and/or missing alerts How to implement compliance with GDPR for SQL Server How to create and optimize SQL Server indexes for better performance Visual tools for monitoring SQL Server query performance How to optimize SQL Server query performance - Statistics, Joins and Index Tuning Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog How to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio How to enforce best practices rules against your database How to integrate ApexSQL CI/CD toolkit with Bamboo server Query store dashboard How to set up and activate custom performance metrics SQL Shack Here is a list of all SQL Shack articles published since our last newsletter Recursive CTEs and Foreign Key References in SQL Server Understanding SQL Server’s TRY_PARSE and TRY_CONVERT functions The HashBytes function in T-SQL Logging SQL Server database errors Data science, data understanding and preparation – entropy of a discrete variable Smart database backups in SQL Server 2017 FAQ and examples about the SQL Server Agent Reading file data with PowerShell How to add a new disk to an existing SQL Server failover clustered instance Working with different SQL Server indexes types SqlPackage.exe - Automate SQL Server Database Restoration using bacpac with PowerShell or Batch techniques Designing effective SQL Server non-clustered indexes Understanding Database snapshots vs Database backups in SQL Server How to integrate Power BI to the Facebook Graph API The Halloween Problem in SQL Server and suggested solutions Logical SQL Server data replication 101 How to use Microsoft Flow to extract SharePoint Online list data Discussing Backup and Restore Automation using SQLCMD and SQL Server agent Understanding the GUID data type in SQL Server Designing effective SQL Server clustered indexes List of top Azure SQL Database tools SQL Server 2017: Adaptive Join Internals How to simulate the Azure SQL Database storage account behavior using the emulator SQL Server 2017: How to Get a Parallel Plan SQL Server 2017: Statistics to Compile a Query Plan List of top SQL Server blogs SQL Server 2017: Sort, Spill, Memory and Adaptive Memory Grant Feedback Integrating Azure SQL database alerts into Slack SQL Server 2017: Interleaved Execution for mTVF 4K resolution and high DPI: What you need to know about it to have great visuals SQL Server 2017: Scalar Subquery Simplification Backup and Restore (or Recovery) strategies for SQL Server database SQL Server 2017: Columnstore in-place updates Top SQL Server Books SQL Server 2017: Columnstore Indexes and Trivial Plan Scalar UDF Estimation and Project Normalization 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 Available ApexSQL Developer Jan 31, 2018 ApexSQL Job Available 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 CI/CD toolkit 2018 R2 - The upcoming release of ApexSQL CI/CD toolkit will bring Web dashboard, Get notified when changes are detected in source control, before a build starts, Trigger an automated build on changes in source control, Publish NuGet packages using native plugins. 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 Generate 2018 - The upcoming release of ApexSQL Generate will offer High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved ApexSQL Search 2018 - The upcoming release of ApexSQL Search will offer GUI themes, High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved ApexSQL Source Control 2018 R4 - The upcoming release of ApexSQL Source Control will offer High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. 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 HRSSUG Virginia Beach, VA - May 16 SQL Saturday 728 Catania, Italy - May 19 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