Modern Software Engineering

VW08 How to Choose Your Local Database Development Setup


9:30am - 10:45am

Level: Intermediate

Drew Skwiers-Koballa

Senior Program Manager


Erin Stellato

Senior Program Manager


As a developer using SQL you have a nearly overwhelming range of options for your local development environment. The efficiency of your inner development loop is equally important to your productivity and happiness, and in this session we'll walk through four different methods for setting up and maintaining your development database. You’ll learn which factors to consider as you choose your local database development setup, including when a full SQL Server installation (developer edition) is the right choice and how to get the most out of containers for SQL development.

You will learn:

  • The benefits of installing SQL Server developer edition locally
  • How to use non-standard ports and persistent storage with containers
  • How to quickly move database objects from one environment to another