dbatools installs as a PowerShell module on a Windows management machine. Rob Sewell, known as DBA with Beard, introduced me to it.
Faster Backups With BUFFERCOUNT and MAXTRANSFERSIZE, Measured
Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.
The Evolution of the DBA – Challenges, Changes and Upcoming Trends
What scares a DBA more than a midnight downtime text? The changing job itself. Here is my take on the Evolution of the DBA: challenges, changes and trends.
Finding User Objects in master Created by Accident
Find user objects in master, inspect their purpose and dependencies, and prepare a safe move without removing deliberate server helpers.
Finding Which Indexes Use a Custom Fill Factor Setting
Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.
Row and Page Compression: Estimating Savings Before You Compress
Estimate row and page compression savings per index and partition, then compare storage, CPU, reads, and maintenance before deployment.
Do You Need an Availability Group? Matching RPO and RTO to a Feature
Match RPO and RTO to backups, log shipping, failover clusters, or availability groups, then test the full service recovery path.