Skip to main content

Introducing new learning courses and educational videos from Apress. Start watching

Book cover
  • Book
  • © 2021

Practical Azure SQL Database for Modern Developers

Building Applications in the Microsoft Cloud

Apress

Authors:

  1. Davide Mauri

    1. Redmond, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Silvano Coriani

    1. Legnano, Italy

    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Anna Hoffman

    1. Sherman Oaks, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  4. Sanjay Mishra

    1. Redmond, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  5. Jovan Popovic

    1. Belgrade, Serbia

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Helps you take advantage of relational and post-relational features in Azure SQL Database

  • Shows you how to use Azure SQL Database features to make better, simpler, faster applications and APIs

  • Follows a pragmatic approach focusing on what to do, how to do it, and why to do it

  • Discusses databases from a developer's perspective and especially on ways to get things done properly and efficiently

Sections

eBook USD 29.99
Price excludes VAT (USA)
  • ISBN: 978-1-4842-6370-9
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book USD 39.99
Price excludes VAT (USA)
Learn about institutional subscriptions

This is a preview of subscription content, access via your institution.

Table of contents (11 chapters)

  1. Front Matter

    Pages i-xxv
    PDF

  2. A Database for the Modern Developer

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 1-13

  3. Azure SQL Kickstart

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 15-34

  4. Connecting and Querying Azure SQL

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 35-68

  5. Developing with Azure SQL – Foundations

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 69-103

  6. Developing with Azure SQL – Advanced

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 105-132

  7. Practical Use of Tables and Indexes

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 133-157

  8. Scalability, Consistency, and Performance

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 159-191

  9. Multi-model Capabilities

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 193-233

  10. More Than Tables

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 235-265

  11. Monitoring and Debugging

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 267-300

  12. DevOps with Azure SQL

    • Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
    Pages 301-317

  13. Back Matter

    Pages 319-326
    PDF
Back to top

About this book

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. 


What You Will Learn
  • 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


Who This Book Is For

Developers of applications and APIs that benefit from cloud database support, developers who wish to master their tools (including Azure SQL Database, and those who want their applications to be known for speedy performance and the elegance of their code
Back to top

Keywords

  • Azure SQL Database
  • JSON
  • Key-value
  • Graph Queries
  • ColumnStore
  • Hekaton
  • MicroORM
  • Execution Plans
  • In-Memory
  • Materialized Views
  • Event Sourcing
  • Microservices
  • Command Query Responsibility Segregation. (CQRS)
  • Indexes
  • Internet of Things (IoT)
  • SQL Server
Back to top

Authors and Affiliations

  • Redmond, USA

    Davide Mauri, Sanjay Mishra

  • Legnano, Italy

    Silvano Coriani

  • Sherman Oaks, USA

    Anna Hoffman

  • Belgrade, Serbia

    Jovan Popovic

Back to top

About the authors

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, R, and Java, to democratize AI via tools and services such as Azure Cognitive Services, Azure Machine Learning, and SQL Server (Machine Learning Services and Big Data Clusters). She now spends most of her time working on the Azure SQL Database product team and participating in the community. She has an undergraduate engineering degree from Georgia Institute of Technology, and she is wrapping up a Master of Science in analytics, also at Georgia Institute of Technology (he is always learning). You can follow her on Twitter at @AnalyticAnna. 


Sanjay Mishra is Product Leader in Microsoft Azure Data. He leads product management for the Azure SQL Database team, which includes products such as Azure SQL DB, SQL Hyperscale, Elastic Pools. Prior to this role, he served as Technical Advisor to the VP of Azure Data PM, and led the eminent SQLCAT and DataCAT teams.


Jovan Popovic is Senior Program Manager working on Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. He is working in Microsoft Development Center Serbia as Program Manager on several developer-facing SQL Server/Azure SQL features such as T-SQL language enhancements, JSON/temporal support, columnstore/in-memory technologies, and built-in intelligence. He has more than 15 years of experience in various Microsoft technologies with a focus on SQL Server, Azure, ASP.NET, C#, and JavaScript. He has been working in various Microsoft Data Platform teams since 2012. He is a former Microsoft MVP for ASP.NET and has a PhD degree in software engineering from the University of Belgrade. He is am public speaker at top Microsoft conferences, and is author of several books and open-source projects. He enjoys exploring technologies (especially SQL Server capabilities) and finding the best ways to implement the most efficient solutions using them.

Back to top

Bibliographic Information

  • Book Title: Practical Azure SQL Database for Modern Developers

  • Book Subtitle: Building Applications in the Microsoft Cloud

  • Authors: Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic

  • DOI: https://doi.org/10.1007/978-1-4842-6370-9

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic 2021

  • Softcover ISBN: 978-1-4842-6369-3Published: 06 November 2020

  • eBook ISBN: 978-1-4842-6370-9Published: 05 November 2020

  • Edition Number: 1

  • Number of Pages: XXV, 326

  • Number of Illustrations: 66 b/w illustrations

  • Topics: Microsoft, Database Management

Back to top
Access via your institution
eBook USD 29.99
Price excludes VAT (USA)
  • ISBN: 978-1-4842-6370-9
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book USD 39.99
Price excludes VAT (USA)
Learn about institutional subscriptions