ApexSQL July 2017 newsletter - New product announced – ApexSQL Enforce – SQL development rules based review and enforcement Click here to view this newsletter in your browser ApexSQL July 2017 newsletter We are excited to announce the imminent (hopefully in 2 weeks) release of another new SQL Server developer tool, ApexSQL Enforce. ApexSQL Enforce is a coding, design and development review and enforcement tool for SQL Server. It will ship with a comprehensive rule base of nearly 200 rules, that enforce such things as naming conventions, coding standards and general development best practices. The power of ApexSQL Enforce is that is parses script based objects and even standalone scripts at a deep level and can create an object model out of things like your code structure, that lets you write rules down to the line of code level. For example, you can set rules about what can or can’t exist in order by clauses. Although we will offer a comprehensive rulebase, users can write their own rules in the .NET language of their choice, with a powerful internal rule editor against our meta data object model. Results will be displayed in rich detail in the grid for further analysis (sorting, grouping, filtering) or exported to a report. ApexSQL Enforce will be able to be deployed against single databases, stand alone scripts and soon, as an add-in to ApexSQL Source Control, so code can be validated, and approved or rejected, at the check-in level. ApexSQL Enforce will exist in three different editions Community – a sub-set of functionality for Azure SQL Database, Amazon RDS and SQL Express Standard – a sub-set of functionality for all editions of SQL Server Professional – a full set of functionality including CLI Existing customers of ApexSQL Developer and ApexSQL Universal, will get ApexSQL Enforce keys added for free to their bundle. Please contact service@apexsql.com to get your updated key(s) once the product is released. Please see What’s next in ApexSQL Enforce for more screen shots. Other new releases We’ve also released another significant version of ApexSQL Defrag with quite a few new features including Fragmentation grid filters Fragmentation filters for the index explorer Index statistics reports for page density, number of fragments and size ratio of index Statistic reports for top 10 most fragmented clustered and unclustered indexes Customization options for exported reports are added to Reports tab See What’s new in ApexSQL Defrag 2017 R4 for more details. What’s next Following our big release of ApexSQL Plan, we’ve been working hard on subsequent releases that will include such things as stored procedure analysis, Query store dashboard, performance profiling and more. Please see a preview of all planned features here What’s next in ApexSQL Plan 2017 R2. Brian Lockwood Founder and CEO @FightingCEO What's new Here are our most recent releases ApexSQL Defrag 2017 R4 The new ApexSQL Defrag offers fragmentation grid filters in the fragmentation tab, fragmentation filters for the treeview explorer, customization options for exported reports, five new graphical reports and three new tabular reports. We fixed 21 bugs and known issues. Usability and quality are improved ApexSQL Monitor 2017 R4 In the new ApexSQL Monitor, we added the browse network servers option in the add server page, along with the option to export and import custom metrics. We fixed 38 bugs and known issues. Usability and quality are improved ApexSQL Audit 2017 R4 In the new ApexSQL Audit, the execution timeout can be defined when creating the database during the installation process. We fixed 6 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 – General options, capitalization and comments 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 ApexSQL Complete – How to create and use SQL code text auto-replacements Blog Here are our most recent blog posts What’s next in ApexSQL Enforce What’s new in ApexSQL Defrag 2017 R4 What’s next in ApexSQL Plan 2017 R2 ApexSQL Defrag 2017 R4 – Product update alert ApexSQL Audit 2017 R4 – Product update alert ApexSQL Monitor 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 pull SQL Server database objects from a shared script folder to a local database How to automatically compare and synchronize SQL Server database objects with a shared script folder How to automate and schedule SQL Server index defragmentation How to backup multiple SQL Server databases automatically How to create and manage database backup chains in SQL Server Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog ApexSQL CI/CD toolkit PowerShell FAQs Monitor SQL Server index size ApexSQL Compare Command Line Interface (CLI) switches How to compare two SQL scripts/objects and export comparison results Performance metrics quick guide How to customize SQL formatting profiles Custom reports basics SQL Shack Here is a list of all SQL Shack articles published since our last newsletter How to analyze SQL Server database performance using T-SQL How to use SQL Server built-in functions and create user-defined scalar functions How to monitor the SQL Server tempdb database SQL Server system databases – the master database Analysis Services (SSAS) Cubes – Dimension Attributes and Hierarchies How to create, configure and drop a SQL Server linked server using Transact-SQL HSQL Server SET Options that Affect the Query Result – SET CONCAT_NULL_YIELDS_NULL, SET NUMERIC_ROUNDABORT, SET QUOTED_IDENTIFIER, SET NOCOUNT, SET XACT_ABORT How to use SQL Server Data Compression to Save Space SQL Server SET Options that Affect the Query Result – SET ANSI_NULLS, SET ANSI_PADDING, SET ANSI_WARNINGS and SET ARITHABORT How to use SQL Server Extended Events to parse Deadlock XML and generate statistical reports Configuration, operations and restrictions of the tempdb SQL Server system database Collecting, aggregating, and analyzing missing SQL Server Index Stats Overview of Resumable Indexes in SQL Server 2017 How to calculate work days and hours in SQL Server How to copy an Azure SQL database using the Azure Portal, Cloud Shell and T-SQL How to create geographic maps in Power BI using custom shape maps Analysis Services (SSAS) Multidimensional Design Tips – Relations and Hierarchies How to create geographic maps in Power BI using built-in shape maps SQL Server 2016 Memory-Optimized Tables – The Checkpoint operation SQL Server Logins, Users and Security Identifiers (SIDs) What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL Enforce 2017 – Initial release of ApexSQL Enforce will include Policy based rules enforcement for SQL Server settings, database objects and scripts covering configuration, performance, security, naming conventions, best practices and more, along with multiple customizable warning thresholds, reports, imports/exports and will be able to be run automatically as part of a continuous integration ApexSQL Data Diff 2017 – The upcoming release of ApexSQL Data Diff will offer the following: Script folder data source, GUI themes, Create rollback script before synchronization, Create script folder backup for destination script folder or source control before synchronization, 6 new CLI switches. Usability and quality will be improved. Read more ApexSQL Generate 2017 – New ApexSQL Generate will offer support for SQL Server on Amazon RDS, support for SQL Server 2017 CTP 2, and GUI themes. Usability and quality will be improved ApexSQL Source Control 2017 R5 – The upcoming release of ApexSQL Source Control will offer GUI themes. Usability and quality will be improved ApexSQL Doc 2017 R5 – New ApexSQL Doc will offer support for SharePoint server (Word, PDF). Usability and quality will be improved. Read more ApexSQL Complete 2017 R8 – The upcoming release of ApexSQL Complete will offer GUI themes. 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 SQLSaturday #645 Manchester, United Kingdom - July 15 Steel City SSUG Birmingham, AL - July 18 HRSSUG Virginia Beach, VA - July 19 SQL Malibu UG Los Angeles, CA - July 19 FairfieldPASS UG Stamford, CT - August 8 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
هیچ نظری موجود نیست:
ارسال یک نظر