The Enterprise Scripting Workshop
summary
Shows how PowerShell carrier method runs SQL scripts across servers and databases, using Import-Module/SQLPS and querying sys.databases to target names. Demonstrates deploying SP files to 74 DBs in one run, describes real cases with 3,000+ servers and a box holding 177,000 databases, and a script that cuts a contractor access job from roughly a week to five minutes. Covers handling object-exists errors, templates, avoiding one-off/manual processes, and turning ad hoc scripts into enterprise-grade automation.
AI-written summary · about
chapters (29)
- 0:00Introduction
- 6:44Story Time
- 15:08Demo
- 17:08Cursor
- 20:28Single Database
- 24:58Multiple Files to Multiple Databases
- 28:20Adding Objects to One Database
- 30:03Deploying Objects to Multiple Databases
- 32:33Enterprise Philosophy
- 33:18Seans Day
- 33:48Busy or productive
- 35:54Enterprise Scripting
- 38:03What is an Enterprise
- 39:17What is an Enterprise Hell
- 41:59Enterprise Mistakes
- 42:15Oneoff Solutions
- 44:08Example
- 46:20Manual Processes
- 47:53One Time
- 48:10File Watcher
- 49:46I Need This
- 50:31Read Only
- 51:06Script
- 52:16Questions
- 52:50Versions
- 53:40Templates
- 55:16PowerShell
- 56:15Wrapup
- 57:52Monster Text Manipulation Session
related talks
43mScripting Big Changes With Small Risk
03h 41mA Scripters Next Step...
40mFrom Chaos to Clarity: Taming Data with PowerShell
44mImprove PowerShell Code Efficiency with .NET RunSpaces
01h 45mWriting Award Winning PowerShell Functions and Script Modules
45mUsing PowerShell to be a Linux Administrator
01h 33mA hands-on lab working
01h 11mWriting your own CLI tools with PowerShell: A case study of...