Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
Untangle TempDB Performance with SQL Diagnostic Manager - Free Webinar
 

Managing and Monitoring Hybrid SQL Server Database Environments

(this is an on-demand video)

Sponsored by - Red-Gate

Webcast Abstract

In an ever changing SQL Server environment, efficient management and monitoring is critical. In this webcast we describe the differences between Azure DB and on-premises SQL Server database environments and show how these are managed differently by the Database Administrator. We'll hook up to both a traditional on-premises SQL Server environment and an Azure DB environment, comparing and contrasting methods of managing backups, examining the log files and using monitoring tools.

We will also demonstrate how to use the Azure Portal metrics to assess database health; which tools and techniques work well for both on-premises and Azure environments (including Activity Monitor and Dynamic Management Views) and demonstrate methods to back up and clone Azure databases. We'll look at recommendations, an Azure-based tool to make the most out of your Azure database performance, and talk about scaling your environments effectively.

Next, we'll demonstrate how to migrate a simple SQL Server database from on-premises to Azure using the Data Migration Assistant, and how to export an Azure database to .BACPAC and restore it on your local on-premises SQL Server instance.

Finally, we will learn about a solution from Redgate that can take your management and monitoring to the next level.

Speaker - Derek Colley and James King

To access materials please fill out the form below.

































  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.







More SQL Server Solutions











Learn more about SQL Server tools