XML and JSON Recipes for SQL Server

A Problem-Solution Approach



Bookstore > Books > XML and JSON Recipes for SQL Server

Price$30.71 - $44.51
Rating
AuthorAlex Grinberg
PublisherApress
Published2017
Pages289
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484231163
ISBN-139781484231166
EBook Hardcover Paperback

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.




5 5 2

Similar Books


Linux and Solaris Recipes for Oracle DBAs, 2nd Edition

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition

by Darl Kuhn, Charles Kim, Bernard Lopuz

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example-based book on managing Oracle Database under Linux and Solaris. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operating-system documentation. What this book provides instead is task-or...

Price:  $42.49  |  Publisher:  Apress  |  Release:  2015

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

by Andy Leonard

Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS ...

Price:  $34.99  |  Publisher:  Apress  |  Release:  2021

SQL Server Advanced Data Types

SQL Server Advanced Data Types

by Peter A. Carter

Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development cos...

Price:  $28.60  |  Publisher:  Apress  |  Release:  2018

SQL Server Execution Plans, 3rd Edition

SQL Server Execution Plans, 3rd Edition

by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the informati...

Free ebook  |  Publisher:  Self-publishing  |  Release:  2018

Microsoft SQL Server 2008 Management and Administration

Microsoft SQL Server 2008 Management and Administration

by Ross Mistry, Hilary Cotter

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's f...

Price:  $9.87  |  Publisher:  SAMS Publishing  |  Release:  2008

Expert SQL Server Transactions and Locking

Expert SQL Server Transactions and Locking

by Dmitri Korotkevitch

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you devel...

Price:  $24.23  |  Publisher:  Apress  |  Release:  2018

Microsoft SQL Server 2008 High Availability

Microsoft SQL Server 2008 High Availability

by Hemantgiri S. Goswami

Install various SQL Server High Availability options in a step-by-step manner. A guide to SQL Server High Availability for DBA aspirants, proficient developers and system administrators. Learn the pre and post installation concepts and common issues you come across while working on SQL Server High Availability. Tips to enhance performance...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2011

Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

by Satya Shyam K Jayanty

Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2011