BeginnerFree
Small Business SQL Express
A free production-ready setup for small applications with minimal data footprint.
Recommended Edition
SQL Server Express
Version
2022
Best For
Small production apps with <10GB data
Required Components
- SQL Server Express Engine
- SSMS
Optional Add-ons
- Express with Advanced Services
Hardware / Cloud Recommendations
- 4GB RAM
- Adequate SSD storage (Max 10GB DB size)
Licensing Notes
Free for production use. 10GB database size limit. Max 1 Socket/4 Cores, 1GB RAM per instance.
Backup Recommendation
Scheduled PowerShell or batch scripts (SQL Agent not included).
Monitoring Recommendation
Basic DMV queries.
SQLDevDBA's Take
Express is often underrated. For the right workload it's completely free and production-ready. Just plan your capacity carefully around the 10GB database size limit before you commit.
Startup Checklist
- Download SQL Server installer from Microsoft (microsoft.com/sql-server/downloads)
- Install the SQL Server Database Engine
- Create a DBAAdmin database to house admin and maintenance scripts
- Enable the Dedicated Admin Connection (DAC) via sp_configure
- Configure and validate automated backup jobs
Security Checklist
- Strong passwords on all SQL logins
- Restrict network access to trusted IPs only
- Regular patching with Cumulative Updates
- Disable or deny the SA (System Administrator) login
- Configure Windows Firewall rules for SQL Server (TCP 1433)
Additional (Optional) Checklist
- Install dbatools PowerShell module (dbatools.io) for automation and migrations
- Install Brent Ozar's First Responder Kit (sp_Blitz, sp_BlitzFirst, sp_BlitzIndex)
- Install Adam Machanic's sp_WhoIsActive for real-time active session monitoring
- Install Erik Darling's performance scripts (sp_PressureDetector, sp_HumanEvents)
- Install Ola Hallengren's Maintenance Solution for backups, integrity checks, and index maintenance
Architecture Diagram
Available in the Pro tier. Visual diagrams for every setup.