Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud

Product Description

Intermediate-Advanced user level

From the Back Cover

Here is the expert-level, insider guidance you need on using Azure SQL Database as your back-end data store. This book highlights best practices in everything ranging from full-stack projects to mobile applications to critical, back-end APIs. The book provides instruction on accessing your data from any language and platform. And you learn how to push processing-intensive work into the database engine to be near the data and avoid undue networking traffic. Azure SQL is explained from a developer’s point of view, helping you master its feature set and create applications that perform well and delight users.

Core to the book is showing you how Azure SQL Database provides relational and post-relational support so that any workload can be managed with easy accessibility from any platform and any language. You will learn about features ranging from lock-free tables to columnstore indexes, and about support for data formats ranging from JSON and key-values to the nodes and edges in the graph database paradigm. Reading this book prepares you to deal with almost all data management challenges, allowing you to create lean and specialized solutions having the elasticity and scalability that are needed in the modern world. 

You will:

Master Azure SQL Database in your development projects from design to the CI/CD pipeline
Access your data from any programming language and platform
Combine key-value, JSON, and relational data in the same database
Push data-intensive compute work into the database for improved efficiency
Delight your customers by detecting and improving poorly performing queries
Enhance performance through features such as columnstore indexes and lock-free tables
Build confidence in your mastery of Azure SQL Database’s feature set

About the Author

Davide Mauri is Program Manager in the Azure SQL Database product group. He has been working in the IT field since 1997 and was awarded Data Platform MVP status for 12 consecutive years. He started his career as a full-stack and back-end developer, then focused on databases and data science for 15 years while still keeping alive his passion for development (mainly in C# and Python). He then moved to the Internet of Things (IoT) and big data space where ingesting, processing, and analyzing millions of data points in near real time was his everyday challenge. Building from that experience, he joined Microsoft to help companies worldwide to leverage stream processing at scale. He now works for Azure SQL Database as the developer’s voice inside the product group, working to make sure that Azure SQL Database is, and will be, the best database option for developers.

Silvano Coriani has worked on SQL and other data technologies more than 25 years. He started as an embedded systems developer in industrial automation and moved to data acquisition, processing, and analysis in distributed solutions. He has worked on several RDBMS engines (SQL Server 6.0 and later releases, Oracle, IBM DB2, and more recently PostgreSQL), and on NoSQL and other analytical engines such as Spark and Hadoop. He also has experience in C/C++, Visual Basic, Java, and .NET.  He has worked in several industries, including manufacturing, retail, and financial services. Since joining Microsoft in 2003, he has been busy helping ISVs and enterprise customers to learn and adopt Microsoft technologies. His experience includes being Developer Evangelist, Software Engineer in the SQL Customer Advisory Team, and most recently working in SQL Customer Success Engineering for the Azure Data team. He is also an active speaker at industry conferences such as PASS Summit and Microsoft Ignite. 

Anna Hoffman is Data & Applied Scientist on the Azure Data team at Microsoft. She has worked in Microsoft Research, AI Engineering, and Microsoft Services in her time at Microsoft. She spent several years working on .NET, Python