Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL Server Advanced Data Types: JSON, XML, and Beyond

Buy

SQL Server Advanced Data Types attempts to demystify the complex data types that are available to developers in modern versions of SQL Server. Over the last couple of years, I have noticed that many SQL developers have heard of each of the complex data types available in SQL Server but often avoid using them, as they are not sure how these are best utilized. This has led to suboptimal solutions being developed, such as an incident that I recently experienced in which a very good and seasoned SQL developer implemented complex hierarchical logic using self joins, because he did not feel confident implementing the HierarchyID data type.

That inspired me to write this book—to help SQL and other developers responsible for writing T-SQL, as part of their applications, to better understand the complex data types available in SQL Server and give them the confidence to use these complex structures appropriately.

The book starts by exploring the simple, conventional data types that are available in SQL Server and reminds readers why making the right choices about data types can be so important. The book then moves on to offer in-depth discussions about the complex data types in SQL Server, namely, XML, JSON, HierarchyID, GEOGRAPHY, and GEOMETRY. Many of the code examples in the book are based on real-world problems and solutions that I have encountered in my time as an SQL Server consultant in London.

(HTML tags aren't allowed.)

Securing SQL Server: DBAs Defending the Database
Securing SQL Server: DBAs Defending the Database
Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and countermeasures, and provides an introduction to compliance that is useful for meeting regulatory requirements such as the GDPR. The...
Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques
Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques
As database administrators, our primary duty is to protect the data in the databases we are responsible for. This data represents the heart and soul of the company employing us, and could destroy a business if not maintained properly. In this context, the proper application of a sound backup and restore solution is absolutely...
Professional SQL Server High Availability and Disaster Recovery: Implement tried-and-true high availability and disaster recovery solutions with SQL Server
Professional SQL Server High Availability and Disaster Recovery: Implement tried-and-true high availability and disaster recovery solutions with SQL Server

Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable network of systems.

Key Features

  • Explore more than 20 real-world use cases to understand SQL Server features
  • Get to grips with the SQL Server Always On...

SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

...

Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners
Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners
Some time ago, one of my colleagues asked me, “What do you like about SQL Server the most?” I had heard this question many times before, and so I provided my usual answer: “SQL Server Internals. I like to understand how the product works and solve complex problems with this knowledge.”

His
...
Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server
Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy