Erin is a Microsoft MVP (Data Platform), working primarily with Microsoft SQL Server/Azure SQL, as well as Azure DevOps. She currently works in the insurance industry but has previous experience in banking, manufacturing and healthcare. Additionally, Erin has been an application developer, using C# .Net, and a SQL Server database administrator.
Outside of work, Erin enjoys golfing, biking, sightseeing and relaxing around the house. She currently lives in Minneapolis, MN.
Education
- Bachelor’s of Science in Computer Science – Dakota State University, Madison SD
- Master’s of Science in Information Assurance – Dakota State University, Madison SD
Current Certifications
- Microsoft Certified Azure Solutions Architect Expert (Certified 2020 – Nov 2023)
- Microsoft Certified Solutions Expert: Data Management and Analytics (Certified 2017 – present)
- Microsoft Certified Solutions Associate: SQL Server 2016 Development (Charter member) (Certified in 2019)
Previous Certifications
- Microsoft Certified Solutions Associate: SQL Server 2012/2014 (Certified in 2016)
- Microsoft Certified IT Professional: Database Developer on SQL Server 2005 (Certified in 2010)
- Microsoft Certified IT Professional: Database Administrator on SQL Server 2005 (Certified in 2007)
Presentations
“Reducing Data Warehouse Processing with PowerShell Pre-ETL Processing”
- Data Saturday Atlanta – October 1st, 2022 – Slides PDF
- SQL Saturday Boston – October 8th, 2022 – Slides PDF
- SQL Saturday Oregon & SW Washington– November 12th, 2022
“Power Up Your Data Warehouse with Pre-ETL Processing”
- PASS Data Community Summit – November 18th, 2022
“Navigating Row Level Security”
- SQL Saturday St Louis – February 8th, 2020 – Slides PDF
- PASSMN February Meeting – February 18th, 2020 – Slides PDF
- SQL Saturday Iowa City – August 1st, 2020
- SQL Saturday Oregon – October 24th, 2020
- PASS Virtual Summit 2020 – November 11, 2020
Previous Articles
(written for Superior Consulting Services while in their employment)
- Querying Role-playing Dimensions with DAX
- Reporting Services – Filtering Data by Current User
- Maximizing SQL Server Integration Services
Erin Dempster 