YoVDO

My Romantic Relation with Powershell Generally - and with dbatools Especially

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Docker Courses PowerShell Courses Database Administration Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover the power of PowerShell and dbatools for database administration in this comprehensive conference talk. Explore how a late adopter of PowerShell found immense value in dbatools for daily DBA tasks. Learn through practical demonstrations covering automatic restore testing, custom log shipping solutions, efficient migration processes, and streamlined upgrades and patching. Gain insights into dbatools' functionality, including Docker integration, module management, and SQL Server interactions. Dive into advanced topics such as credential handling, Azure storage integration, and metadata management. Master error handling techniques and backup strategies to enhance your DBA toolkit and boost productivity.

Syllabus

Introduction
What is dbatools
Demos
Famous Last Words
Docker Pull
Docker Volumes
Docker Create
Docker Start
dbatools
dbatools as a module
update dbatools
connect to containers
database
SQL credential
Object return
New dbalogin
Password
Cleaning up my storage container
Credentials
Shared Access Signature
Create Credential
Force Credential
Backup to URL
Timestamp Format
DBA Migration
What if
Copy DBA Login
DBA Tools Error Handling
Creating a Metadata Database
Getting the Last Full Backup


Taught by

PASS Data Community Summit

Related Courses

MongoDB for DBAs
MongoDB University
MongoDB Advanced Deployment and Operations
MongoDB University
内存数据库管理
openHPI
Data Cleansing with Data Quality Services (DQS)
Microsoft via edX
Recovering Data in Azure and SQL Server
Microsoft via edX