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

Blogs

Common Mistakes in SQL Server – Part 2

By

The  Identity property creates an incremental value for the specified column automatically, which is...

Enable PowerShell Remoting

By

Enable PowerShell Remoting I use PowerShell quite a lot...

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

Read the latest Blogs

Forums

Restore With Standby; A Review and A Lesson Learned

By Andy Warren

Comments posted to this topic are about the item Restore With Standby; A Review...

Are You Worried About AI?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Worried About AI?

The Upgraded Procedure part 2

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Upgraded Procedure part 2

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers