{"product_id":"xml-and-json-recipes-for-sql-server-von-alex-grinberg-und-anna-landy","title":"XML and JSON Recipes for SQL Server","description":"\n                                \n                \n                \u003cp\u003e\n                                        \n                    \u003cstrong\u003eQuickly find solutions to common problems when working with XML and JSON in SQL Server, now updated for SQL Server 2022 and 2025.\u003c\/strong\u003e\n                                    \n                \u003c\/p\u003e\n                                \n                \n                \u003cp\u003eThis 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\u003c\/p\u003e\n                                \n                \n                \u003cp\u003eA 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.\u003c\/p\u003e\n                                \n                \n                \u003cp\u003eRecipes are presented in a proven problem-solution format: look up the problem, read the solution, and apply it in your own code. Problem solved.\u003c\/p\u003e\n                                \n                \n                \u003cstrong\u003eWhat You Will Learn\u003c\/strong\u003e\n                                \n                \n                \u003cul\u003e\n                                        \n                    \n                    \u003cli\u003eBuild XML and JSON objects to support automation, integration, and data transfer.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eImport and parse XML and JSON from operating system files and external sources.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eConstruct and optimize indexes on XML data to improve query performance.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eConvert query result sets into JSON format and return them to tabular form.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eAutomate performance diagnostics by querying and parsing execution plans in XML.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eReplace manual JSON workflows with SQL Server's built-in JSON functions.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eUse FLWOR syntax for advanced XML filtering and transformation.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eWork with the JSON data type introduced in SQL Server 2025.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eApply new JSON functions added in SQL Server 2022 for efficient data handling.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eParse and analyze Extended Events, SSIS code-behind, and DDL triggers using XML and JSON.\u003c\/li\u003e\n                                        \n                    \n                    \u003cli\u003eLeverage XML and JSON in SQL Server system processes for automation and monitoring.\u003c\/li\u003e\n                                        \n                \n                \u003c\/ul\u003e\n                                \n                \n                \u003cstrong\u003eWho This Book Is For\u003c\/strong\u003e\n                                Database 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.\n\n            \n            \u003cdiv class=\"aw-variant-hidden-subtitle-div\" id=\"aw-variant-subtitle-9798868828027\"\u003e\u003ch3\u003eA Problem-Solution Approach\u003c\/h3\u003e\u003c\/div\u003e","brand":"Autorenwelt Shop","offers":[{"title":"Softcover - 9798868828027","offer_id":57517688914245,"sku":"9798868828027","price":53.49,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0940\/0622\/files\/361e48fe-0761-49f8-a768-9daa99e0d870.jpg?v=1780467344","url":"https:\/\/shop.autorenwelt.de\/en\/products\/xml-and-json-recipes-for-sql-server-von-alex-grinberg-und-anna-landy","provider":"Autorenwelt Shop","version":"1.0","type":"link"}