SQL Server Advanced Data Types

Author: Peter Carter
Publisher: Apress
Pages: 408
ISBN: 978-1484239001
Print: 1484239008
Kindle: B07FNCN52L
Audience: SQL developers
Rating: 4
Reviewer: Kay Ewbank

 

SQL Server now comes with support for several new data types including JSON and XML. This book explains what they are and how to use them.

The premise of the book is simple - take each of the 'advanced' data types in turn and show what they are, what they're used for, and how to do it in SQL Server. In addition to XML and JSON, the book includes coverage of spatial data types and the hierarchyID data type.

 

Banner

The book opens with a chapter on all the data types in SQL Server, including a summary of the advanced data types. Having set the scene, Peter Carter then moves on to a chapter on understanding XML in which he describes what XML is, what well-formed XML looks like, and the ways you might use XML in SQL Server. This is followed by a chapter on constructing XML with T-SQL.

XML is also the subject of the next two chapters, one on querying and shredding XML, the next on XML indexes. Shredding XML is the process of taking an XML result set and converting it to the equivalent relational result set. As with the rest of the book, this chapter is heavy on SQL code and schemas, and has tables showing the parameters and values the commands accept and expect.

Carter next moves on to the JSON aspects of advanced data, starting with a chapter on understanding JSON. He then shows how to construct JSON from T-SQL using For JSON Auto and For JSON Path. A chapter on shredding JSON data is followed by one on working with the JSON data type.

Spatial data in the form of the Geometry and Geography data types are tackled next, with a chapter on understanding spatial data followed by one on working with spatial data. The book ends with a look at hierarchical data and the HierarchyID, showing how this new type can be used instead of self joins for data sets such as an employee hierarchy. 

This is a useful book. It brings together the details of how to use the new data types, and even the fact that they exist may be news to some SQL Server developers. Carter's examples are well thought out and explained, and having all the information together makes a useful reference.

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, Facebook or Linkedin.

Banner


An Introduction to Tensors and Group Theory for Physicists

Author:  Nadir Jeevanjee 
Publisher: Birkhäuser
Pages: 305
ISBN: 978-3319147932
Print: 3319147935
Kindle: B00F5QF7G6
Audience: Physics and Maths Graduates
Rating: 4
Reviewer: Mike James

Both tensors and groups are at the foundation of modern physics and many asp [ ... ]



Jupyter Cookbook

Author: Dan Toomey
Publisher: Packt
Pages: 238
ISBN: 978-1788839440
Print: 1788839447
Kindle: B07CDQT8VQ
Audience: developers in data science
Rating: 3.5
Reviewer: Kay Ewbank

This is a collection of 75 recipes for Jupyter used with Python, R, Scala, Spark and JavaScript that aims to take developers from  [ ... ]


More Reviews

 

Last Updated ( Saturday, 16 March 2019 )