ApexSQL June 2017 newsletter II - New free product – ApexSQL Compare: Compare SQL scripts and objects Click here to view this newsletter in your browser ApexSQL June 2017 newsletter II New free product – ApexSQL Compare: Compare SQL scripts and objects In the last newsletter we announced the release of a new free product, ApexSQL Plan, a SQL Server query plan viewer and analysis tool. This newsletter we are announcing the release of another new, free tool; ApexSQL Compare, a tool to compare SQL scripts and objects. Here is a full list of the tool’s features: Compare SQL Server objects directly from SSMS and Visual Studio File and folder comparison Two-way compare and merge Full support for Command Line Interface Compare models: Block, Line, Character Syntax highlighting Ignore comparison options: Ansi options, Authorization, Collation, Comments, Constraint names, Filegroups, Indexes, Lock escalation, Permissions, With encryption Integrated editor Support for Windows Explorer integration Exporting comparison results into HTML In addition to the ApexSQL Compare product page, you can walk through all of the features of the tool via the article ApexSQL Compare screen shot tour. Free community editions Many people are familiar with our free tools, but fewer know about all of the 100% free editions of other popular, non free tools. The free editions offer support for Azure SQL database, SQL Express and Amazon RDS. Click here to see all of our free tool editions. If so, we offer free keys for ApexSQL Monitor, ApexSQL Backup and ApexSQL Source Control. We’d welcome you to join the many others who have taken advantage of a great, risk free opportunity to obtain real license to our products. Our support team is growing We pride ourselves on our product support but it doesn’t come easy. It requires a full team of dedicated professionals. Here is our current contingent of Product support engineers, at ApexSQL. We always love feedback on our team, good or bad, so my email is included in each of their email signatures, which helps me keep my finger on the pulse of our support quality. You can see more about our support services at the ApexSQL product support page. What’s coming up next? We are busily working on a new product, ApexSQL Enforce, which hopefully we’ll “officially” announce in the next newsletter. This will be a tool to parse SQL scripts, databases and even individual check-ins for various SQL object and code problems. This tool can enforce naming conventions, best practices, avoiding complexity and even coding errors. All results will be displayed in a rich grid and can be exported. We hope to ship the product with at least 150 out of the box rules. This tool will be ideal for Continuous integration as it can be added as an automated step in a CI or CD pipeline to scan all changes for any problems, issues and rule violations. Speaking of CI/CD we are working hard on a web interface to our CI/CD toolkit as well as plug-ins for TFS, Jenkins, TeamCity and other popular build servers. We hope to have all of these delivered in Q3. I’ll be providing information on two more new products that will also be released in Q3 over the next few newsletters. See What’s next for details on all planned releases Brian Lockwood Founder and CEO @FightingCEO What's new Here are our most recent releases ApexSQL Compare 2017 Initial release of ApexSQL Compare offers the following: File and folder comparison. Compare SQL Server objects directly from SQL Server Management Studio and Visual Studio. Two-way compare and merge. Full support for Command line interface. Three comparison modes: Character, Line, Block. Syntax highlighting for 9 languages: C#, C++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML. Ignore script options: Ansi options, Authorization, Collation, Comments, Constraint names, Filegroups, Indexes, Lock escalation, Permissions, With encryption. Support for SQL Server Management Studio 2012 integration and higher. Support for Visual Studio 2010 integration and higher. Support for Windows Explorer integration. Support for Azure SQL Database. Support for SQL Server on Amazon RDS. Exporting comparison results into HTML ApexSQL Doc 2017 R4 The new ApexSQL Doc offers support for Tableau server in chm and html output formats, along with 8 new CLI switches. We fixed 30 bugs and known issues. Usability and quality are improved See What's new for descriptions for all of our recent releases Blog Here are our most recent blog posts What’s new in ApexSQL Defrag 2017 R3 ApexSQL Compare 2017 – Product update alert ApexSQL Propagate 2017 R2 – Product update alert ApexSQL Doc 2017 R4 – Product update alert ApexSQL Search 2016 R6 – Product update alert ApexSQL Audit 2017 R3 – Product update alert ApexSQL Compare 2017 – Screen shot tour Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog How to utilize branching with Git How to link a SQL Server database to a Perforce repository How to utilize Team Foundation Server check-in policies How to change SQL object selections for automated processes/jobs How to change the idle timeout of the web client SQL Shack Here is a list of all SQL Shack articles published since our last newsletter How to create a chatbot with Azure in 5 minutes Understanding different SQL Server database states All about locking in SQL Server SQL Server Index Performance Tuning Using Built-in Index Utilization Metrics How to document SQL Server database objects SQL Server stress testing using OStress Reporting in SQL Server – Power BI Report Server How to track SQL Server database space usage with built-in functions and DMVs How to monitor total SQL Server indexes size How to use Window functions in SQL Server How to create and configure a linked server in SQL Server Management Studio Top string functions in SQL Server 2017 How to report on SQL Server deadlock occurrences SQL Server 2016 Memory-Optimized Tables – The Checkpoint operation How to create geographic maps in Power BI using built-in shape maps What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL Defrag 2017 R4 – The upcoming release of ApexSQL Defrag will include: Five new graphical reports, Three new tabular reports, Create custom reports, Filter items in the tree view, and Filter fragmentation grid items. Usability and quality will be improved 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 Stay tuned for more releases and new products on our What's next page Events Here are some upcoming events we are sponsoring SQLSaturday #609 Caxias do Sul, Brasil - June 24 FairfieldPASS UG Stamford, CT - July 11 Steel City SSUG Birmingham, AL - July 18 HRSSUG Virginia Beach, VA - July 21 SQL Malibu UG Los Angeles, CA - July 21 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
هیچ نظری موجود نیست:
ارسال یک نظر