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 II Although we have no new products to announce today (which is a change), we do have some great stuff to cover in this edition of our newsletter... New major version – test data generator We released a new version of ApexSQL Generate since the last newsletter. This latest release was primarily to catch the tool up with our other developer tools in terms of Amazon RDS and SQL 2017 CTP support. But we also re-wrote the user interface with a new, modern control set and can now offer visual themes (Light, Dark – see below, Colorful) for this product. All remaining product interfaces, that haven’t already been updated, should be updated, as well, in the next few months. One important change is that we have introduced editions to this tool, including a free communuity edition with support for Azure SQL Database, Amazon RDS and SQL Express. So, if you were looking for a synthetic test data generation tool for SQL Server but didn’t want to commit to making a purchase, this is a great way to get your feet wet. We also offer Standard and Professional editions. Please see the compare section of the ApexSQL Generate product page to see all of the features by version. SQL test data generation articles As a quick primer for SQL Server test data generation, here are some articles that show solutions to some SQL Server test data generation challenges SQL Server database continuous integration workflow POPULATE step – Populating the newly built SQL database with data How to generate randomized test data from a CSV file How to use regular expressions (RegEx) in SQL Server to generate randomized test data How to automatically create synthetic test data for a SQL Server database How to create and automate test data generation for a SQL Server database See also See all of our free community editions here See all of our tools for SQL Azure Database here New features – SQL productivity We’ve recently released three new features into ApexSQL Complete, a free SSMS and VS add-in for SQL for improved development productivity including SQL auto-completion Export to Excel This allows users to take query result sets and instantly copy/move/export them to an Excel spreadsheet. CRUD procedures This feature allows users to instantly create CRUD procedures e.g. Update from a pre-defined (and customizable) template, against any table. Read more about this new feature here. Execution alerts This feature guards against inadvertent actions that may have deleterious effects, such as executing a Delete statement without a Where clause. This feature will warn the user and allow them to safely cancel the operation. A powerful feature of our Execution alerts, is the ability for users to create new ones themselves. Read more about this new feature here. Coming soon – new ApexSQL Monitor user interface We’ve been happy with the great reception of the new web based version of ApexSQL Monitor, but we’ve been continuing to innovate in improving the interface, in a way that will make the user experience of this tool, hands down, the best. We already offer an instance explorer that allows users to quickly view instances by custom group and status, while allowing them to drill across into any module. But now we are improving our complimentary main dashboards, to provide even richer detail and functionality, and are will soon be offering two views (vs just one), table/grid and panel/card. New card/panel dashboard We’ve added detail showing individual and summary alert counts to the existing table/grid view, but will also be adding powerful, but easy to use filters to instantly define a smaller sub-set of instances. In addition to this we’ve added an entirely new dashboard of panels/cards, that present the same information differently, and with a bit more detail, especially as the cards can be flipped/inverted to show additional detail. The ETA for this new version is in early September. Stay tuned for more updates in the interim. Click here for a full review of the planned new UI. New table/grid dashboard Help wanted We’ve just posted some information on some interesting and challenging opportunities for collaboration between experienced SQL Server professionals and our company. The opportunities include Public writing Native writing Spot contracts – short, specific assignments paid hourly Fixed bid contracts – larger assignments for a fixed price All tasks and assignments are generally short in duration and can run from a few hours to a few days. But we have quite a few of them and will be increasing the size and complexity of these tasks over time. Click here for more info. Disaster recovery insurance We have gotten requests from customers for a different licensing model that would allow customers with a large number of instances, who wanted to use our ApexSQL Log and ApexSQL Recover for recovery purposes only (vs continuous auditing for ApexSQL Log) to purchase a floating license. This will allow them to deploy the tools on instances, only when needed. For example, in a theoretical shop with 100 instances, with a 5% rate of data recovery need per year, only 5 ad-hoc deployments of these tools would be needed, and even further, only needed for that particular incident. 1 license, only, would fail to help in the other 4 cases, but 5 licenses might be cost prohibitive. With the new floating licenses, customers can purchase a license that would cover 10 incidents. So for $4,999 this shop could cover all of their projected incidents for 2 years, for the equivalent of all of the following. $499 per incident $49 per instance $25 per instance per year As long as incidents remained on the license, you would never be “caught short”. Please contract sales@apexsql.com for more information. You can also purchase these licenses directly from our pricing page. Summer discounts A little late but ... we have started running some specials this summer. Please contact our sales folks via email to get information on these promotions! Brian Lockwood Founder and CEO @FightingCEO What's new Here is our most recent release ApexSQL Generate 2017 The new ApexSQL Generate offers support for SQL Server 2017 RC1, SQL Server on Amazon RDS, and three new GUI themes. The application has been split into three editions – Community, Standard and Professional. We fixed 17 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 An introduction to ApexSQL Plan ApexSQL Refactor formatting options – General options, capitalization and comments ApexSQL Complete – How to create and use SQL code text auto-replacements ApexSQL Refactor formatting options– Parameters, columns, joins, and flow control An introduction to ApexSQL Refactor Blog Here are our most recent blog posts What’s next in ApexSQL Monitor – Improved UI and new panel view ApexSQL Generate 2017 – Product update alert What’s next in ApexSQL Enforce What’s next in ApexSQL Plan 2017 R2 What’s new in ApexSQL Defrag 2017 R4 Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog Differences between the dedicated and shared development models Execution alerts Creating CRUD procedures How to order via purchase order Monitor SQL Server index size ApexSQL Compare Command Line Interface (CLI) switches SQL Shack Here is a list of all SQL Shack articles published since our last newsletter How to query Excel data using SQL Server linked servers Refreshing SQL Server Containers automatically with Watchtower How to email SQL query results to your smartphone using the sp_send_dbmail stored procedure Performance tuning for Azure SQL Databases How to simplify SQL Server Database Object usage with Synonyms How to drop a SQL Server Login and all its dependencies How to control online Index Rebuild Locking using SQL Server 2014 Managed Lock Priority Continuous Integration with SQL Server Data Tools in Visual Studio 2017 SQL Server system databases – the msdb database How to automate SQL Server deadlock collection process using Extended Events and SQL Server Agent 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 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 FairfieldPASS UG Stamford, CT - August 8 Steel City SSUG Birmingham, AL - August 15 HRSSUG Virginia Beach, VA - August 16 SQL Malibu UG Los Angeles, CA - August 16 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