Don’t miss it—Apress Access is only $99 for the holiday season! Subscribe now >>

SQL Server Advanced Data Types

JSON, XML, and Beyond

Authors: Carter, Peter A.

Download source code
  • Shows how non-relational data types can transform the way you store and interact with business critical data
  • Introduces the growing amount of support within SQL Server for operations and data transformations that until now required third-party software and the associated licensing and development costs
  • Presents what can be done inside the database engine with no additional costs or development time invested in outside software
see more benefits

Buy this book

eBook $29.99
price for USA (gross)
  • ISBN 978-1-4842-3901-8
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $37.99
price for USA
  • ISBN 978-1-4842-3900-1
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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 costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software.
Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. 

SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently.
The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes.

What You'll Learn

  • Understand the implementation of basic data types and why using the correct type is so important
  • Work with XML data through the XML data type
  • Construct XML data from relational result sets
  • Store and manipulate JSON data using the JSON data type
  • Model and analyze spatial data for geographic information systems
  • Define hierarchies and query them efficiently through the HierarchyID type
Who This Book Is For

SQL Server developers and application developers who need to store and access complex data structures

About the authors

​Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011. He has MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation.

Table of contents (12 chapters)

Buy this book

eBook $29.99
price for USA (gross)
  • ISBN 978-1-4842-3901-8
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $37.99
price for USA
  • ISBN 978-1-4842-3900-1
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
SQL Server Advanced Data Types
Book Subtitle
JSON, XML, and Beyond
Authors
Copyright
2018
Publisher
Apress
Copyright Holder
Peter A. Carter
eBook ISBN
978-1-4842-3901-8
DOI
10.1007/978-1-4842-3901-8
Softcover ISBN
978-1-4842-3900-1
Edition Number
1
Number of Pages
XV, 392
Number of Illustrations
103 b/w illustrations
Topics