SQL Server instance
A SQL Server instance is an independently configured and running installation of SQL Server that hosts databases, provides database services, and accepts connections.
100 SQL Server Mistakes and How to Avoid Them
A SQL Server instance is a running installation of SQL Server that provides database services and contains databases and associated server-level configuration.
- How it is used
- Guides planning, installing, naming, and operating SQL Server instances across physical, virtualized, containerized, and cloud environments.
- How deep it goes
- Explains naming risks and deployment trade-offs through scenarios and recommendations, but stops short of detailed instance administration procedures.
- Examples
- Uses MagicChoc application-aligned names and later consolidation to demonstrate how instance naming creates operational confusion.
- What you can do after
- Evaluate and plan instance deployments by selecting durable names, required features, suitable environments, and appropriate SQL Server editions.
Read how 100 SQL Server Mistakes and How to Avoid Them explains SQL Server instance →
Building Web APIs with ASP.NET Core
A SQL Server instance is an independently configured and running installation of the SQL Server database engine.
- How it is used
- Supports connecting a web API to a locally hosted SQL Server database.
- How deep it goes
- Explains connection settings, database creation, and login-user scope, but stops short of detailed server administration.
- Examples
- Uses a local SQLEXPRESS instance, the MyBGList database, and SSMS configuration dialogs.
- What you can do after
- Operate/configure a local SQL Server instance and create a database with scoped API credentials.
Read how Building Web APIs with ASP.NET Core explains SQL Server instance →
Related concepts
- SQL loginhas part · A SQL login is a server-level security principal that authenticates a user or process to a SQL Server instance.
- security hardeningconfigured by · Security hardening is the practice of reducing a system’s vulnerabilities and attack surface through secure configuration, protective controls, and removal of unnecessary functionality.
- configuration managementconfigured by · Configuration management is the systematic definition, control, tracking, and application of software and infrastructure settings to maintain specified states throughout their lifecycles.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.