Azure Friday

Lakshmi Murthy joins Scott Hanselman to show how to build your enterprise data model using Azure Synapse database templates to add rich business context to your data and drive meaningful analytics. Chapters 00:00 - Introduction 01:07 - Azure Synapse database templates 04:54 - Demo: Creating a lake database 10:35 - Demo: Customizing and querying 17:04 - Wrap-up Recommended resources Lake database templates Announcing GA of Database Templates in Azure Synapse Analytics How-to: Create a lake database from database templates Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Friday | Twitter: @AzureFriday

Elizabeth Barnitt joins Scott Hanselman to discuss and demo GraphQL support in Azure API Management, which allows you to import, validate, secure, and augment GraphQL APIs in Azure. Azure API Management enables you to both govern your existing GraphQL servers and build one from scratch with Synthetic GraphQL, which allows you to combine your existing REST and SOAP endpoints into a single, easy to query endpoint. Chapters 00:00 - Introduction 01:23 - What is GraphQL? 11:34 - Demo - Import a GraphQL API 18:12 - Demo - Synthetic GraphQL 21:24 - Wrap-up Recommended resources Azure API Management resources Import a GraphQL API Import a GraphQL schema and set up field resolvers Protect, Augment, and Build GraphQL APIs with Azure API Management Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Elizabeth Barnitt | Twitter: @BarnittE Azure Friday | Twitter: @AzureFriday

Managing concurrent access to a resource, be it a row, a table, or a single value, is easy if no one is trying to modify the underlying data. But what happens if someone changes data while someone else is reading it? Even better, what could happen if two or more users try to change the same data at the same time? Well, there are a couple of options. The easiest is to just ask everyone to queue up, the other is to have multiple versions of the data available over time so that no one must wait for the changes to be finished. Let's explore both the options with Lara Rubbelke and Davide Mauri on Azure Friday. Chapters 00:00 - Introduction 01:50 - DEMO: Locking behavior 03:20 - DEMO: Default "read committed snapshot" behavior 05:20 - Migrating from SQL Server to Azure SQL DB 06:42 - DEMO: snapshot isolation level 12:12 - Wrap-up Recommended resources Transaction locking and row versioning guide SET TRANSACTION ISOLATION LEVEL (Transact-SQL) Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

Rong Zhang and Tats Mishra join Scott Hanselman to talk about the AKS extension in VS Code that provides a fully integrated Azure Kubernetes Services diagnostics experience. Chapters 00:00 - Introduction 01:53 - Get the extension + connect to Azure 03:18 - Extension features 05:32 - AKS Periscope 06:47 - Navigational features 07:24 - Cluster properties 08:25 - Creating workflows 09:43 - Azure Service Operator 11:05 - Wrap-up Recommended resources AKS tools and diagnostics in VS Code AKS Extension for Visual Studio Code Azure Kubernetes Service Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Rong Zhang | Twitter: @RongZhang817 Tatsat Mishra | Twitter: @Tats_innit Azure Friday | Twitter: @AzureFriday

Davide Mauri is back with Lara Rubbelke to discuss columnstore indexes. In a typical relational database data is stored per row. This means that all row columns are saved together, which is great in all those cases where you want to retrieve all the information related to a specific row. But what if you want to have all the data stored in a subset of columns but for all the rows? That would be complex and slow—unless data was saved per-column instead of per-row. That's exactly what columnstore indexes in Azure SQL Database enables you to do. Chapters 00:00 - Introduction 01:00 - Columnstore overview 07:00 - Demo: index creation 10:14 - Demo: querying with columnstore 13:53 - Demo: batch mode with LAG operator 15:00 - Wrap-up Recommended resources Columnstore indexes: Overview Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

Lior Kamrat joins Scott Hanselman to discuss Azure Arc-enabled Kubernetes extensibility model, which makes any Kubernetes cluster outside of Azure a target location for many Azure services. Chapters 00:00 - Introduction 01:58 - Extensibility model 04:54 - Azure portal 09:20 - Demo, Part 1 16:30 - Demo, Part 2 17:50 - Wrap-up Recommended resources Azure Arc landing zone accelerator for hybrid and multi-cloud What is Azure Arc-enabled Kubernetes? Azure Arc Jumpstart Jumpstart ArcBox - Overview Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Twitter: Scott Hanselman | @SHanselman Twitter: Lior Kamrat | @LiorKarmat Twitter: Azure Friday | @AzureFriday

If you are familiar with the Event Sourcing and CQRS patterns, then you know that they are extremely powerful, but can be quite complex to implement correctly. Davide Mauri joins Lara Rubbelke to show temporal tables give you the same benefits without the related challenges. Chapters 00:00 - Introduction 01:28 - Demo using temporal tables 06:11 - Demo using 'as of' 07:36 - Demo for a range of time 08:32 - Wrap-up Recommended resources Getting started with temporal tables Configure temporal retention policy Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Twitter: Lara Rubbelke | @SQLGal Twitter: Davide Mauri | @MauriDB Twitter: Azure Friday | @AzureFriday

Bruno Borges joins Scott Hanselman to talk about Java development with Microsoft. Like many of our customers, Microsoft is a Java shop with lots of systems that rely on Java and its ecosystem. We employ thousands of Java engineers, run millions of JVMs, and process terabytes of data every day, to deliver the services everyone loves. We also built tools and services specifically designed for Java developers and applications. Chapters 00:00 - Introduction 02:53 - Java usage at Microsoft 04:55 - Microsoft Build of OpenJDK 07:18 - Modern Java at Microsoft (Java 17) 09:11 - Microsoft tools for Java 12:53 - Build on your terms 14:19 - Build or migrate Java apps 16:19 - Wrap-up Recommended resources Java on Azure Azure is the home for your enterprise Java applications Microsoft Build of OpenJDK Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Twitter: Scott Hanselman | @SHanselman Twitter: Bruno Borges | @BrunoBorges Twitter: Azure Friday | @AzureFriday

In recent years, developers pushed for relational databases to be more flexible and open to the many different formats (e.g., JSON, graph, and spatial) to store and manipulate data. Davide Mauri joins Lara Rubbelke to show how Azure SQL Database enables you to take advantage of the rock-solid foundation of relational databases with the flexibility offered by non-relational models. And best of all, it's seamlessly integrated to empower you to choose the best technology for the job. Chapters 00:00 - Introduction 02:00 - Working with JSON data 11:34 - SQL graph 17:17 - Samples 18:19 - Spatial data 19:35 - Wrap-up Recommended resources Work with JSON data in SQL Server SQL Graph Architecture Spatial Data Types Overview Browse Azure SQL DB code samples Azure SQL DB Samples and Best Practices on GitHub Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

John Downs joins Scott Hanselman to discuss how to design, architect, and build multitenant solutions on Azure. If you're building a SaaS product or another multitenant service, there's a lot to consider when you want to ensure high performance, tenant isolation, and managing deployments. We'll walk through some example SaaS architectures and see how Microsoft provides guidance to help you to build a multitenant solution on top of Azure. Chapters 00:00 - Introduction 00:23 - Multitenancy in the cloud 06:28 - Multitenancy guidance 07:00 - Design considerations 16:09 - Architectural approaches 18:07 - Service-specific guidance 20:28 - Wrap-up Recommended resources Architect multitenant solutions on Azure Architecting multitenant solutions Livestream event Share your feedback Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman John Downs | Twitter: @JDwns Azure Friday | Twitter: @AzureFriday