SQL Server Advanced Data Types

JSON, XML, and Beyond



Bookstore > Books > SQL Server Advanced Data Types

SQL Server Advanced Data Types
Buy
Preview
Price$30.19 - $35.97
Rating
AuthorPeter A. Carter
PublisherApress
Published2018
Pages392
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484239008
ISBN-139781484239001
EBook Hardcover Paperback

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.

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.




Similar Books


Data Science with SQL Server Quick Start Guide

Data Science with SQL Server Quick Start Guide

SQL Server only started to fully support data science with its two most recent editions. If you are a professional from both worlds, SQL Server and data science, and interested in using SQL Server and Machine Learning (ML) Services for your projects, then this is the ideal book for you.This book is the ideal introduction to data science w...
SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Micros...
A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's uniqu...
Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such ...
SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high performance database applications that can improve ...
Microsoft SQL Server 2012 with Hadoop

Microsoft SQL Server 2012 with Hadoop

With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indee...