ApexSQL November 2018 newsletter - All about using the SQL Server data recovery to recover damaged, deleted, dropped, or lost data Click here to view this newsletter in your browser ApexSQL November 2018 newsletter Welcome to another ApexSQL newsletter! In this newsletter, we'll be focusing entirely on SQL Server data and structure recovery tool use cases. We will also offer a 20% discount to ApexSQL Recover. Losing data is no fun, so stay with us to learn how ApexSQL Recover can help you with restore and recovery, migration and restores, and data and structure extraction situations. Restores and recovery Data restoration and recovery are the primary functions of ApexSQL Recover, which is why we're starting our tour here. Disaster recovery In most cases, the recovery process starts by identifying the inadvertent changes - who made the change, where and when and how the changes impacted the original data and structure. The goal of this investigation is to be able to roll back the data/structure to the state before the disaster. ApexSQL Recover comes in handy here as it allows you to investigate the transaction log to understand all the important factors that led to the disaster. But more importantly, it gives you an easy way to use this information to create proper recovery (undo) script and execute it to complete the recovery process Backup-less recovery The best thing about ApexSQL Recover is probably the fact it might be able to perform a successful recovery even if you have no backups. ApexSQL Recover utilizes information from within the transaction log file and database file to allow recovery by creating an undo script to rollback any inadvertent changes SQL injection attacks Being a victim of a SQL injection attack can have a serious impact on your data. Luckily, ApexSQL Recover lets you identify and recover from SQL injection attacks quickly and easily. Use it to analyze the transactions and individual operations to determine the changed and damaged data - up to the row level, and then create rollback scripts to reverse negative impact from the malicious attack. See also Row-level recovery - Learn how to use ApexSQL Recover to rollback only the specific changes with pinpoint precision and ensure that the recovery process affects only specific table rows Deleted, dropped or truncated data/structure recovery - ApexSQL Recover allows you to recover from accidental delete, truncate or drop operations. You can create an undo script or recover directly to a new database DDL recovery and replay - Analyze transaction log files and create undo or redo scripts to roll changes back and forward. Point in time restores - Similar to row-level recovery, ApexSQL Recover can also help with restoring only the specific database tables back in time without affecting other tables which do not require a rollback BLOB data recovery - Learn how to recover lost BLOBs directly as data files, making it easy to get them back to the database or immediately check the files out of the database Migration 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 Recover Data and structure extraction Looking into a database backup using SQL Server own tools requires the backup to be restored as a database. This requires a lot of resources. ApexSQL Recover, on the other hand, lets you look into your database backups directly so you can extract table data for specific object only. This will save you tremendous amount of resources and time. For more details on SQL Server data and structure recovery tool use cases, check out the article SQL Server data and structure recovery tool use cases Discounts In this newsletter, we are offering 20% discount on ApexSQL Recover purchases for all our subscribers. This means that until the next newsletter, you can purchase ApexSQL Log for $1,599 $1,999 Interested? Contact sales to claim your 20% discount or use APEXSQL-RECOVER20 promo code for online purchases Want to learn more about ApexSQL Recover? See the product page for more info Kristina Stanisavljevic ApexSQL Marketing team @kicko_kiki What's new Here are our most recent releases: ApexSQL Unit Test 2018 R2 This release of ApexSQL Unit Test 2018 R2 comes with SQL Server 2019 CTP 2.0 support, SQL Server Management Studio 18 integration, new error handling and send logs functionality and improved application installer with a dark theme. Beside these features, usability and quality are improved with 1 bug fixed. ApexSQL Refactor 2018 R4 This release of ApexSQL Refactor 2018 R4 comes with SQL Server 2019 CTP 2.0 support and SQL Server Management Studio 18 integration. Beside these features, usability and quality are improved with 14 bugs fixed. ApexSQL DevOps toolkit 2018 R5 This release of ApexSQL DevOps toolkit 2018 R5 comes with "exclude tables from auditing" feature in TeamCity plug-in. Beside these features, usability and quality are improved with 15 bugs 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 ApexSQL Build Reviewing and resolving alerts in ApexSQL Monitor An introduction to ApexSQL Analyze An introduction to SQL Server database continuous delivery with the ApexSQL DevOps toolkit - TeamCity plugin An introduction to SQL Server database continuous integration with the ApexSQL DevOps toolkit - TeamCity plugin Blog Here are our most recent blog posts: ApexSQL Search 2018 R4 - Product update alert ApexSQL Unit Test 2018 R2 - Product update alert ApexSQL Log 2018 R3 - Product update alert ApexSQL Source Control 2018 - Screen shot tour ApexSQL Audit 2018 R7 - Product update alert ApexSQL BI Monitor 2018 R6 - Product update alert ApexSQL Refactor 2018 R4 - Product update alert ApexSQL DevOps toolkit 2018 R5 - 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: SQL Server data and structure recovery tool use cases SQL Join introduction and overview 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 Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog: How to configure and use deadlock monitoring How to setup continuous integration and continuous delivery tasks using the ApexSQL DevOps toolkit Bamboo plugin How to integrate the ApexSQL DevOps toolkit PowerShell scripts with VSTS Upgrading and Updating Creating Custom tasks in ApexSQL Model SQL Shack Here is a list of all SQL Shack articles published since our last newsletter: 40+ SQL Interview Questions and Answers on SQL Server AlwaysON Availability Groups SQL Execution Plan enhancements in SSMS 18.0 SQL Like logical operator introduction and overview Overview of the ROW_NUMBER SQL function in SQL Server The new SQL Server 2019 function Approx_Count_Distinct How to use JSON data in Azure Machine Learning Hexbin Scatterplot in Power BI Desktop Columnstore Index Enhancements in SQL Server 2019 - Part 1 Getting Started with Azure Cosmos DB and MongoDB API How to secure Reporting Services with Group Managed Service Accounts Power BI desktop Mekko Charts SQL Server 2019 Enhanced PolyBase - Part 4 How to use JSON data in SSRS Graph database implementation with Azure Cosmos DB using the API SQL interview questions and answers on SQL Server Failover Clusters - II SQL interview questions and answers on SQL Server Failover Clusters - I SQL date format Overview; DateDiff SQL function, DateAdd SQL function and more SQL Server 2019 Enhanced PolyBase - Part 3 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 Backup 2018 R5 The upcoming release of ApexSQL Backup will include features such as: SQL Server 2019 CTP 2.0 support, Azure SQL Database, Snapshot file backup and restore, Backup policies, Customizable reports and Real-time activities status information. Usability and quality will be improved. ApexSQL Diff 2018 R3 The upcoming release of ApexSQL Diff will include the features such as: SQL Server 2019 CTP 2.0 support, SQL Server Management Studio 18 integration support, New application icon, New error handling and send logs functionality, Improved application installer with a dark theme, Active Directory - Password and Integrated authentication support, Save automation script as a PowerShell script, Visual Studio integration support, Comparison summary output, Ignore pre-processing script failure option, 5 additional outputs in the Automation script window and 6 new CLI switches. Usability and quality will be improved. Read more ApexSQL Model 2018 R2 The upcoming release of ApexSQL Model will include the features 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 Script 2018 R2 The upcoming release of ApexSQL Script will include SQL Server 2019 CTP 2.0 support, high DPI and 4K resolution support, new application icon, new error handling and send logs functionality, improved application installer with a dark theme and Active Directory - Password and Integrated authentication support. User will be able to save automation script as a PowerShell script, and check for object existence with If exists/If not exists option. This release will also include 2 new CLI switches. Usability and quality will be improved. ApexSQL Source Control 2018 R9 The upcoming release of ApexSQL Source Control will include support for Visual Studio status icons and SQL graph tables. 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 - Nov 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
هیچ نظری موجود نیست:
ارسال یک نظر