Picture 1 of 1
Picture 1 of 1
XML and JSON Recipes for SQL Server: A Problem-Soluti on Approach
US $41.38
ApproximatelyRM 174.00
or Best Offer
Condition:
Good
A book that has been read but is in good condition. Very minimal damage to the cover including scuff marks, but no holes or tears. The dust jacket for hard covers may not be included. Binding has minimal wear. The majority of pages are undamaged with minimal creasing or tearing, minimal pencil underlining of text, no highlighting of text, no writing in margins. No missing pages.
Postage:
Free USPS Media MailTM.
Located in: San Diego, California, United States
Delivery:
Estimated between Sat, 28 Sep and Thu, 3 Oct to 43230
Returns:
30 days return. Buyer pays for return shipping.
Coverage:
Read item description or contact seller for details. See all detailsSee all details on coverage
(Not eligible for eBay purchase protection programmes)
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:326100672558
Item specifics
- Condition
- Release Year
- 2017
- Book Title
- XML and JSON Recipes for SQL Server: A Problem-Solution Approach
- ISBN
- 9781484231166
- Subject Area
- Computers
- Publication Name
- Xml and Json Recipes for Sql Server : a Problem-Solution Approach
- Publisher
- Apress L. P.
- Item Length
- 9.3 in
- Subject
- Programming Languages / Xml, Databases / General, Programming / Microsoft
- Publication Year
- 2017
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Weight
- 17.1 Oz
- Item Width
- 6.1 in
- Number of Pages
- Xxiii, 289 Pages
About this product
Product Identifiers
Publisher
Apress L. P.
ISBN-10
1484231163
ISBN-13
9781484231166
eBay Product ID (ePID)
240103093
Product Key Features
Number of Pages
Xxiii, 289 Pages
Publication Name
Xml and Json Recipes for Sql Server : a Problem-Solution Approach
Language
English
Subject
Programming Languages / Xml, Databases / General, Programming / Microsoft
Publication Year
2017
Type
Textbook
Subject Area
Computers
Format
Trade Paperback
Dimensions
Item Weight
17.1 Oz
Item Length
9.3 in
Item Width
6.1 in
Additional Product Features
Number of Volumes
1 vol.
Illustrated
Yes
Table Of Content
Part I: XML in SQL Server.- 1. Introducing XML.- 2. Building XML.- 3. Manipulating XML Files.- 4. Shredding XML.- 5. Modifying XML.- 6. Filtering XML.- 7. Improving XML Performance.- Part II: JSON in SQL Server.- 8. Constructing JSON.- 9. Converting JSON to Row Sets.- 10. Modifying JSON.
Synopsis
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., 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., Quick-reference guide that allows you to look up the problem you want to solve and rapidly find and implement the solution Covers JSON features, including how to build JSON from query result sets Covers XML features such as parsing, loading, and more Provides many step-by-step examples that you can adapt to your needs
LC Classification Number
QA76.9.D3
Item description from the seller
Popular categories from this store
Seller feedback (12,361)
- o***f (432)- Feedback left by buyer.Past monthVerified purchaseGreat job.
- a***l (477)- Feedback left by buyer.Past monthVerified purchaseIt’s what I needed and in really good condition. Perfect!
- a***a (128)- Feedback left by buyer.Past monthVerified purchaseHad to return item as it was a single book not the set. The seller accepted the return without issue and I would buy from them again.
More to explore :
- Cookbooks Nonfiction Books Fiction & Classic Recipes,
- Adults Fiction Books & Nonfiction Classic Recipes,
- Hardcover Nonfiction Classic Recipes Books,
- Nonfiction Books in English Fiction & Classic Recipes,
- Nonfiction Books Illustrated Fiction & Classic Recipes,
- Classic Recipes Paperback Fiction & Nonfiction Books,
- Food & Drink Nonfiction Books Fiction & Classic Recipes,
- Nonfiction Books & Fiction HarperCollins Classic Recipes,
- Nonfiction Books & Fiction Classic Recipes 1950-1999 Publication Year