SQL Server Advanced Data Types

Tagline: Taking full advantage of SQL Server's ever-growing support for modern data

Microsoft has been steadily adding support for advanced data types into their database engine, and many developers and database administrators are not fully aware of what these new types can provide in the way of optimization and speeding development time. This book introduces readers to the growing amount of support within SQL Server for operations and data transformations that until now required third-party software and all the associated licensing and development costs. Readers 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.

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

Auteur
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.

Contenu
Chapter 1. SQL Server Data Types Chapter 2. Understanding XML Chapter 3. Constructing XML with T-SQL Chapter 4. Querying and Shredding XML
Chapter 5. XML Indexes
Chapter 6. Understanding JSON
Chapter 7. Constructing JSON from T-SQL
Chapter 8. Shredding JSON Data
Chapter 9. Working with the JSON Data Type
Chapter 10. Understanding Spatial Data
Chapter 11. Working with Spatial Data
Chapter 12. Working with Hierarchical Data with HierarchyID