SQL Server Advanced Data Types

JSON, XML, and Beyond

Nonfiction, Computers, Database Management, General Computing
Cover of the book SQL Server Advanced Data Types by Peter A. Carter, Apress
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Peter A. Carter ISBN: 9781484239018
Publisher: Apress Publication: August 23, 2018
Imprint: Apress Language: English
Author: Peter A. Carter
ISBN: 9781484239018
Publisher: Apress
Publication: August 23, 2018
Imprint: Apress
Language: English

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

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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

Who This Book Is For

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

More books from Apress

Cover of the book iOS 7 Development Recipes by Peter A. Carter
Cover of the book Securing the Perimeter by Peter A. Carter
Cover of the book Beginning Big Data with Power BI and Excel 2013 by Peter A. Carter
Cover of the book Java EE 7 Recipes by Peter A. Carter
Cover of the book Blockchain Enabled Applications by Peter A. Carter
Cover of the book Requirements Writing for System Engineering by Peter A. Carter
Cover of the book Expert T-SQL Window Functions in SQL Server by Peter A. Carter
Cover of the book Business Journalism by Peter A. Carter
Cover of the book Getting the Message Across by Peter A. Carter
Cover of the book Advanced R Statistical Programming and Data Models by Peter A. Carter
Cover of the book Swift OS X Programming for Absolute Beginners by Peter A. Carter
Cover of the book Visual Studio Lightswitch 2012 by Peter A. Carter
Cover of the book From Hacking to Report Writing by Peter A. Carter
Cover of the book Windows Installation and Update Troubleshooting by Peter A. Carter
Cover of the book Beginning LEGO MINDSTORMS EV3 by Peter A. Carter
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy