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
PowerBI
PASS DATA COMMUNITY SUMMIT 2025
My ninth year at the Pass Data Community Summit started off with the obligatory photo
SSRS TO PBIRS: Move SSRS Reports to Power BI
Not too long ago, Microsoft announced that SQL SERVER REPORTING SERVICES (SSSRS) was being discontinued
Update Data Source Password Power BI
It’s password rotation day at my company today and I discovered that some of our
Check Dbcc Database Backup Verification for Data Recovery
Twice a year, auditors verify that — should there be an “incident,” we can recover
SQL PERFORMANCE MONITOR – BONUS: Power BI Dashboard
LEVEL: 300 – This quick article assumes that you already have at least one (1)
PowerBI Report Usage Stats
Today my boss wanted a report regarding how often each PowerBI report was being hit.
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