2025.03

• Added Scripting out Database Partition functions and schemes

2024.12

• Added Scripting out Database Users
• Changed Write-Output to Write-Host

2024.06

Updated 04_Agent_Jobs.ps1 - Fixed Asterisks in Jobname, added script out of all jobs to a single file Alljobs.sql

Full Changelog: v2022.04...v2024.06

April 2022

Added 04_Agent_Configuration.ps1 - SQL Agent configuration settings including the location of the Agent error log file
Added Job Schedule and Duration.pbix - for Visualizing Agent Jobs as a Gantt Chart to show overlaps

Jan 2021

Refactored 22 Policy Based Management to use standard SQL instead of SMO

August 2020

Added back 22_Policy_Based_Mgmt.ps1
Added new security audit script 51_Detailed_Security_Audit.ps1

SMO 160 Version

SQLTranscriptase-2020-05.zip

Updated LoadSQLSMO psm1 module for SMO version 1.60

Feb 2020 - SQL Saturday Tampa Version

• Moved SQLSMO into SQLTranscriptase