XML and JSON Recipes for SQL Server : A Problem-Solution Approach / by Alex Grinberg, Anna Landy.

Format:

Book

Author/Creator:

Grinberg, Alex.

Series:

Professional and Applied Computing Series

Language:

English

Subjects (All):

Database management.

Artificial intelligence--Data processing.

Artificial intelligence.

Information storage and retrieval systems.

Microsoft software.

Microsoft .NET Framework.

Electronic data processing--Management.

Electronic data processing.

Computer programming.

Database Management System.

Data Science.

Information Storage and Retrieval.

Microsoft.

IT Operations.

Programming Techniques.

Local Subjects:

Database Management System.

Data Science.

Information Storage and Retrieval.

Microsoft.

IT Operations.

Programming Techniques.

Physical Description:

1 online resource (332 pages)

Edition:

2nd ed. 2026.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2026.

Summary:

This second edition of XML and JSON Recipes for SQL Server expands the original with new recipes, including a dedicated section on FLWOR (For-Let-Where-Order By-Return) syntax for advanced XML querying. It also covers SQL Server's JSON data type introduced in SQL Server 2025 and the latest JSON functions added in SQL Server 2022, making it easier to build, query, and optimize structured data in modern SQL Server environments A new chapter explores how XML and JSON are used in SQL Server system processes, including DDL triggers, Extended Events, execution plan parsing, and SSIS code-behind, helping you automate diagnostics and streamline development workflows. Whether you are building automation scripts, integrating with front-end applications, or managing cross-platform data exchange, this book provides practical, ready-to-use solutions. Recipes are presented in a proven problem-solution format: look up the problem, read the solution, and apply it in your own code. Problem solved. What You Will Learn Build XML and JSON objects to support automation, integration, and data transfer. Import and parse XML and JSON from operating system files and external sources. Construct and optimize indexes on XML data to improve query performance. Convert query result sets into JSON format and return them to tabular form. Automate performance diagnostics by querying and parsing execution plans in XML. Replace manual JSON workflows with SQL Server's built-in JSON functions. Use FLWOR syntax for advanced XML filtering and transformation. Work with the JSON data type introduced in SQL Server 2025. Apply new JSON functions added in SQL Server 2022 for efficient data handling. Parse and analyze Extended Events, SSIS code-behind, and DDL triggers using XML and JSON. Leverage XML and JSON in SQL Server system processes for automation and monitoring.

Contents:

Part I

XML in SQL Server

1. Introducing XML

2. Building XML

3. Manipulating XML Files

4. Shredding XML

5. Modifying XML

6. Filtering XML

7. Improving XML Performance

8. FLWOR Statements

Part II

JSON in SQL Server

9. Constructing JSON

10. Converting JSON to Row Sets

11. Modifying JSON

12. XML and JSON with SQL Server System Processes.

Notes:

Print version record.

ISBN:

9798868828034