SQL Server
SQL Server is Microsoft's relational database management system for storing, querying, and managing data.
100 SQL Server Mistakes and How to Avoid Them
SQL Server is Microsoft's relational database management system for storing, managing, transforming, and analyzing data.
- How it is used
- Frames relational data hosting and management as an operational, development, availability, recovery, and security responsibility.
- How deep it goes
- Defines the platform and its components, deployment choices, and implementation risks, while deferring detailed component internals.
- Examples
- Uses MagicChoc’s website, factory applications, reporting solution, and Ubuntu-hosted Go application to compare deployment choices.
- What you can do after
- Evaluate/understand SQL Server deployment and implementation choices against workload fit, cost, security, availability, and operational support.
Read how 100 SQL Server Mistakes and How to Avoid Them explains SQL Server →
Building Web APIs with ASP.NET Core
SQL Server is Microsoft's relational database management system for storing, querying, and processing structured data.
- How it is used
- Stores the board-game API’s consistently structured data in a relational database supported by EF Core.
- How deep it goes
- Walks through edition choices, local database creation, connection settings, and login-versus-user scope; defers installation details to an appendix.
- Examples
- Uses the MyBGList database, a local SQLEXPRESS connection, and separate development and production setups.
- What you can do after
- Operate/configure it by creating an API database and its access credentials, then preparing a separate production instance.
Read how Building Web APIs with ASP.NET Core explains SQL Server →
Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and tools
SQL Server is Microsoft's relational database management system for storing, querying, and managing structured data.
- How it is used
- Deploys SQL Server as durable storage for PowerShell-collected data and automated SSRS reporting.
- How deep it goes
- Demonstrates connections, commands, table creation, queries, readers, and property translation, but does not develop database administration.
- Examples
- Uses disk-inventory objects, a diskinfo table, conditional creation, row retrieval, and translated Size and Drive properties.
- What you can do after
- Build it from scratch as PowerShell commands that store inventory objects, query rows, and feed automated reports.
Also covered in
- Practical Automation with PowerShell: Effective scripting from the console to the cloud
- Building Distributed Applications that Work
- Microsoft Azure in Action
- Pro ASP.NET Core 7, Tenth Edition
- Grokking Software ArchitectureIn early access (MEAP)
What to know first
- containerA software container is an isolated execution environment that packages an application and its dependencies, typically sharing the host operating-system kernel.
- port numberA port number is a transport-layer identifier associated with a host address that directs network traffic to a service or application endpoint.
- performancePerformance is a measure of how effectively a person, process, model, or system achieves its objectives, including qualities such as output quality, speed, and resource efficiency.
Related concepts
- relational database management systemkind of · A relational database management system is software that stores and manages data organized according to the relational model and supports operations for defining, querying, and updating that data.
- database management systemhas part · A database management system is software that defines, stores, retrieves, modifies, and manages access to data in databases.
- databasekind of · A database is an organized persistent data store, typically managed by software, that supports storing, retrieving, and modifying data.
- dbatoolsused by · dbatools is an open-source PowerShell module providing commands and tools for automating SQL Server and related database administration tasks.
- AddDistributedSqlServerCacheused by · An ASP.NET Core service-registration method that configures an IDistributedCache implementation backed by a SQL Server database.
Questions about SQL Server
What is SQL Server?
SQL Server is Microsoft's relational database management system for storing, querying, and managing data.
Which Manning books explain SQL Server?
100 SQL Server Mistakes and How to Avoid Them, Building Web APIs with ASP.NET Core and Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and tools.
What should I know before learning SQL Server?
Manning books that teach SQL Server usually introduce container, port number and performance first.
What kinds of SQL Server are there?
Kinds of SQL Server include sql server express.
What is SQL Server a kind of?
SQL Server is a kind of relational database management system. A relational database management system is software that stores and manages data organized according to the relational model and supports operations for defining, querying, and updating that data.
What are the parts of SQL Server?
SQL Server includes database management system.
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.


