How deeply does Building Web APIs with ASP.NET Core cover SQL Server instance?

Explains connection settings, database creation, and login-user scope, but stops short of detailed server administration.

SQL Server instance

As explained in Building Web APIs with ASP.NET Core

A SQL Server instance is an independently configured and running installation of the SQL Server database engine.

A SQL Server instance is an independently configured and running SQL Server database engine installation. SSMS connects to a local instance through a server name such as <MACHINENAME>\SQLEXPRESS or .\SQLEXPRESS. section 4.2.4

Configure a local instance for the MyBGList API by:

Opening SSMS and selecting Database engine as the server type. section 4.2.4
Choosing Windows authentication or SQL Server authentication, according to the installation mode. section 4.2.4
Creating the MyBGList database from the Databases folder while retaining the default settings. section 4.2.4
Creating an instance-wide login and a database-specific user before placing credentials in the API connection string. section 4.2.4

How Building Web APIs with ASP.NET Core covers it

Cover of Building Web APIs with ASP.NET Core

liveBook manning.com

Read Building Web APIs with ASP.NET Core on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

100 SQL Server Mistakes and How to Avoid ThemA SQL Server instance is a running installation of SQL Server that provides database services and contains databases and associated server-level configuration.

Compare how 2 books explain 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.

This explainer was generated by Manning's knowledge graph from the text of Building Web APIs with ASP.NET Core. The section links point to the parts of the book it draws on.