Automated Weekly Data Ingestion Using PowerShell, AWS S3, and SQL Server
Background This month, my team was tasked with implementing a weekly data import from a
SSIS
PASS DATA COMMUNITY SUMMIT 2025
My ninth year at the Pass Data Community Summit started off with the obligatory photo
SQL LOGIN PASSWORD MANAGER
Right before I went on vacation, in an audit, we discovered that occassioanlly there was
Shrink Database
Code snippets for shrinking database and database log files for EC2 and OnPrem. This will
SQL PERFORMANCE MONITOR – PART 7: PULL METRICS INTO DATA WAREHOUSE
In this part (7) I will continue building my performance monitor by setting up a
SQL PERFORMANCE MONITOR – PART 6: Outputting Metrics to a CSV File (SSIS)
I WILL NEED Visual Studio with tools for SSIS installed on my local workspace. I’m
SQL PERFORMANCE MONITOR – PART 5: Capturing Metrics
This is PART 5 in my series on Creating a SQL Performance Monitor that works
SQL PERFORMANCE MONITOR – PART 4: AWS BUCKET & IAM USER SET UP
AWS CONFIGURE S3 BUCKETS [1] CREATE BUCKET on each AWS account where files will be
SQL PERFORMANCE MONITOR – PART 3: SQL DATABASES
In this part of our SQL PERORMANCE MONITORING project we are going to create the
SQL Performance Monitor – Part 2: Active Directory User
This is Part 2 of my plan to set up SQL Monitoring between AWS accounts