Automating SQL Server with dbatools

Focused View

Jess Pomfret

1:00:25

108 View

01 - Introduction

01 - Why dbatools.mp4

01:06

02 - What you should know.mp4

01:00

03 - Setting up your environment.mp4

02:22

02 - 1. What Is dbatools

01 - Introducing dbatools.mp4

01:40

02 - Installing and updating the module.mp4

02:30

03 - Find the command you need.mp4

01:59

04 - Running your first command.mp4

02:50

03 - 2. Get Information

01 - Get a list of SQL Servers in your environment.mp4

03:33

02 - Get database status across your estate.mp4

03:49

03 - Check database last backup times.mp4

02:22

04 - Get SQL Server patch levels.mp4

03:19

05 - Review SQL Server Configuration Settings.mp4

02:41

06 - Find failed SQL Agent jobs.mp4

03:11

04 - 3. Set Information

01 - Set databases online or offline.mp4

02:14

02 - Discover and apply recommended data compression levels.mp4

04:04

03 - Update database compatibility levels.mp4

02:06

04 - Insert data into SQL Server tables.mp4

02:52

05 - 4. Migrations Made Easy with dbatools

01 - Migrate whole instances with one line of code.mp4

02:46

02 - Simple database migrations.mp4

03:02

03 - More advanced database migrations.mp4

03:44

04 - Migrating logins.mp4

02:49

05 - Exporting documentation.mp4

03:29

06 - Conclusion

01 - Continue your learning.mp4

00:57

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Jess Pomfret

Instructor's Courses

Jess Pomfret is a Data Platform Architect and a Microsoft MVP. She started working with SQL Server in 2011, and enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell. She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She has also contributed to the SqlServerDsc module, adding several new resources to use when configuring your SQL Servers. She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.