XML and JSON Recipes for SQL Server
A Problem-Solution Approach
| Price | $30.71 - $44.51
|
| Rating |  |
| Author | Alex Grinberg |
| Publisher | Apress |
| Published | 2017 |
| Pages | 289 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484231163 |
| ISBN-13 | 9781484231166 |
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.
- Alex Grinberg
5 5 2
Similar Books
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
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
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
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 
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
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
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
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