Поиск  
Always will be ready notify the world about expectations as easy as possible: job change page
Книги для разработчиков

XML and JSON Recipes for SQL Server

XML and JSON Recipes for SQL Server

Автор:
Год:
Страниц:
303
Просмотров:
1754

Описание

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved!

This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle.

Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files.

XML is also used in SQL Server's BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you’ll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications.

What You Will Learn

- Build XML and JSON objects in support of automation and data transfer
- Import and parse XML and JSON from operating system files
- Build appropriate indexes on XML objects to improve query performance
- Move data from query result sets into JSON format, and back again
- Automate the detection of database performance problems by querying and parsing the database’s own execution plans
- Replace external and manual JSON processes with SQL Server's internal, JSON functionality

Who This Book Is For

Database administrators, .NET developers, business intelligence developers, and other professionals who want a deep and detailed skill set around working with XML and JSON in a SQL Server database environment. Web developers will particularly find the book useful for its coverage of transforming database result sets into JSON text that can be transmitted to front-end web applications.

Похожее
NoSQL DISTILLED. A Brief Guide to the Emerging World of Polyglot Persistence
Автор: Martin Fowler, Pramod J. Sadalage
Год: 2013
Необходимость обрабатывать все более крупные объемы данных является одним из факторов, влияющих на внедрение нового класса нереляционных баз данных NoSQL. Сторонники баз NoSQL утверждают, что их можно использовать для создания более производительных, легче масштабируемых и проще программируемых систем.В этой книге...
Apps and Services with .NET 7
Автор: Mark J. Price
Год: 2022
Bestselling author Mark Price is back to guide you through the coolest and most common technologies a .NET developer should know: Blazor, .NET MAUI, gRPC, GraphQL, SQL Server, Cosmos DB, OData, SignalR, Azure Functions, and more!Key Features ...
PostgreSQL Server Programming, Second Edition
Автор: Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal
Год: 2015
This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and...
PostgreSQL High Availability Cookbook, Second Edition
Автор: Shaun M. Thomas
Год: 2017
Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL. Databases are nothing without the data they store. In the event of a failure – catastrophic or otherwise – immediate recovery is...
Написать сообщение
Тип
Почта
Имя
*Сообщение
RSS
Если вам понравился этот сайт и вы хотите меня поддержать, вы можете
Soft skills: 18 самых важных навыков, которыми должен владеть каждый работник
Стили именования переменных и функций. Используйте их все
10 историй, как «валят» айтишников на технических интервью
Функции и хранимые процедуры в PostgreSQL: зачем нужны и как применять в реальных примерах
Семь итераций наивности или как я полтора года свою дебютную игру писал
Вопросы с собеседований, которые означают не то, что вы думаете
Путеводитель по репликации баз данных
5 приемов увеличения продуктивности разработчика
Топ 8 лучших ресурсов для практики программирования в 2018
Использование SQLite в .NET приложениях
LinkedIn: Sergey Drozdov
Boosty
Donate to support the project
GitHub account
GitHub profile