liveBook · Manning

SQL Server

SQL Server is Microsoft's relational database management system for storing, querying, and managing data.

How 3 Manning books explain it

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.

Read how Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and tools explains SQL Server →

Also covered in

What to know first

Related concepts

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.