- Course
Operate SQL Server Data Warehouses in Production
A warehouse load can finish successfully while its data is late, incomplete, or unsafe. This course will teach you to monitor delivery, manage access and changes, and recover failed SQL Server warehouse loads.
Intermediate
- Course
Operate SQL Server Data Warehouses in Production
A warehouse load can finish successfully while its data is late, incomplete, or unsafe. This course will teach you to monitor delivery, manage access and changes, and recover failed SQL Server warehouse loads.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
A production warehouse must deliver complete, current, and protected data.
In this course, Operate SQL Server Data Warehouses in Production, you’ll gain the ability to support a SQL Server warehouse in production.
First, you’ll explore how to monitor loads, data freshness, row counts, resources, alerts, and delivery targets.
Next, you’ll discover how to manage role-based access, sensitive data, schema changes, releases, and documentation.
Finally, you’ll learn how to diagnose failed loads, replay incomplete processing safely, choose a recovery method, and review incidents.
When you’re finished with this course, you’ll have the skills and knowledge of production SQL Server warehouse operations needed to keep data available and recover service when problems occur.
Operate SQL Server Data Warehouses in Production
Intermediate
Table of contents
Pinal Dave is a Pluralsight Developer Evangelist.
