Your cart is currently empty!
About Erin Dempster
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: DevOps Engineer Expert (Certified May 2023 – Present)
- 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 Azure Solutions Architect Expert (Certified 2020 – Nov 2023)
- 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
“Automating Database Deployments” (Full-day pre-conference session)
- PASS Data Community Summit – November 13th, 2023
“Automating Deployments with Azure DevOps” (Full-day pre-conference session)
- SQLBits 2023 – March 15th, 2023
- SQL Saturday Minnesota – September 29th, 2023
“Introduction to Automating Deployments with Azure DevOps”
- SQL Saturday Austin – February 23rd, 2023
- PASSMN User Group Meeting – March 22nd, 2023
- SQL Saturday NYC – May 6th, 2023
- SQL Saturday Columbus – July 14th, 2023
- SQL Saturday Baton Rouge – July 28th, 2023
- SQL Saturday Minnesota – September 30th, 2023
- DevIntersection – December 6th, 2023
“Introduction to Automated Deployments with GitHub”
- DevIntersection – December 6th, 2023
“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
- SQL Saturday Minnesota – December 3rd, 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