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
Windows PowerShell FundamentalsMicrosoft via edX Windows 10 Features for a Mobile Workforce: Managing and Maintaining Devices in the Enterprise
edX Deploying Your First Resources in Azure
Udemy Advanced Server 2016 Administration: Hands-on Training
Udemy Windows Server 2016 Administration
Udemy