Free learning courses

Learn Microsoft SQL Server 2016

Register for recorded learning courses

Explore Microsoft SQL Server 2016 episodes

  • Episode 1

    Veeam and Microsoft SQL Server 2016 – 101

  • Episode 2

    Veeam and Microsoft SQL Server 2016 – Always-On

  • Episode 3

    Veeam and Microsoft SQL Server – Deep-Dive 2016

  • Topics include:
  • Microsoft Services components that make up SQL Server 2016
  • Microsoft SQL Server Management Studio
  • Database and log files
  • Database recovery models
  • Microsoft VSS and Microsoft SQL Server 2016
  • Veeam Explorer for Microsoft SQL
  • Topics include:
  • How Veeam protects databases and log files
  • How Veeam protects SQL Server AlwaysOn Availability Groups
  • Restores to point in time using Veeam Explorer for Microsoft SQL Server 2016
  • Restores to a specific transaction using Veeam Explorer for Microsoft SQL Server 2016
  • Starting SQL Server 2016 in the Veeam Virtual Lab
  • Topics include:
  • Database exclusions from backups
  • Transaction log management deep-dive
  • Performing database maintenance tasks using Veeam pre and post-scripts
  • Web interface for database self-service restores
  • Automatic recovery verification using Veeam SureBackup

Speakers

speaker pic

Alexander Shelemin

Alexander is a developer in Veeam working on SQL Server database architecture and optimization. Before joining the R&D team, he worked as a technical support engineer in Veeam for 2 years, specializing in SQL Server related problems.

speaker pic

Martin Plesner-Jacobsen

Martin worked as a consultant for 13 years, and has many years of experience in optimizing large customer solutions with business needs in mind. Martin focuses on Microsoft and VMware products, and he holds certifications in many Microsoft and VMware technologies.

Webinars description

Veeam and Microsoft SQL Server 2016 – 101

The first video tutorial of the Veeam Microsoft SQL Server Series will help you to get started with SQL Server 2016. It will focus on basics such as SQL Server 2016 architecture, its key components and their functions.

In this video, our experts will explain how to configure your SQL Server 2016 correctly to avoid future headaches. You will learn why it's important to have multiple SQL Server 2016 instances, how to manage data and log files, and which tools you can use for SQL Server 2016 administration. A live demo will help familiarize you with Microsoft SQL Server Management Studio, a primary SQL Server 2016 administration software. This video also covers Microsoft VSS basics and the specifics of database recovery models, backup types and restores to help you prepare for the further discussion on availability for an SQL Server 2016. You will also learn how to restore and export an SQL database with Veeam Explorer for Microsoft SQL.

Veeam and Microsoft SQL Server 2016 – Always-On

As a data platform for business-critical applications enabling the Always-On Business, SQL Server requires the most reliable protection. This video tutorial – enriched with live demos – covers three main topics on SQL Server 2016 protection, which include SQL transaction log management, restore options for Microsoft SQL Server databases and getting the most out of your SQL backups with Veeam's Virtual Lab.

You will learn how to configure SQL backup job settings in Veeam Backup & Replication, when to use the copy-only mode for SQL backups and how you can benefit from Veeam's full support for SQL Server AlwaysOn availability groups. You'll see how to easily perform different restore scenarios for SQL databases with a live demo of Veeam Explorer for Microsoft SQL. And, the tour around Veeam's Virtual Lab is the cherry on top of this episode! Our experts will explain how it works and present several scenarios that use Virtual Lab for SQL backup recovery verification and software-patches tests.

Veeam and Microsoft SQL Server – Deep-Dive 2016

This episode wraps up our SQL Server 2016 course with a technical deep-dive on the SQL Server Always-On availability enabled by Veeam. It will show you how things work under the hood, so you can maximize your SQL Server 2016 protection.

Join our experts to learn about unique features of Veeam Backup & Replication, which help to ensure availability of your business's critical applications and services. Specifically, you will learn how you can granularly exclude SQL databases from your backups, troubleshoot issues with transaction log management, and how to delegate database restores or perform a self-service restore. Additionally, in this video tutorial, we'll discuss using PowerShell scripts for Veeam SQL backup automation and SureBackup® recovery verification.

Disclaimer: Although earlier versions of SQL Server and Veeam® Availability Suite were mentioned in this webinar, the information in the webinar is also applicable for SQL Server 2016 and Veeam Availability Suite 9.5.