Erin Dempster

Erin has worked for many years with SQL Server, starting with SQL Server 7.0, and considers herself to be a "data generalist." Her skills go beyond SQL Server, having worked as a software developer many years ago, using ASP.Net and some JSP. In recent years, Erin has worked considerably with PowerShell, transitioning knowledge of .Net classes to PowerShell to make data import processes easier for her teams. Since 2021, she has taken on the role Azure DevOps administrator at Trean Corporation, in addition to her duties as a DBA and systems architect. Beyond her daily roles, Erin has spoken at many SQL Saturday events, as well as SQL Bits and multiple times at PASS Summit. For her dedication to sharing knowledge with the SQL Server community, in 2023, Microsoft recognized Erin with the Data Platform MVP Award.
  • Skills: SQL Server, Azure DevOps, SSIS/Azure Data Factory

Stairway to Database DevOps

Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)

The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2023-12-06

2,504 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 3: Managing Code as a Team in Git

In this level of the Stairway to Database DevOps, you'll get an introduction to branching and merging. Learn how to create a branch for making your changes to the codebase, submitting these in a code review, and then merging the changes into those made by other developers.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2023-12-01

1,985 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 2: Manage Code with Red Gate SQL Source Control

In this second level of the Stairway to Database DevOps, we learn to use Redgate's SQL Source Control to save and updates changes to objects, as well as tracking data in certain tables.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2023-10-18

1,504 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps

In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(8)

You rated this post out of 5. Change rating

2023-10-16 (first published: )

3,135 reads

Blogs

Car Update September 2026

By

Software is hard. While I love our Lucid Gravity, I realize that they are...

Microsoft Tools for Making Data AI-Ready

By

Making Data AI-Ready, Part 2 (This is the second article in a three-part series...

Local Models Using GPUs with Ollama

By

Can you use your GPUs when running a local model under Ollama? You can,...

Read the latest Blogs

Forums

Alamat BCA KCP Bursa Efek Jakarta Tlp:0821°7555°651

By layanan_Bca88

Tlp/Wa 62 8217555651 Gd. Bursa Efek Jakarta, Jl. Jend. Sudirman kav 52-53 Tower II...

Alamat BCA KCP WTC Sudirman Telp:0821.8200.233

By m4rt1n4

Telp/Wa 62 8218200233 World Trade Center I, Jl. Jenderal Sudirman No.Kav. 29, RT.8/RW.3, Kuningan,...

BCA KCP Sampoerna Strategic Square Telp:08218200203

By R4nt4u

Telp/Wa 62 8218200203 Gd. Sampoerna Strategic Square, Jl. Jenderal Sudirman Tower A - Ground...

Visit the forum

Question of the Day

Reserved Words I

Which of these are not reserved words?

See possible answers