ApexSQL September 2018 newsletter - ApexSQL Discover release, ApexSQL Log magic powers, Top things you need in a SQL Server performance monitoring tool and a BIG discount for monitoring tools Click here to view this newsletter in your browser ApexSQL September 2018 newsletter In this newsletter we'll be highlighting our latest new product, ApexSQL Discover, presenting more SQL Server transaction log reader use cases, and discussing the top things a SQL Server performance monitoring tool needs, so let's get started ApexSQL Discover - new product We are excited to announce the first release of ApexSQL Discover - a FREE SQL Server tool used for scanning local network domain for SQL Server instances, as well as SSRS, SSIS and SSAS services. The virgin release includes the following features: List all SQL Server instances in a domain Discover SQL Server instances and SSRS, SSAS and SSIS services Manage multiple SQL Server discovery jobs View SQL Server health and statistics Schedule discovery, inventory and analysis Report and export results to PDF, HTML or image formats GUI themes For more information, see the ApexSQL Discover product page and for a full review of all features and screen shots see What's new in ApexSQL DBA: ApexSQL Discover - SQL Server instance search and inventory The magic powers of ApexSQL Log - continued... In the last newsletter, we talked about several use cases where reading transaction log can be helpful. Now we present a few more covering replication, auditing, load testing, recovery and more... Row-level recovery - 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 - Roll back an entire database or only specific database tables to the exact point in time DDL auditing - Track any DDL changes and roll back any unintended structure changes on SQL Server database tables No downtime/data loss migrations - Ensure that no transactions are missing after migration downtime by replaying the transactions which have occurred during the downtime period by replaying them on the migrated database by reading the transaction log file SQL injection attacks - Immediately identify SQL injection attacks, isolate affected/damaged data and reverse/repair the damage Before-after auditing - Drill down and see the values before and after the change has occurred on the row level And this is still not all... For all the use cases, check out SQL Server transaction log reader use cases Top things you need in a SQL Server performance monitoring tool If you are a SQL Server database administrator, then it's likely that having to deal with the performance problems is one of your worst nightmares... It's also likely that to deal with these problems, you'll want to use a monitoring tool to help you sleep at nights. But what makes a good SQL Server performance monitoring tool? Check out the two articles below to learn about the top things that a SQL Server performance monitoring tool should have to be able to help database administrator in keeping the SQL Server in a top condition: Top things you need in a SQL Server performance monitoring tool (from performance metrics to wait statistic and query performance monitoring) Top things you need in a SQL Server performance monitoring tool (from deadlocks monitoring to alerting and index monitoring) Discounts For this newsletter, we prepared a special deal for our monitoring solutions. If you need to monitor, detect, alert on and solve performance issues across SQL Server, Windows, Virtualized (Hyper-V, VMware) and Business intelligence (SSIS, SSRS, SSAS) environments, no doubt you'll love this offer! Until the next newsletter, we are offering you an opportunity to save 50% on all three ApexSQL monitoring tools, bought together, and get them for $1,997 $999: ApexSQL Monitor - SQL Server and Windows ApexSQL VM Monitor - Virtualization ApexSQL BI Monitor - Business intelligence Interested? Just email us at sales@apexsql.com and claim your discount Kristina Stanisavljevic ApexSQL Marketing team @kicko_kiki What's new Here are our most recent releases ApexSQL Discover 2018 This release of ApexSQL Discover 2018 comes with options to list all SQL Server instances in a domain, Discover SQL Server instances and SSRS, SSAS and SSIS services, manage multiple SQL Server discovery jobs, view SQL Server health and statistics, schedule discovery, inventory and analysis, Report and export results to PDF, HTML or image formats. 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 Diff 2018 - Screen shot tour ApexSQL tool icons - Screen shot tour ApexSQL Discover 2018 - Product update alert ApexSQL Source Control 2018 R5 - Product update alert ApexSQL Analyze 2018 R2 - 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 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 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 Walkthrough example of configuring a CI pipeline with the ApexSQL CICD toolkit SQL Shack Here is a list of all SQL Shack articles published since our last newsletter How to create a SQL dependency diagram in SQL Server Deploy SQL Server for failover clustering with Cluster Shared Volumes - part 1 SQL Query Optimization Techniques in SQL Server: Parameter Sniffing How to setup cross-platform transactional SQL Server replication for database reporting on Linux Top 50 PowerShell bloggers of 2018 Considerations and concerns when setting up Database mail for SQL Server How to integrate Power BI data alerts into Slack SQL Server Setup - Instant File Initialization (IFI) SQL Server Dedicated Admin Connection (DAC) - how to enable, connect and use SQL Server Setup - Database Alerts How to do a quick estimated compare of data in two large SQL Server databases to see if they are equal How to setup custom SQL Server transactional replication with a central publisher and multiple subscriber databases Creating Bollinger Bands with SQL Server Reporting Service reports How to Add/Drop articles from existing publications in SQL Server Performance troubleshooting when the query plan from the application is different than SSMS How to continuously audit transaction log file data directly into a SQL Server database How to continuously read Transaction log file data directly in a SQL Server database with fn_dblog and fn_dump_dblog How to handle SSRS multi-value parameter filtering in SQL Server Parallel Data Warehouse Understanding automatic tuning in SQL Server 2017 How to set up a DDL and DML SQL Server database transactional replication solution Top SQL Server LinkedIn groups How to collect performance and system information in SQL Server Shrinking your database using DBCC SHRINKFILE SQL Server database migrations with zero data loss and zero downtime 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 Data Diff 2018 R5 - The upcoming release of ApexSQL Data Diff will offer High DPI and 4K resolution support. Usability and quality will be improved. 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 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 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
هیچ نظری موجود نیست:
ارسال یک نظر