ApexSQL September II 2018 newsletter - All about using the transaction log for replication, auditing, recovery and more Click here to view this newsletter in your browser ApexSQL September II 2018 newsletter In the last newsletter, we talked a bit about ApexSQL Log and how reading transaction log can be helpful in more than just a few situations. However, since a couple of sentences can't do justice to all the mighty powers of our transaction log reader, we decided to dedicate this entire newsletter to it. Interested in using a single tool for SQL Server replication, auditing, load testing or recovery purposes? Keep reading... Auditing ApexSQL Log is most commonly used for auditing purpose, which is why we're starting our tour here. Forensic auditing - Post-incident investigation is actually one of the most common usage of ApexSQL Log, which is why we prepared a couple of use case based articles to help you learn how to use ApexSQL Log to forensically audit your database and get to the bottom of that 'crime' DDL auditing - Check out how you can utilize ApexSQL Log to filter out, examine, report and export on all schema changes made to a database Before-after auditing - Drill down and see the values before and after the change has occurred on the row level, even before the ApexSQL Log was installed Continuous auditing - Check out how to continuously poll a transaction log and redirect output to a database, to create an easily accessible, always current, query-able version of your transaction log data. Monitoring Although not its primary purpose, ApexSQL Log, with its continuous auditing feature, can be used to isolate problems, assess any impacts to the overall system and configure reports to create a wealth of valuable aggregate information, such as transactional volumes by day, user, table application, machine etc. Restores and recovery Beside the auditing purpose of ApexSQL Log, another popular type of usage is recovery. After identifying who made the inadvertent changes, where and when as described above, one of the critical tasks after the database was affected by the disaster is to roll back those inadvertent changes and revert both structure and data to the pre-disaster original state. See also: Row-level recovery - See how to use ApexSQL Log to restore lost or damaged data, down to the row level, directly from a backup, or even the online log, without having to restore the entire database Point in time recovery - Similar to row-level recovery, ApexSQL Log can also help with restore only the specific database tables back in time without affecting other tables which do not require a rollback SQL injection attacks - SQL injection attacks are certainly no fun, but luckily, ApexSQL Log can help you immediately identify SQL injection attacks, isolate affected/damaged data and reverse/repair the damage. Load testing Interested in testing how your usual production loads will reflect on each new build of the database? Use ApexSQL Log to easily record loads on production and then replay them on staging, simulating a production environment Replication Mentioning transactional replication abilities of ApexSQL Log in the last newsletter raised quite an interest. Now we are presenting other use cases for using ApexSQL Log for the replication purposes Peer to peer, bi-directional replication - Check out how to replicate uni-directional process for each pear to perform bi-directional replication Cross-platform replication - SQL Server still doesn't support cross-platform replication on Linux... but this not a problem for you as you can use ApexSQL Log replicate from SQL Server on a Windows machine to Linux or any other combination Reporting servers - Utilize ApexSQL Log to maintain a reporting version of production database by offloading performance intensive queries Consolidated reporting - See how to set up ApexSQL Log to create multiple publishers into a single Subscriber to consolidate data across disparate databases, to provide a single, centralized reporting database. Migrations and restores The major flaw of database migrations and usual point-in-time restores is that they might result in loss of certain data. Learn how to prevent this data loss during SQL Server database migrations with ApexSQL Log Discounts In one of the previous newsletters, we offered 20% off all ApexSQL Log purchases, but with more features comes a bigger discount, so we're now offering 50% discount on all ApexSQL purchases for all our subscribers. This means that until the next newsletter, you can purchase ApexSQL Log and get all this functionality for $999 $1,999 only. For existing customers, you can combine this discount with volume discounts, starting at two licenses, for even bigger discounts. Please contact us at sales@apexsql.com or use APEXSQL-LOG50 promo code for online purchases to claim your discount Kristina Stanisavljevic ApexSQL Marketing team @kicko_kiki What's new Here are our most recent releases: ApexSQL Search 2018 R2 This release of ApexSQL Search 2018 R2 comes with the new error handling and send logs functionality, improved application installer with a dark theme and the new application icon. Beside these features, usability and quality are improved with 1 bug fixed. ApexSQL Job 2018 R2 This release of ApexSQL Job 2018 R2 comes with the new error handling and send logs functionality, improved application installer with a dark theme and the new application icon. Delete operation can be run on multiple jobs. Beside these features, usability and quality are improved with 7 bugs and known issues fixed. ApexSQL Refactor 2018 R3 This release of ApexSQL Refactor 2018 R3 comes with the new error handling and send logs functionality, improved application installer with a dark theme and the new application icon. Beside these features, usability and quality are improved with 7 bugs and known issues fixed. ApexSQL Backup 2018 R4 This release of ApexSQL Backup 2018 R4 comes with the new error handling and send logs functionality, improved application installer with a dark theme and the new application icon. Beside these features, usability and quality are improved with 4 bugs and known issues fixed. ApexSQL CI/CD toolkit 2018 R3 This release of ApexSQL CI/CD toolkit 2018 R3 comes with the new feature for PowerShell scripts: exclude tables from auditing step. Beside this feature, usability and quality are improved with 1 bug fixed. ApexSQL Data Diff 2018 R5 This release of ApexSQL Data Diff 2018 R5 comes with high DPI and 4K resolution support, new error handling and send logs functionality, improved application installer with a dark theme, new application icon, Save automation script as a PowerShell script option, Visual Studio integration support, Active Directory - Password and Integrated authentication support, Comparison summary output is added under the Export options in the Home tab, Ignore pre-processing script failure option is added under the Synchronization options, 5 additional outputs are added in the Automation script window. Also, we added 6 new CLI switches. Beside these features, usability and quality are improved with 33 bugs and known issues fixed. ApexSQL Trigger 2018 This release of ApexSQL Trigger 2018 comes with the new error handling and send logs functionality, improved application installer with a dark theme, new application icon, Save automation script as a PowerShell script option, CLI switches: Skip audited tables [/eat], Exclude tables for auditing [/et]. Beside these features, usability and quality are improved with 8 bugs and known issues fixed. See What's new for descriptions of all of our recent releases Videos Take a look at our most recent videos: An introduction to SQL Server database continuous delivery with the ApexSQL CI/CD toolkit - TeamCity plugin An introduction to SQL Server database continuous integration with the ApexSQL CI/CD toolkit - TeamCity plugin 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 Blog Here are our most recent blog posts: ApexSQL Search 2018 R2 - Product update alert ApexSQL Job 2018 R2 - Product update alert ApexSQL Backup 2018 R4 - Product update alert ApexSQL Refactor 2018 R3 - Product update alert ApexSQL CICD toolkit PowerShell scripts - Product update alert ApexSQL Data Diff 2018 R5 - Product update alert ApexSQL Trigger 2018 - Product update alert The new ApexSQL installer 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: SQL Server transaction log reader use cases Top things you need in a SQL Server performance monitoring tool (from deadlocks monitoring to alerting and index monitoring) SQL Server database Forensic auditing including row history and before-and-after auditing Load testing: Recording production transactions and replaying on a test server Hands free, no-coding SQL Server database replication of a reporting database Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog: Upgrading and Updating Creating Custom tasks in ApexSQL Model How to configure continuous auditing in ApexSQL Log Using the query waits feature A high level overview of data auditing with ApexSQL Trigger SQL Shack Here is a list of all SQL Shack articles published since our last newsletter: Load testing for SQL Server Reporting Services (SSRS) SQL UNION overview, usage and examples SQL Server installation and upgrade troubleshooting interview questions Three Steps to quickly solve SQL Server High CPU usage Using the SQL Coalesce function in SQL Server How to embed a Power BI Report Server report into an ASP.Net web application Deploy SQL Server with Cluster Shared Volumes - part 2 Text Analytics with Microsoft Flow SQL Server Data Import using SQL Operations Studio SQL Server database backup tools Querying data using the SQL Coalesce function Available options for generating heatmaps in an SSRS report SQL Join overview and tutorial SQL Server database auditing tools Advanced SQL Interview Questions and Answers on SQL Server Architecture SQL Substring function overview SQL Server Reporting Services (SSRS) Shared Dataset How to perform a performance test against a SQL Server instance Top free add-ins for SQL Server Management Studio (SSMS) SQL string functions for Data Munging (Wrangling) SQL Server transactional replication: How to reinitialize a subscription using a SQL Server database backup Querying data using the SQL Case statement SQL Replication: Basic setup and configuration How to setup a custom SQL Server transaction replication model with a Central Subscriber and Multiple Publisher databases SQL Server replication: Overview of components and topography How to create a Mobile Dashboard with SQL Server Microsoft Mobile Publisher? How to Analyze SQL Execution Plan Graphical Components Recently added keys We keep increasing the value of our bundles with new releases and pre-releases. Recently added keys include: Aug 07, 2018 ApexSQL Manage Pre-release ApexSQL DBA 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 Audit 2018 R6 - The upcoming release of ApexSQL Audit will include Filter before-after events by column and value, Include Primary key value on before-after auditing, Bulk-inserts before-after auditing, Usability and quality will be improved. Read more ApexSQL Model 2018 R2 - The upcoming release of ApexSQL Model will include the options such as: Export model diagrams to PDF format, Source Control, SQL Server Management Studio and Visual Studio integration. Usability and quality will be improved. Read more ApexSQL Monitor 2018 R7 - The upcoming release of ApexSQL Monitor will include Deadlock graph viewer, Metric data time slice comparison, additional built-in reports, full support for Azure SQL Database. Usability and quality will be improved. Read more ApexSQL Source Control 2018 R6 - The upcoming release of ApexSQL Source Control will include improved application installer with a dark theme, new application icon and high DPI and 4K resolution 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: Hampton Roads SQL Server User Group Meeting Virginia Beach, USA - Oct 17 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
