My Romantic Relation with Powershell Generally - and with dbatools Especially
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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
Doing More with Less - The Challenges Ahead for Every Data ProfessionalPASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube