Dockerized SQL Server Developer Setup

Overview

This project provides a reproducable Docker Compose Setup for Microsoft SQL Server, designed to help developers quickly spin up a local database environment. It includes sample Database AdventureWorks2022 , Performance tuning demos, and stepwise onboarding documentation.

Features

• Docker Compose Configuration for SQL Server
• Sample query to Restore database and select data (init.sql)
• Stepwise onboarding instructions for new developers
• Query Optimization Demo (Execution Plans, Indexing Strategies)
• Troubleshooting notes for common Docker/SQL Issues

Prerequisites

• Docker Desktop installed
• VS Code with YAML (Red Hat) + Docker extensions

To Get Started

1. Clone the repository:

   git clone https://github.com/nithyav2017/docker-sqlsever-dev-setup.git
   cd docker-sqlserver-dev-setup

2. Start SQL Server in Docker: docker-compose up -d
3. Connect using SSMS Server : localhost,1433 User: sa Password: passwrd
4. Connect using CLI sqlcmd -S localhost,1433 -U sa -P 'Passwrd' with DB: sqlcmd -S localhost,1433 -U sa -P 'Passwrd' -d AdventureWorks2022 -W -s"," [W : To remove traiing space ; -s",": Set result as CSV format]