What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system. It stores data in tables of rows and columns, enforces a defined schema, and is queried with T-SQL. It is a mature, transactional database known for strong consistency, stored procedures, and tight integration with the Microsoft ecosystem.
SQL Server is the natural data store for .NET applications. Platforms such as nopCommerce rely on it for their persistent data, so a host that runs a .NET workload typically needs SQL Server available alongside it.
On TurboStack
TurboStack provisions Microsoft SQL Server as a host-level service for .NET workloads that require it. You specify the version (and edition) you want, and TurboStack installs and configures the engine so your application can connect to it.
-
Version and edition pinned. You declare the SQL Server version and edition explicitly, so the engine your application targets stays predictable across deployments.
-
For .NET workloads. Enable it on hosts running .NET applications such as nopCommerce that store their data in SQL Server.
-
Managed for you. TurboStack handles provisioning and configuration of the service.
Note
Choose the edition that matches your licensing and feature needs. Different editions differ in capabilities and resource limits.
Best practices
- Pin a specific version and edition and keep it consistent across your environments.
- Use a dedicated, least-privilege database login for each application.
- Index the columns your application filters and joins on most often.
- Back up regularly and test restoring before you need to.
- Keep the database reachable only from the application that needs it.