XML and JSON Recipes for SQL Server (Paperback)
Language: English
Published by APress, Berkley, 2026
- Softcover
- New
Seller: Grand Eagle Retail, Bensenville, IL, U.S.A.Grand Eagle Retail
AbeBooks seller since October 12, 2005
Condition: New
US$ 46.68
Quantity: 1 available
Add to basketItem description from seller
Paperback. Quickly find solutions to common problems when working with XML and JSON in SQL Server, now updated for SQL Server 2022 and 2025.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 environmentsA 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 LearnBuild 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.Who This Book Is ForDatabase administrators, .NET developers, business intelligence developers, and other data professionals who need a deep, practical skill set for working with XML and JSON in SQL Server. Also useful for web developers who need to transform database result sets into JSON for front-end applications and for teams managing automation, integration, and cross-platform data exchange. This item is printed on demand. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.…
Seller Inventory # 9798868828027
- Title
- XML and JSON Recipes for SQL Server (Paperback)
- Author
- Alex Grinberg
- Publisher
- APress, Berkley
- Publication year
- 2026
- Condition
- new
- Binding
- Paperback
- Language
- English
- ISBN 13
- 9798868828027
- Edition
- 2nd Edition
Quickly find solutions to common problems when working with XML and JSON in SQL Server, now updated for SQL Server 2022 and 2025.
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.
- 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.
"Synopsis" may belong to another edition of this title.
About the Author
Alex Grinberg has more than 25 years of experience in SQL Server development, administration, and optimization. He specializes in Microsoft technologies, including SQL Server, .NET, SSRS, and SSIS, and provides tuning, analysis, and modernization services for enterprise data systems. Alex is the founder of Hexaart LLC, where he supports clients with advanced SQL solutions, application migration, and on-site training. He is based in the greater Philadelphia area and consults across New York, Philadelphia, and Delaware
Anna Landy is a SQL and business intelligence professional with experience spanning hands-on engineering and data-driven product strategy. She focuses on translating complex business requirements into practical technical solutions and has led projects across analytics, data integration, and SQL development. Anna holds a master's degree in business management from Harvard University and serves on the board of the Philadelphia SQL Server Users Group, supporting community learning and professional development.
"About the title" may belong to another edition of this title.
Grand Eagle Retail
Bensenville, IL, U.S.A.
AbeBooks seller since October 12, 2005
Shipping rates within U.S.A.
| Item | 6 to 14 business days | 6 to 16 business days |
|---|---|---|
| First item | US$ 0.00 | US$ 0.00 |
Payment methods
Seller's business information
APOLLO ONLINE CORP.
605 Geddes Street
Wilmington, DE U.S.A. 19805
Terms of sale
We guarantee the condition of every book as it¿s described on the Abebooks web sites. If you¿ve changed
your mind about a book that you¿ve ordered, please use the Ask bookseller a question link to contact us
and we¿ll respond within 2 business days.
Books ship from California and Michigan.
Shipping terms
Orders usually ship within 2 business days. All books within the US ship free of charge. Delivery is 4-14 business days anywhere in the United States.
Books ship from California and Michigan.
If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.