Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Automating SQL Server with dbatools

Automating SQL Server with dbatools

1hIntermediate2022-11-03

Authors

Jess Pomfret

Jess Pomfret

Database Platform Architect and Microsoft MVP

Course details

If you want to learn more about automating SQL Server, you’ve come to the right place. Did you know you can use the open-source PowerShell module dbatools to manage your SQL Server estate? In this course, instructor Jess Pomfret covers the skills you need to know to automate SQL Server with dbatools, helping you optimize your workflow, database performance, and overall server management experience.

Learn about the history of dbatools and why it should become one your trusted go-to tools, as Jess shows you how dbatools can accomplish most of the tasks available in SQL Server Management Studio. Find out how to handle multiple instances, databases, and logins at the same time, as well as gather and set information, change configurations, and migrate instances. Upon completing this course, you’ll be prepared to keep building on your new skills so you can become a more effective and efficient database administrator.

Skills covered

SQL ServerDatabase AdministrationDatabase ManagementMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

  • 01 - Why dbatools
  • 02 - What you should know
  • 03 - Setting up your environment

1. What Is dbatools

  • 04 - Introducing dbatools
  • 05 - Installing and updating the module
  • 06 - Find the command you need
  • 07 - Running your first command

2. Get Information

  • 08 - Get a list of SQL Servers in your environment
  • 09 - Get database status across your estate
  • 10 - Check database last backup times
  • 11 - Get SQL Server patch levels
  • 12 - Review SQL Server Configuration Settings
  • 13 - Find failed SQL Agent jobs

3. Set Information

  • 14 - Set databases online or offline
  • 15 - Discover and apply recommended data compression levels
  • 16 - Update database compatibility levels
  • 17 - Insert data into SQL Server tables

4. Migrations Made Easy with dbatools

  • 18 - Migrate whole instances with one line of code
  • 19 - Simple database migrations
  • 20 - More advanced database migrations
  • 21 - Migrating logins
  • 22 - Exporting documentation

Conclusion

  • 23 - Continue your learning

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal