ApexSQL December 2018 newsletter Click here to view this newsletter in your browser ApexSQL December 2018 newsletter Database modeling Does the world need another database modeling tool? We thought so we created and then significantly improved, ApexSQL Model, and then made it free. We've released a major new version of ApexSQL Model (even though it is still part of the 2018 version series) with a ton of new features. Essentially, this release was a redesign of the entire user interface to add critical new features and improve the appearance and display of models. And best of all, the tool is now free. See the blog post Free SQL modeling tool – ApexSQL Model is now free to learn about the freeware announcement. Major enhancements include: Improved table display customization Significantly improved model printing Redesign of model presentation with improved colors, backgrounds and contrast Better forward and reverse engineering Streamline interface options and settings And much more ... See the product update alert for a more detailed summary of release enhancements, fixes and changes as well as links to release notes. To exploit the full potential of ApexSQL Model, you will need the professional version of ApexSQL Diff. ApexSQL Diff is used for forward engineering to a new or existing database. But in ApexSQL Model 2019, we'll eliminate the requirement for ApexSQL Diff, to forward engineer to a new database. Although it will still be required to forward engineer to an existing database. See the article ApexSQL Model and ApexSQL Diff; better together for more information. To take a visual tour through ApexSQL Model see ApexSQL Model 2018 – Screenshot tour. SQL formatting automation We have many other releases, since the last newsletter (please see below) but one notable new feature is a command line interface for ApexSQL Refactor, our free SQL formatting and refactoring tool. So now you can automatically reformat large batches of objects, unattended. Learn more about the latest release. Visual Studio 2019 Looking for free SQL add-in support for Visual Studio 2019? We've got you covered. See the article Visual Studio 2019 Preview support for ApexSQL tools/add-ins for more information. SSMS 18 Getting ready for the new version of SSMS? We're already there. See SQL Server Management Studio (SSMS) 18 support for ApexSQL tools/add-ins for more information. What's new Here are our most recent releases: ApexSQL Model 2018 R2 This release of ApexSQL Model 2018 R2 comes with many features, such as: SQL Server 2019 CTP 2.0 support, SQL Server Management Studio integration support, Visual Studio integration support, Azure SQL Database - Managed Instance support, Active Directory - Password, Integrated and Universal with MFA support authentication support, New error handling and send logs functionality, Improved application installer with a dark theme, New application icon, Create database from model: Create script and Create database, Update existing database: Create synchronization script and Update database, Update existing database in one click, Create DDL script from existing model, Compare model to database via ApexSQL Diff, Compare model to snapshot via ApexSQL Diff, Document model via ApexSQL Doc, Add notes on database diagram, Model categories to group models visually, Customizable output script header and footer, Customizable arguments for updating database via ApexSQL Diff, Schema customization, Table style options, Printer friendly option, Convert colored group to text option is added in Print window, Added status bar information: Groups number, Server name, Project version and Unsaved changes indicator, Project level options: Associated database, Project version and Application output options on project level, Improved table design/display options: Background color is following themes, Syntax highlighting option for data types and keys, Icons for keys, PK separator, Header customization, Displayed columns customization and Nullable column name customization, Improved design of groups on diagram with styles, Improved print options to be more user friendly. Search feature is improved. Added schemas in search feature, added groups in search feature. Create backup of a database before updating database, Create rollback script before updating database. Create snapshot before updating database. Beside these features, usability and quality are improved with 8 bugs and known issues fixed. ApexSQL Backup 2018 R5 This release of ApexSQL Backup 2018 R5 comes with SQL Server 2019 CTP 2.0 support, built-in backup templates, customizable reports and real-time activities progress status information. Beside these features, usability and quality are improved with 4 bugs fixed. ApexSQL Recover 2018 R4 This release of ApexSQL Recover 2018 R4 comes with Include Primary key column value on before-after auditing option. Data source validity is checked when added. Beside these features, usability and quality are improved with 15 bugs fixed. ApexSQL Refactor 2018 R5 This release of ApexSQL Refactor 2018 R5 comes with Visual Studio 2019 integration support and CLI support for formatting SQL code. Beside these features, usability and quality are improved with 7 bugs fixed. ApexSQL Log 2018 R4 This release of ApexSQL Log 2018 R4 comes with Save automation script as a PowerShell script option, Include Primary key column value on before-after auditing. Data source validity is checked when added. Beside these features, usability is improved with 16 bugs fixed. ApexSQL Complete 2018 R8 This release of ApexSQL Complete 2018 R8 comes with Visual Studio 2019 integration support. Beside this feature, usability is improved with 2 bugs fixed. ApexSQL Search 2018 R5 This release of ApexSQL Search 2018 R5 comes with Visual Studio 2019 integration support. Usability an quality are improved with 5 bugs fixed. ApexSQL Script 2018 R2 This release of ApexSQL Script 2018 R2 comes with SQL Server 2019 CTP 2.0 support, high DPI and 4K resolution support, save automation script as a PowerShell script, new error handling and send logs functionality, improved application installer with a dark theme, new application icon, Check for object existence with If exists/If not exists option, Include dependent database objects option is added under the Options tab of the New project window and 2 new CLI switches. Usability and quality are improved with 84 bugs fixed. ApexSQL Monitor 2018 R8 This release of ApexSQL Monitor 2018 R8 comes with real time SQL Server activity, per metric alert grouping viewer, improved alerts filtering, Add or remove multiple servers option, enable or disable monitoring of multiple servers option, blocking chain. Usability and quality are improved with 9 bugs fixed. ApexSQL Build 2018 R3 This release of ApexSQL Build 2018 R3 comes with SQL Server 2019 CTP 2.0 support, new application icon, new error handling and send logs functionality, improved application installer with a dark theme. Usability and quality are improved with 2 bugs fixed. ApexSQL DevOps toolkit 2018 R6 This release of ApexSQL DevOps toolkit 2018 R6 comes with native plug-in for Jenkins and support for TeamCity 2018.1.3 and later. Quality is improved. ApexSQL Diff 2018 R3 This release of ApexSQL Diff 2018 R3 comes with SQL Server 2019 CTP 2.0 support, SQL Server Management Studio 18 integration support, High DPI and 4K resolution support, New application icon, New error handling and send logs functionality, Improved application installer with a dark theme, Active Directory - Password and Integrated authentication support. Users can now save automation script as a PowerShell script. Visual Studio integration support, Comparison summary output, Ignore pre-processing script failure option, 5 additional outputs in the Automation script window, 6 new CLI switches. Usability and quality are improved with 56 bugs 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 Script Archiving and managing executed queries How to configure before-after auditing in ApexSQL Audit An introduction to ApexSQL Build Reviewing and resolving alerts in ApexSQL Monitor Blog Here are our most recent blog posts: ApexSQL Model 2018 R2 - Product update alert ApexSQL Backup 2018 R5 - Product update alert ApexSQL Recover 2018 R4 - Product update alert ApexSQL Refactor 2018 R5 - Product update alert ApexSQL DevOps toolkit 2018 R7 - Product update alert ApexSQL Log 2018 R4 - Product update alert ApexSQL Source Control 2018 R9 - Product update alert ApexSQL Complete 2018 R8 - Product update alert ApexSQL Search 2018 R5 - Product update alert Does the world need another database modeling tool? ApexSQL Plan 2018 R6 - Product update alert ApexSQL Script 2018 R2 - Product update alert ApexSQL Monitor 2018 R8 - Product update alert Visual Studio 2019 Preview support for ApexSQL tools/add-ins Unit testing in ApexSQL tools / add-ins ApexSQL Build 2018 R3 - Product update alert ApexSQL DevOps toolkit 2018 R6 - Product update alert ApexSQL Search 2018 - Screen shot tour ApexSQL Diff 2018 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: Automating database synchronization using a continuous integration solution SQL Server data and structure recovery tool use cases SQL Join introduction and overview SQL Server transaction log reader use cases Top things you need in a SQL Server performance monitoring tool (from deadlocks monitoring to alerting and index monitoring) Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog: Customizing table element displays in ApexSQL Model How to achieve high quality auditing trail with the minimum number of auditing events How to configure and use SQL Server Wait statistic monitoring Using and scheduling SQL Server performance monitoring reports How to configure and use deadlock monitoring SQL Shack Here is a list of all SQL Shack articles published since our last newsletter: Monitoring Disk Space on Linux - Helpful Commands for SQL Server DBAs Changing SQL Dump file locations in SQL Server on Linux Ask a Question feature in Power BI Desktop Renaming a SQL Server instance on Ubuntu Linux Flow Map Chart in Power BI Desktop Use of Key Performance Indicators in Power BI Enhanced PolyBase SQL 2019 - MongoDB and external table Helpful Linux commands for SQL Server DBAs - iotop and iostat Columnstore Index Enhancements - online and offline (re)builds Six methods to automatically Discover SQL Server instances Renaming Logical and Physical file names in SQL Server on Linux Helpful Linux commands for SQL Server DBAs - top CRUD operations in SQL Server SQL Server 2019 installation on Ubuntu without a Docker Container Database Upgrade using the Query Tuning Assistant wizard in SSMS 18 Static Data Masking in SSMS 18 Row Mode Memory Grant Feedback in SQL Server 2019 What is SQL in SQL Server? How to markup, annotate content like a boss The STRING_SPLIT function in SQL Server An MDS Driven Approach to a Turnaround Time Calculation in SQL Server SQL Server 2019 on Linux with Ubuntu SQL Server 2019 on Linux with a Docker container on Ubuntu SQL Server 2019 on Linux with Ubuntu and Azure Data Studio Saving your SQL Execution Plan How to create an email alert in SQL Server Agent for job failures Overview of the SQL REPLACE function SQL index overview and strategy What is Database Normalization in SQL Server? Recently added keys We keep increasing the value of our bundles with new releases and pre-releases. Recently added keys include: Aug 07, 2018 ApexSQL Manage Pre-release ApexSQL DBA Jul 26, 2018 ApexSQL Mask Pre-release ApexSQL Developer 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 Generate 2018 R2 The upcoming release of ApexSQL Backup will include features such as: SQL Server 2019 CTP 2.0 support. SQL Server Management Studio 18 integration support. New application icon. New error handling and send logs functionality. Improved application installer with a dark theme. Usability and quality will be improved. Stay tuned for more releases and new products on our What's next page 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
