ApexSQL November 2017 newsletter - New SQL developer product released – automated SQL Server best practice reviews Click here to view this newsletter in your browser ApexSQL November 2017 newsletter In this newsletter, we’ll be announcing the release of the long awaited, ApexSQL Enforce, a tool for automating SQL Server code base reviews. ApexSQL Enforce ApexSQL Enforce can be run against a SQL Server database or a SQL script, to process rules (117 initially) to enforce best practices related to naming conventions, deprecated features, design and more. Violations will be raised in the interface, to allow for further investigation, and SQL to fix the problem can even be generated and run. One of the biggest features of ApexSQL Enforce is the ability for users to customize and even create rules themselves, via a built-in IDE (see below), an internal object model that exposes the SQL parse tree, and auto-complete to help users navigate properties and methods. We even included a tutorial rulebase to help you get started. Along with some content Rules 101 – getting started with ApexSQL Enforce How to execute an unattended best practices review against a database How to fail at running rulebases How to import new rules into an existing rulebase ApexSQL Enforce Command Line Interface CLI switches We are already hard at work on R2 which will include SSMS and Visual Studio integration Ability to ignore rules for certain objects New interface/icons More rules Interested in a license. We will be extended the 50% off, pre-order special, until the end of the week. Use this coupon ApexSQL Enforce for online orders or contact sales ApexSQL Audit We’ve also released a new version of ApexSQL Audit with several significant new features and improvements including AlwaysOn Availability groups auditing scheduled auditing reports Dedicated before-after reports See the product update alert or What’s new in ApexSQL Audit 2017 R5 for more info It is never too early, or too late, to implement comprehensive auditing for your SQL Servers. Check out this new article if you are interested in taking a quick peek at ApexSQL Audit, ApexSQL Audit main features overview Source control Speaking of auditing, getting your SQL Server databases version controlled is an important step in being able to audit your development process. Here are some new articles, since the last newsletter, that cover auditing with source control How to version control SQL scripts alongside SQL database objects “What broke my database?” Using SQL database source control for forensic auditing and database troubleshooting Using SQL source control to track database changes Interested in getting started with SQL Source control? Fill out a quick survey and you can get 3 keys for free with a 1-year subscription for support and upgrades Free trip to PASS Summit 2017 AKA Whoops, he did it again! Ahmad was determined to be the best SQL Shack writer, 2 years in a row, and as such, was provided with a $2,500 package to attend PASS Summit 2017 You can learn more about his adventure here How to be the top SQL Shack author and attend the PASS Summit – twice in a row Interested in writing for us? You can learn more here Brian Lockwood Founder and CEO @FightingCEO What's new Here is our most recent release ApexSQL Enforce 2018 The release of ApexSQL Enforce offers Policy based rules enforcement for database objects and scripts covering configuration, performance, security, naming conventions, best practices and more, Import rulebeases, and View rule changes and code differences. It will include multiple customizable warning thresholds, reports, imports/exports and will be able to be run automatically as part of a continuous integration ApexSQL Audit 2017 R5 The new release of ApexSQL Audit offers support for AlwaysOn Availability Group, Scheduler for exporting reports and data collection, and Dedicated before-after report. 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 Developer: ApexSQL Enforce, rules based best practices review ApexSQL Enforce 2018 – Product update alert What’s new in ApexSQL Audit 2017 R5 ApexSQL Audit 2017 R5 – Product update alert What’s new in ApexSQL Plan 2017 R2 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 execute an unattended best practices review against a database How to Detect SQL Server Performance Issues Caused by Incorrect Clustered Indexes How to create Copy-Only backups in SQL Server How to version control SQL scripts alongside SQL database objects “What broke my database?” Using SQL database source control for forensic auditing and database troubleshooting Using SQL source control to track database changes Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog Minimal SQL Server permissions for ApexSQL Developer tools ApexSQL Doc – Permissions and requirements ApexSQL Enforce Command Line Interface CLI switches ApexSQL Audit main features overview How to fail at running rulebases SQL Shack Here is a list of all SQL Shack articles published since our last newsletter How to solve the Identity Crisis in SQL Server How to set up SQL Server Log Shipping on Linux How to import data from an Excel file to a SQL Server database An introduction to the bcp Utility (bulk copy program) in SQL Server How to be the top SQL Shack author and attend the PASS Summit – twice in a row How to identify and resolve Hot latches in SQL Server An overview of Python vs PowerShell for SQL Server Database Administration What’s new in SQL Server Management Studio 17.3; Import Flat File wizard and XEvent Profiler Commonly used SQL Server Constraints: FOREIGN KEY, CHECK and DEFAULT How to build a SQL Server Virtual Lab with AutomatedLab in Hyper-V How to import/export data to SQL Server using the SQL Server Import and Export Wizard What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL CI/CD toolkit 2017 R2 – The upcoming release of ApexSQL CI/CD toolkit will offer Flexible pipeline creation. You'll be able to review database based on built-in and custom written rules, and publish NuGet packages using PowerShell. Usability and quality will be improved. Read more ApexSQL Defrag 2018 – The new release of ApexSQL Defrag will offer Index fragmentation and size prediction, Missing index alerts, and Custom severities for policy alerts. Also, it will include Resource check parameters for executing job count, active transaction count, and transaction log usage %, Email notification events for policy started, delayed, expired, and cancelled, Time restriction period for schedules, and SQL Server 2017 support. Usability and quality will be improved ApexSQL Log 2018 – The upcoming release of ApexSQL Log will include Support for SQL Server 2017 and High DPI and 4K resolution. Performance, usability and quality will be improved ApexSQL Recover 2018 – The new release of ApexSQL Recover will include High DPI and 4K resolution support. Performance, usability and quality will be improved ApexSQL Source Control 2018 – The upcoming release of ApexSQL Source Control will offer SQL Server 2017 support. 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 SQL Saturday Parma, Italy - November 18 FairfieldPASS UG Stamford, CT - December 13 HRSSUG Virginia Beach, VA - December 20 NetPASS Tyler, TX - December 20 SQL Malibu UG Los Angeles, CA - December 20 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
هیچ نظری موجود نیست:
ارسال یک نظر