ApexSQL July II 2018 newsletter - 2 new releases, advantages of ApexSQL CI/CD toolkit, free performance monitoring for Azure SQL Database, Azure SQL Database Managed Instance and Amazon Web Service RDS for SQL Server and a 20% off ApexSQL Developer Click here to view this newsletter in your browser ApexSQL July II 2018 newsletter In this newsletter, the focus will be on ApexSQL CI/CD, a continuous database integration and delivery toolkit - we’ll be highlighting the advantages of different CI/CD implementations, show how to use the toolkit to configure a CI pipeline and provide video overviews of ApexSQL CICD toolkit web dashboard. In addition to this, we’ll also cover 2 new releases and announce the support for free performance monitoring for Azure SQL Database, Azure SQL Database Managed Instance and Amazon Web Service RDS for SQL Server, so let’s get busy ApexSQL CI/CD toolkit The ApexSQL CI/CD toolkit is a continuous database integration and delivery toolkit that allows you to automate work flow pipelines to integrate database changes, test and deliver to production. Depending on your preference, you can choose from 3 possible implementations: Opensource PowerShell scripts Web dashboard TeamCity plug-in (more to come soon including Jenkins, Bamboo, Octupus Deploy, etc.) Configure a CI pipeline with the ApexSQL CICD toolkit Regardless of the implementation you choose, here’s a step-by-step guidance on how to set up a CI pipeline that you can use. In this walkthrough example, we show you how to configure a pipeline, build and save project files to determine the behavior of individual pipeline steps, create the steps themselves and finally how to execute the pipeline and review the results For more articles on how to use ApexSQL CI/CD, please check out our ApexSQL CI/CD knowledgebase The CICD toolkit comes in three flavors which we’ll describe next … PowerShell scripts ApexSQL CI/CD toolkit PowerShell scripts are one of the possible implementations of the ApexSQL CI/CD toolkit. To learn more about what we think is great with our implementation, check out the Advantages of ApexSQL CI/CD toolkit PowerShell scripts Web dashboard The ApexSQL CI/CD toolkit Web dashboard is another possible implementation of the ApexSQL C/CD toolkit. It is a free standalone Continuous integration and Continuous deployment build agent with a web-based interface. Check out some articles and videos below for more info ApexSQL CI/CD dashboard - Screen shot tour An introduction to ApexSQL CI/CD toolkit Web Dashboard An introduction to ApexSQL CI/CD toolkit Web Dashboard – pipeline steps overview Advantages of ApexSQL CI/CD toolkit Web dashboard Build server plug-ins Our first, of many, build server plugins is for TeamCity. For more information see What’s new in ApexSQL CI/CD toolkit – TeamCity build server plugin ApexSQL Search 2018 We’ve released a new major version of ApexSQL Search, an SSMS and Visual Studio add-in for SQL Server database object and data text search, among other things. The new release comes with: Active Directory – Password authentication support Applied concepts of Visual Language Dictionary for Visual Studio for iconography, imagery, colors, menus, fonts, formatting and other GUI elements GUI themes High DPI and 4K resolution support For more information, please visit ApexSQL Search product page and/or see the most recent product update alert ApexSQL BI Monitor 2018 R4 We’ve also released a new version of ApexSQL BI Monitor, an agentless performance monitoring tool that lets you monitor and detect SQL Server analysis, integration and reporting services performance issues. In the new release, we added support for standalone SSAS, SSIS and SSRS services. Please see the product update alert or the product page for more information. ApexSQL Audit 2018 R5 Last but not least, we’ve released a new version of ApexSQL Audit with the following enhancements: The server-side components can now be automatically installed from within the application GUI when adding SQL Server instances in the domain environment The Inactive repository alert has been added to notify when no auditing information has been inserted into the central repository database during a specified time-period Application level security has been added. Individual users or groups can now be added to administrator, power user and data reader roles as well as 33 bug fixes For more information, please visit ApexSQL Audit product page and/or see the recent product update alert. Performance monitoring for Azure SQL Database and Amazon Web Service RDS for SQL Server In the last newsletter, we announced the “cloud support” in ApexSQL Monitor, and now, we’re giving you a closer look at how ApexSQL Monitor allows database Administrators to gain the control over database performance, even in the cloud where end users do not have control over the hardware and operating system. And don’t forget - Support for Azure SQL Database is FREE, which means that with each ApexSQL Monitor license you get, you get to monitor additional instance (unlimited databases) on Azure SQL Database for free. Other tools ApexSQL Refactor has been around a long time. ApexSQL Plan hasn’t been around long at all. But they have one thing in common, they are very popular ApexSQL add-ins. If you haven’t downloaded these tools yet, or have but are looking to spread the love, check out these two new articles Top things you need in a SQL Server formatting tool Top things you need in a SQL Server query plan analysis tool Training Looking for a great content series/training on SQL Server indexes? How about SQL Server backups and restores? Query optimization? Data science? We’ve posted two stairways on these topics with many articles and we wrapped some of them up with in-depth interview questions. No paywall, registration form or annoying phone calls from sales people – we promise! SQL Server backup and restores - a 21 part series SQL Server indexes – an 12 part series Query optimization techniques in SQL Server – a 3 part series Data science, data understanding an preparation – a 6 part series Discounts If you already own ApexSQL Developer, or even a sufficient collection of Professional editions of individual ApexSQL tools like ApexSQL Build, Diff, Generate… good news… the ApexSQL CICD toolkit is free! Just download it and start using it with these existing tools If you only own standard versions of ApexSQL tools, we can offer you a free upgrade to the Professional edition, so that you can begin to start using the ApexSQL CICD toolkit immediately. Just contact us at sales@apexsql.com for more details If you don’t own any ApexSQL tools, we are offering 20% off ApexSQL Developer, our full database development and continuous integration toolset for your first license. After that, the volume discount for two is already 20% To get your copy of ALL 20 ApexSQL developer tools ($7,886 total value) for $1,399 $1,119 only, please contact us at sales@apexsql.com or use Developer20 promo code for online purchases before the next newsletter hits your inbox. Kristina Stanisavljevic Marketing team @kicko_kiki What's new Here are our most recent releases ApexSQL Audit 2018 R5 This release of ApexSQL Audit 2018 R5 comes with customizable user privileges and roles and Inactive repository system alerts. Beside these features, usability and quality are improved with 33 bugs and known issues fixed. ApexSQL Search 2018 This release of ApexSQL Search 2018 comes with Active directory - Password authentication, Azure SQL Database V12 "full" support (all new features), High DPI and 4K resolution support. Also, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts are applied, along with Visual themes. Beside these features, usability and quality are improved with 3 bugs and known issues fixed. ApexSQL BI Monitor 2018 R4 This release of ApexSQL BI Monitor 2018 R4 comes with support for standalone SSAS, SSIS and SSRS services. Beside this feature, usability and quality are improved. 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 CI/CD toolkit Web Dashboard - pipeline steps overview An introduction to ApexSQL CI/CD toolkit Web Dashboard An introduction to ApexSQL Decrypt An introduction to ApexSQL Diff An introduction to ApexSQL BI Monitor Blog Here are our most recent blog posts ApexSQL Audit 2018 R5 - Product update alert Visual dependency viewer feature deprecated in ApexSQL Search 2018 ApexSQL Search 2018 - Product update alert ApexSQL Enforce 2018 R3 - Product update alert Announcing performance monitoring for Azure SQL Database and Amazon Web Service RDS for SQL Server ApexSQL BI Monitor 2018 R4 - 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 Top things you need in a SQL Server query plan analysis tool Top things you need in a SQL Server formatting tool How to troubleshoot SQL Server performance problems using the SSMS Performance Dashboard How to master SQL Server performance baselining to avoid false positives and/or missing alerts How to implement compliance with GDPR for SQL Server Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog A high level overview of data auditing with ApexSQL Trigger Walkthrough example of configuring a CI pipeline with the ApexSQL CICD toolkit Reverse engineering a data source to a new model Exporting schema comparison results to Excel How to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio SQL Shack Here is a list of all SQL Shack articles published since our last newsletter Interview questions on SQL Server database backups, restores and recovery - Part III Interview questions on SQL Server database backups, restores and recovery - Part II Interview questions on SQL Server database backups, restores and recovery - Part I Concurrency problems - theory and experimentation in SQL Server SQL Server - development practices with referenced views SQL Server Execution Plans types Techniques to bulk copy, import and export in SQL Server Create a Soccer Heat map with Power BI Backup and Restore operations with SQL Server 2017 on Docker containers using SQL Operations Studio Use cases for Query Store in SQL Server Multiple methods for scheduling a SQL Server backup automatically Useful T-SQL techniques for development in SQL Server Identifying Object Dependencies in SQL Server Management Studio How to monitor and manage Transparent Data Encryption (TDE) in SQL Server Query optimization techniques in SQL Server: Database Design and Architecture Eating the frog: How to create a daily-deliverable sprint burn down graph in Excel Understanding Backup and Restore operations in SQL Server Docker Containers Recently added keys We keep increasing the value of our bundles with new releases and pre-releases. Recently added keys include 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 - The upcoming release of ApexSQL Generate will offer High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved. ApexSQL Trigger 2018 - The upcoming release of ApexSQL Trigger will offer High DPI and 4K resolution support, Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. 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 2018 Birmingham Dev BBQ (2nd Annual) Birmingham, AL - Jul 31 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
هیچ نظری موجود نیست:
ارسال یک نظر