XML and JSON Recipes for SQL Server: A Problem-Solution Approach
暫譯: SQL Server 的 XML 與 JSON 食譜：問題解決方法

Alex Grinberg

XML and JSON Recipes for SQL Server: A Problem-Solution Approach
  • 出版商: Apress
  • 出版日期: 2017-12-19
  • 定價: $1,980
  • 售價: 8.0 折 $1,584
  • 語言: 英文
  • 頁數: 289
  • 裝訂: Paperback
  • ISBN: 1484231163
  • ISBN-13: 9781484231166
  • 相關分類: JavaScript、MSSQL、SQL、XML

    • 立即出貨 (庫存 < 3)

買這商品的人也買了...

商品描述

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. 

商品描述(中文翻譯)

快速找到在使用 SQL Server 內建的 XML 和 JSON 功能時遇到的數十個常見問題的解決方案。內容以流行的問題-解決方案格式呈現。查找您想解決的問題。閱讀解決方案。直接在自己的代碼中應用解決方案。問題解決！

本書展示了如何利用 XML 和 JSON 來共享數據和自動化任務。JSON 通常用於在數據庫和前端應用程序之間來回移動數據，這些應用程序通常在瀏覽器中運行。本書涵蓋了您需要了解的所有有關將查詢結果轉換為 JSON 格式及其反向轉換的知識。此外，還介紹了將數據進出 XML 格式的過程和技術，這對於商業智能和其他目的非常重要，例如在將數據從報告系統轉移到數據倉庫，或在不同數據庫品牌之間轉移數據（例如 SQL Server 和 Oracle 之間）。

微軟在 SQL Server 及許多相關產品中廣泛實施 XML。執行計劃以 XML 格式生成，本書將向您展示如何解析這些計劃並自動檢測性能問題。相對較新的擴展事件（Extended Events）功能將追蹤數據寫入 XML 文件，本書中的配方有助於解析這些文件。

XML 也用於 SQL Server 的商業智能工具集，包括 SSIS、SSR 和 SSAS。XML 用於許多配置文件，甚至在 DDL 觸發器的構建中也有應用。在閱讀本書時，您將深入了解構建和解析 XML 以及 JSON 的功能，JSON 是一種特定格式的 XML，用於在數據庫和其前端應用程序之間以網頁友好的格式傳輸對象。

**您將學到什麼**

- 構建 XML 和 JSON 對象以支持自動化和數據傳輸
- 從操作系統文件中導入和解析 XML 和 JSON
- 在 XML 對象上構建適當的索引以改善查詢性能
- 將查詢結果集中的數據轉換為 JSON 格式，並反向轉換
- 通過查詢和解析數據庫自身的執行計劃自動檢測數據庫性能問題
- 用 SQL Server 的內部 JSON 功能替代外部和手動的 JSON 處理過程

**本書適合誰**

數據庫管理員、.NET 開發人員、商業智能開發人員以及希望在 SQL Server 數據庫環境中深入了解 XML 和 JSON 的其他專業人士。網頁開發人員將特別發現本書對於將數據庫結果集轉換為可傳輸到前端網頁應用程序的 JSON 文本的涵蓋內容非常有用。

類似商品