SQL Server
SQL Server is Microsoft's relational database management system for storing, querying, transforming, and managing structured 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.
Related concepts
- relational database management systemkind of · A relational database management system is software that stores and manages data organized as relations, typically represented as tables, and supports querying and updating that data.
- database management toolhas part · A database management system is software that defines, stores, retrieves, modifies, and administers database data and controls access to it.
- databasekind of · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- dbatoolsused by · dbatools is an open-source PowerShell module providing commands and tools for automating SQL Server and related database administration tasks.
- Aspire.Hosting.SqlServerused by · Aspire.Hosting.SqlServer is a .NET Aspire hosting integration package for provisioning and configuring SQL Server resources.
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.