Podcasts about azure sql database

SDU Show 92 features Data Platform MVP Joey D'Antoni discussing his experiences working across SQL Server and PostgreSQL

Microsoft Azure SQL is a fully managed and scalable cloud database service – and its myriad benefits mean your company should be considering it if it isn't already using it. To unpack this in more detail, Preegan Chetty, Microsoft Azure product manager at First Distribution, and Silicon Overdrive Microsoft business executive Jody Roberts join TechCentral's business technology show TCS+. In the episode, they unpack: • The relationship between First Distribution and Silicon Overdrive; • Silicon Overdrive's market focus; • What Azure SQL is and how it's helping companies with their digital transformation initiatives; • Why many South African businesses run SQL Server databases, usually on-premises, and what the advantages are of moving these databases into the Microsoft Azure cloud; • The cost advantages of shifting, and what's involved in doing so; • The security considerations of shifting from on-premises SQL Server to Azure SQL; • The features that make Azure SQL particularly secure; • Use cases of businesses leveraging Azure SQL; and • Azure SQL Database vs SQL Managed Instance vs SQL Service on Azure virtual machines – the differences between these options, and why businesses should choose one over another. Don't miss the discussion. -- TCS+ episodes are sponsored. TechCentral

Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation. Relevant links: Resources from Microsoft: Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub Native JSON support now in preview in Azure SQL Managed Instance - Microsoft Community Hub EAP for Vector Support Refresh - Introducing Vector type - Azure SQL Devs' Corner (microsoft.com) Calling external REST endpoints from Azure SQL Database | Microsoft Learn Index fragmentation: SQL Server Backup, Integrity Check, Index and Statistics Maintenance (hallengren.com) Should we do index maintenance on an Azure SQL Managed Instance or Azure SQL Database? (kendralittle.com) Stop Worrying About SQL Server Index Fragmentation (brentozar.com) Why SQL Server Index Fragmentation Isn't A Problem On Modern Storage Hardware – Darling Data (erikdarling.com) Index fragmentation scripts: microsoft-dbas-club/Indexes/Table and Index High Unused Space.sql at MadeiraData/microsoft-dbas-club Check Index Fragmentation Based on Page Fullness and Fill Factor Upcoming webinar at the Cloud Data Driven Meetup: Database DevOps for Leaders - Eitan Blumin, Thu, Oct 24, 2024, 12:00 PM | Meetup

See how you can use your SQL data as a robust backend for AI applications with semantic search and retrieval augmented generation. Azure SQL Database along with any SQL servers you connect to Azure integrate seamlessly with Azure AI Search and the Azure OpenAI Service, enabling natural language search capabilities within your SQL data. Use this approach to enhance e-commerce platforms, financial data analysis, or CRM systems while using SQL's granular access management controls to ensure that data searches and generated responses are limited to specific user permissions. ► QUICK LINKS: 00:00 - Generative AI for your SQL workloads 00:33 - Retrieval Augmented Generation 01:00 - Granular access management 01:15 - Enable natural language search 01:54 - Connect vectorized SQL data 02:20 - Test generative AI responses 02:41 - Wrap up   ► Unfamiliar with Microsoft Mechanics?  As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. • Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast   ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics  • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/msftmechanics/ • Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics

Bring your MySQL workloads to run on Azure. Azure Database for MySQL - Flexible Server offers a powerful, fully managed solution for MySQL workloads, providing unique platform-level optimizations that significantly enhance connection scaling and cost performance. Ensure high efficiency and reduced latency for mission-critical applications for up to twice the performance of other offerings. The integration with Azure OpenAI Service and Azure AI Search further extends its capabilities, enabling intelligent vector-based search and generative AI responses for more accurate and relevant user queries. Join Parikshit Savjani, Azure Database for MySQL Principal Group PM, shares how Azure Database for MySQL - Flexible Server transforms traditional MySQL applications into high-performance, intelligent systems by combining the scalability and security of Azure with advanced AI-driven insights.   ► QUICK LINKS: 00:00 - Run MySQL on Azure 00:56 - Run your LAMP stack on Azure 01:24 - Accelerated Logs capability 03:02 - Vector-based search and generative AI 04:02 - Leverage Azure AI Search & Azure OpenAI services 04:29 - Establish database connection 05:52 - Build vector index 07:04 - Create an Indexer 07:32 - Semantic Search 07:54 - Test it in the Azure AI playground 08:49 - Wrap up   ► Link References  Check out https://aka.ms/mysql-resources   Join the community for Azure Database for MySQL at https://aka.ms/mysql-contributors   ► Unfamiliar with Microsoft Mechanics?  As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. • Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast   ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics  • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/msftmechanics/ • Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics

Check out new AI integrations for your Azure SQL databases. With Retrieval Augmented Generation, you can bridge structured data with generative AI, enhancing natural language queries across applications. With advanced vector-based semantic search, discover precise insights tailored to your data, while Copilot in Azure streamlines troubleshooting and T-SQL query authoring. Optimize workflows, personalize responses, and unlock new levels of efficiency in SQL-driven AI applications. Accelerate performance troubleshooting and complex query authoring tasks with Copilot in Azure. Quickly diagnose database issues and receive expert recommendations for optimization, ensuring optimal performance and reliability. Seamlessly traverse hierarchies within tables and generate intricate queries with ease, saving time and resources. Bob Ward, Azure Principal Architect, shows how to unleash the full potential of your SQL data, driving innovation and intelligence across your applications.   ► QUICK LINKS: 00:00 - AI and Azure SQL 01:40 - Using T-SQL for search 02:30 - Using Azure AI Search 03:17 - Vector embeddings and skillsets 04:08 - Connect your SQL data to an AI app 05:44 - Test it in Azure OpenAI Studio playground 07:22 - Combine native JSON data type in SQL 08:30 - Hybrid search 09:56 - Copilot in Azure: Performance troubleshooting 11:11 - Copilot in Azure: Query authoring 12:24 - Permissions 12:40 - Wrap up   ► Link References For building AI apps, check out https://aka.ms/sqlai  Try out new copilot experiences at https://aka.ms/sqlcopilot   ► Unfamiliar with Microsoft Mechanics?  As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. • Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast   ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics  • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/msftmechanics/ • Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics  

Several years ago, I heard about a new product coming in Azure that would provide an IaaS (infrastructure as a service) VM to run SQL Server, with Microsoft managing most of the admin tasks for the instance, like patching and backups. That didn't seem like a big load to me, and I wondered if anyone would actually pay for this product. After all, don't most companies find managing patches and backups? That product became Azure SQL Managed Instance, and I've been surprised at the adoption. Quite a few clients have adopted this as a way to lift and shift (mostly) to the cloud in an easy fashion without the restrictions of Azure SQL Database. This looks like a "normal" on-premises SQL Server, and there are both high-performance (Business Critical tier) and average-performance (General Purpose tier) versions of the product that let you choose what level of price/performance you need to achieve. Read the rest of Managed Instance Impressions

SDU Show 91 features the Cloud SQL lead for Google Mohamed Kabiruddin discussing implementing SQL Server on Google Cloud

SDU Show 90 features Microsoft Senior Product Manager Joe Sack discussing Copilot integration with Azure SQL DB

SQL Server 2000のバックアップデータベースを2008に復元できた、Azure SQL Databaseを無料範囲で使ってみる、30万レコードのテーブルをローコードツールのデータソースにすると何の上限に引っかかるの？、などについて話しました。

Re-platforming is the process of moving a system to a new platform. Imagine taking an ASP.NET/SQL Server website and moving to Azure Functions on Azure SQL Database. Or maybe taking a Java client/server app with Oracle and moving it to a series of microservices against MongoDB. Those changes could be a net benefit to your organization in the end, but they aren't quick or easy. They're often fraught with various challenges that can cause a lot of stress while creeping over budget. There's a post that talks about some of the things you might think about if you embark upon a re-platform. Often this takes place when an organization is looking to modernize their tech stack. Quite a few of the technology DevOps success stories take place when the older structures are not maintainable, but also not able to handle increased workloads or performance requirements. Read the rest of Re-platforming

In this special episode Michael talks to his colleague Sravani Saluru about how to configure, monitor and manage audit logging in Azure SQL Database. She also shares some inside hints and tips!

AWS Puts Up a New VPC Lattice to Ease the Growth of Your Connectivity AKA Welcome to April (how is it April already?) This week, Justin, Jonathan, and Matt are your guides through all the latest and greatest in Cloud news; including VPC Lattice from AWS, the one and only time we'll talk about Service Catalog, and an ultra premium DDoS experience. All this week on The Cloud Pod.  This week's alternate title(s): AWS Finally makes service catalogs good with Terraform Amazon continues to believe retailers with supply chain will give all their data to them Azure copies your data from S3… AWS copies your data from Azure Blobs… or how I set money on fire with data egress charges

Michael and Mark talk to Kemley Nieva from the Azure Governance team about some of the recent updates and improvements to Azure Policy. We also cover the latest Azure security news covering Microsoft Security Copilot, Azure Functions, SQL Managed Instance, Azure Backup, Ephemeral OS disks, Azure Cache for Redis, Azure SQL Database, Azure Monitor, API Management, Azure Maps and Storage.

On this episode of The Cloud Pod, the team discusses the new Amazon Linux 2023, Google Bard,  new features of Google Chronicle Security Operations, GPT-4 from Azure Open AI, and Oracle's Kubernetes platform comparison. They also talk about cloud-native architecture as a way to adapt applications for a pivot to the cloud. A big thanks to this week's sponsor, Foghorn Consulting, which provides full-stack cloud solutions with a focus on strategy, planning and execution for enterprises seeking to take advantage of the transformative capabilities of AWS, Google Cloud and Azure. This week's highlights

In this episode Michael and Gladys talk with guests Sean Wesonga and Bojan Magusic about using Infrastructure as Code (IaC) with Microsoft Defender for Cloud. We also discuss Azure Security news about new Azure SQL Database migration abilities for authentication and Transparent Data Encryption (TDE).

In this special episode, Michael sits down with Pieter Vanhove about a new addition to the SQL Server 'Always Encrypted' family. The new addition, Virtualization-Based Security Enclaves (VBS), is now in Preview and allows for more scalability and lower cost when using secure enclaves compared to the current SGX-based enclaves.

Davide Mauri joins Scott Hanselman to discuss a recently announced feature of Azure SQL DB that makes integration with REST APIs incredibly easy. A new system function enables Azure SQL DB to call any HTTP REST API securely: call an Azure Function, send a message to Event Hub, execute a DAX query in Power BI, enrich data with Cognitive Services, etc. Chapters 00:00 - Introduction 02:15 - Background discussion 06:21 - Demo 1: Calling an Azure Function 10:02 - Demo 2: Query a GraphQL service 12:05 - Demo 3: Update a page in real time with SignalR 15:05 - Demo 4: Power BI executeQueries 17:20 - Demo 5: Event Hub 19:05 - Wrap-up 19:41 - Bonus demo: Cognitive Services Recommended resources sp_invoke_external_rest_endpoint (Transact-SQL) (Preview) Azure-Samples/azure-sql-db-invoke-external-rest-endpoints Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Davide Mauri | Twitter: @MauriDB Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

Davide Mauri joins Scott Hanselman to discuss a recently announced feature of Azure SQL DB that makes integration with REST APIs incredibly easy. A new system function enables Azure SQL DB to call any HTTP REST API securely: call an Azure Function, send a message to Event Hub, execute a DAX query in Power BI, enrich data with Cognitive Services, etc. Chapters 00:00 - Introduction 02:15 - Background discussion 06:21 - Demo 1: Calling an Azure Function 10:02 - Demo 2: Query a GraphQL service 12:05 - Demo 3: Update a page in real time with SignalR 15:05 - Demo 4: Power BI executeQueries 17:20 - Demo 5: Event Hub 19:05 - Wrap-up 19:41 - Bonus demo: Cognitive Services Recommended resources sp_invoke_external_rest_endpoint (Transact-SQL) (Preview) Azure-Samples/azure-sql-db-invoke-external-rest-endpoints Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Davide Mauri | Twitter: @MauriDB Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

SDU Show 83 features Principal Product Manager David Mauri discussing how to make REST calls from within Azure SQL Database using a new system stored procedure

Drew Skwiers-Koballa shows Scott Hanselman a new option for developing with Azure SQL Database: The Azure SQL Database emulator, which is a containerized database for a desktop dev experience. Use your favorite client OS and dev tools for cloud development without the cloud. Chapters 00:00 - Introduction 02:54 - Modern microservices-demo application overview 04:10 - Database Projects and Integration with VS Code 15:43 - Deployment using GitHub Actions 18:46 - Wrap-up Recommended resources What is the local development experience for Azure SQL Database? Introducing the Azure SQL Database emulator (preview) SQL Database Projects extension (Preview) Download and install Azure Data Studio Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Drew Skwiers-Koballa | Twitter: @SysAdminDrew Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

Drew Skwiers-Koballa shows Scott Hanselman a new option for developing with Azure SQL Database: The Azure SQL Database emulator, which is a containerized database for a desktop dev experience. Use your favorite client OS and dev tools for cloud development without the cloud. Chapters 00:00 - Introduction 02:54 - Modern microservices-demo application overview 04:10 - Database Projects and Integration with VS Code 15:43 - Deployment using GitHub Actions 18:46 - Wrap-up Recommended resources What is the local development experience for Azure SQL Database? Introducing the Azure SQL Database emulator (preview) SQL Database Projects extension (Preview) Download and install Azure Data Studio Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Drew Skwiers-Koballa | Twitter: @SysAdminDrew Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

On The Cloud Pod this week, Amazon announces Neptune Serverless, Google introduces Google Blockchain Node Engine, and we get some cost management updates from Microsoft. Thank you to our sponsor, Foghorn Consulting, which provides top notch cloud and DevOps engineers to the world's most innovative companies. Initiatives stalled because you're having trouble hiring? Foghorn can be burning down your DevOps and Cloud backlogs as soon as next week. General News [1:24]

In this special, out of band episode, Michael talks to Andreas Wolter about the SQL Server and Azure SQL Database permission model. To many, the model is a mystery, but Andreas explains how it works as Michael poses security challenges.

The team catches up with the developers of the Databricks Accelerator for Azure Purview to learn when, where, and why you might use it.   Media file: https://azpodcast.blob.core.windows.net/episodes/Episode441.mp3 YouTube: https://youtu.be/W9Dyb6E5eKk Resources: The Databricks to Purview Solution Accelerator Repo: microsoft/Purview-ADB-Lineage-Solution-Accelerator: A connector to ingest Azure Databricks lineage into Microsoft Purview (github.com) Demo Deployment Quickstart: Purview-ADB-Lineage-Solution-Accelerator/deploy-demo.md at release/2.1 · microsoft/Purview-ADB-Lineage-Solution-Accelerator (github.com) YouTube Video overview: Demoing the Azure Databricks lineage solution accelerator in Microsoft Purview - YouTube The OpenLineage Repo: OpenLineage/OpenLineage: An Open Standard for lineage metadata collection (github.com) OpenLineage + Purview Blog: Microsoft Purview Accelerates Lineage Extraction from Azure Databricks | OpenLineage   Other updates: Public preview: 128 vCore option for Azure SQL Database standard-series hardware | Azure updates | Microsoft Azure - 415 GB of memory   Azure Basic Load Balancer will be retired on 30 September 2025—upgrade to Standard Load Balancer | Azure updates | Microsoft Azure    https://azure.microsoft.com/en-us/blog/microsoft-and-int-deploy-ivaap-for-osdu-data-platform-on-microsoft-energy-data-services/   Azure Machine Learning—General availability updates for September 2022 | Azure updates | Microsoft Azure   Azure Machine Learning—Public preview updates for September 2022 | Azure updates | Microsoft Azure   Public preview: Azure Firewall Basic | Azure updates | Microsoft Azure  designed for SMB ; cost effective SKU   https://azure.microsoft.com/en-us/blog/strengthen-your-security-with-policy-analytics-for-azure-firewall/

Build, test, and deploy scalable apps quickly with Azure SQL updates for developers. Check out platform enhancements for modern, cloud-based apps: -Create apps locally with Azure SQL Database emulator -Initiate serverless operations with SQL trigger in Azure Functions -Build simple and secure API connections to data with Data API Builder, coming soon Principal Architect from the SQL engineering team at Microsoft, Bob Ward, joins Jeremy Chapman to share recent updates for the developer experience. ► QUICK LINKS: 00:00 - Introduction 01:41 - Highlights of solutions for developers 03:13 - Built-in query intelligence 05:56 - Azure SQL Database emulator 07:44 - SQL trigger in Azure Functions 10:44 - Data API Builder 12:32 - Wrap up ► Link References: Get published code for assigning work orders based on geolocation at https://aka.ms/sqlgeocodesample ► Unfamiliar with Microsoft Mechanics? As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. • Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1 • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/website • To get the newest tech for IT in your inbox, subscribe to our newsletter: https://www.getrevue.co/profile/msftmechanics ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/msftmechanics/ • Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics  

One of the challenges in moving to the cloud is achieving a similar level of performance to what you would get with dedicated hardware on-premises. The cloud is someone else's computer, and you are limited to the choices that the vendors allow you to rent. In many cases, you might even share the physical hardware resources with other customers, though many cloud providers have started to allow dedicated hardware reservations in the last few years. One of the challenges of choosing a PaaS cloud database platform is that there are often restrictions that differ from a similar platform on-premises. This is often to ensure that one customer doesn't affect another, or that customers don't make changes that might prevent the vendor from supporting the system. Azure SQL Database gives us a database only, no instance features, though we do see a virtual master database. Read the rest of Custom SQL Server on RDS

We're all trying to work faster and smarter to solve today's data-driven challenges. Microsoft's Intelligent Data Platform can help by removing silos around data and providing near real-time insights, augmented with predictive AI and built-in controls that protect your data wherever it goes. Sharieff Mansour, a leader on the Data and AI team at Microsoft, joins Jeremy Chapman for a closer look at how databases, analytics, machine learning, and governance come together in the Intelligent Data Platform. See how you can use these integrated services to build powerful new apps or modernize your current ones. ► QUICK LINKS: 00:00 Introduction of Microsoft Intelligent Data Platform 01:05 Improve the way you work with data 01:37 Foundational advantages of Intelligent Data Platform 02:09 Demo of how Intelligent Data Platform solves a real-world problem 05:30 Tech behind the app 07:37 Built-in AI predictions 10:32 Remove tech and people silos to make data work for you 12:04 Personalize customer interaction with Power Virtual Agent BOT ► Link Reference: Find the latest information on Intelligent Data Platform at: aka.ms/MicrosoftIDP ► Unfamiliar with Microsoft Mechanics? • As the Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1 • Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog • Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/website • To get the newest tech for IT in your inbox, subscribe to our newsletter: https://www.getrevue.co/profile/msftmechanics ► Keep getting this insider knowledge, join us on social: • Follow us on Twitter: https://twitter.com/MSFTMechanics • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/ • Enjoy us on Instagram: https://www.instagram.com/microsoftmechanics/ • Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics

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

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

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

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

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

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

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

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

Guy and Eitan discuss their favorite upcoming new features in SQL Server 2022, and talk about some major upcoming events and summits. Relevant links: SQL Server 2022 public preview is now available on Linux Introducing the SQL Server 2022 blog series by Bob Ward Contained Availability Groups in SQL Server 2022 | Eitan Blumin What is a contained availability group? | Microsoft Docs Erik Darling Blog series about Parameter Sensitive Plans XML Data Compression in SQL Server 2022 Link feature in Azure SQL MI for SQL Server Welcome to the new Azure SQL Database local development experience Planning new scenarios and use cases for Azure SQL Database local development experience DOP Feedback In SQL Server 2022 Upcoming community events: Data Platform Virtual Summit (by Data Platform Geeks) PASS Data Community Summit Madeira Toolbox Scripts: Compare SQL Server instance properties Change Tracking Generic Synchronization.sql 

One of the things I've seen in working with cloud based resources is that you get a lot of them in your account quickly. A database might end up with a server, an IP address, a network, security groups, and more. A few clicks of the mouse in the Azure Portal can create a new Resource Group that doesn't just have the one thing you need, but 3, 4, or more other items. In addition to the quantity, there are also the problems of namespaces in cloud resources. Some of the items you provision are publicly named in a domain, such as database.windows.net. In these cases, the resources need to be unique among all cloud customers. Just like domain names, this means that you might have collisions with your favorite name. While I might like jones.com, there are a few other people that would likewise prefer this. The rest of us might have to choose jones2.com, stevejonesincolorado.com, or some other variation. In large organizations, you might end up with LA34532345454.database.windows.net for an Azure SQL Database. Read the rest of The Useful Cloud Tags

On The Cloud Pod this week, the team talks tactics for infiltrating the new Google Cloud center in Ohio. Plus: AWS goes sci-fi with the new Graviton3 processors, the new GKE cost estimator calculates the value of your soul, and Microsoft builds the metaverse.  A big thanks to this week's sponsor, Foghorn Consulting, which provides full-stack cloud solutions with a focus on strategy, planning and execution for enterprises seeking to take advantage of the transformative capabilities of AWS, Google Cloud and Azure. This week's highlights

In this special episode Sarah and Michael talk to Pieter Vanhove about Azure SQL Database Ledger.Ledger is a new feature built into Azure SQL DB and SQL Server 2022. that helps protect data from tampering from attackers or high-privileged users, including database administrators (DBAs), system administrators, and cloud administrators.

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

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

### L'apéro* Le debrief de Devoxx 2022 -> https://www.devoxx.fr/### Cloud* Announcing General Availability of Change Data Capture (CDC) on Azure SQL Database -> https://techcommunity.microsoft.com/t5/azure-sql-blog/announcing-general-availability-of-change-data-capture-cdc-on/ba-p/3284280* Announcing Gated Public Preview of Unity Catalog on AWS and Azure -> https://databricks.com/blog/2022/04/20/announcing-gated-public-preview-of-unity-catalog-on-aws-and-azure.html### Cloud Native* Enterprises using more Kubernetes across more clouds, but continue to find it challenging: report -> https://devclass.com/2022/04/27/state-of-kubernetes/* Google donates the Istio service mesh to the Cloud Native Computing Foundation -> https://techcrunch.com/2022/04/25/google-donates-the-istio-service-mesh-to-the-cloud-native-computing-foundation/* KubeVirt becomes a CNCF incubating project -> https://www.cncf.io/blog/2022/04/19/kubevirt-becomes-a-cncf-incubating-project/### Machine Learning* Cortex Labs is Joining Databricks to Accelerate Model Serving and MLOps -> https://databricks.com/blog/2022/04/25/cortex-labs-databricks-model-serving-mlops.html* Feathr – An Enterprise-Grade, High Performance Feature Store -> https://github.com/linkedin/feathr### Dev tools* Gitpod x JetBrains join forces to solve 'works on my machine' problem -> https://www.gitpod.io/blog/gitpod-jetbrains### SponsorsCette publication est sponsorisée par [Affini-Tech](https://affini-tech.com/) et [CerenIT](https://www.cerenit.fr/).[CerenIT](https://www.cerenit.fr/) vous accompagne pour concevoir, industrialiser ou automatiser vos plateformes mais aussi pour faire parler vos données temporelles. Ecrivez nous à [contact@cerenit.fr](mailto:contact@cerenit.fr) et retrouvez-nous aussi sur [Time Series France](https://www.timeseriesfr.org/).Affini-Tech vous accompagne dans tous vos projets Cloud et Data, pour Imaginer, Expérimenter etExecuter vos services ! ([Affini-Tech](http://affini-tech.com), La plateforme [Datatask](https://datatask.io/)) pour accélérer vos services Data et IAConsulter le [blog d'Affini-Tech](https://affini-tech.com/blog/) et le [blog de Datatask](https://datatask.io/blog/) pour en savoir plus.On recrute ! Venez cruncher de la data avec nous ! Ecrivez nous à [recrutement@affini-tech.com](mailto:recrutement@affini-tech.com)Le générique a été composé et réalisé par Maxence Lecointe.

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

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

In the first of a series of episodes about Azure SQL Database, Davide Mauri joins Lara Rubbelke to give an overview of Grouping Sets and Windowing Functions, which can make you, your solution, and your code much more efficient. Chapters 00:00 - Introduction 01:01 - Discussion 03:58 - Grouping Sets 11:56 - Windowing Functions 25:11 - Wrap-up Recommended resources Azure SQL Database Azure SQL documentation Azure SQL Database code samples Write queries that use window functions 10 reasons to use Azure SQL in your next project Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

In the first of a series of episodes about Azure SQL Database, Davide Mauri joins Lara Rubbelke to give an overview of Grouping Sets and Windowing Functions, which can make you, your solution, and your code much more efficient. Chapters 00:00 - Introduction 01:01 - Discussion 03:58 - Grouping Sets 11:56 - Windowing Functions 25:11 - Wrap-up Recommended resources Azure SQL Database Azure SQL documentation Azure SQL Database code samples Write queries that use window functions 10 reasons to use Azure SQL in your next project Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

The team talks with Pujitha and Sidhanshu about Project Flash, an initiative to improve VM availability monitoring that allows for immediate actions and trend analysis at scale.   Media File: https://azpodcast.blob.core.windows.net/episodes/Episode421.mp3 YouTube: https://youtu.be/c7vXz-tjQAA Resources: https://azure.microsoft.com/en-us/blog/advancing-azure-virtual-machine-availability-monitoring-with-project-flash/  https://aka.ms/flashblog   Other updates: Public preview: Azure SQL Database Hyperscale reverse migration to general purpose tier  https://azure.microsoft.com/en-us/updates/public-preview-azure-sql-database-hyperscale-reverse-migration-to-general-purpose-tier/ General availability: Zone redundancy for Azure SQL Database general purpose tier https://azure.microsoft.com/en-us/updates/general-availability-zone-redundancy-for-azure-sql-database-general-purpose-tier/ Azure Purview is now Microsoft Purview https://azure.microsoft.com/en-us/blog/azure-purview-is-now-microsoft-purview/ Getting rid of credentials in Azure (multi-part) https://techcommunity.microsoft.com/t5/azure-developer-community-blog/getting-rid-of-credentials-in-azure-part-1/ba-p/3265205 Azure SQL—Public preview updates for mid-April 2022  https://azure.microsoft.com/en-us/updates/azure-sql-public-preview-updates-for-midapril-2022/ Generally available: IBM WebSphere on Azure with evaluation licensing https://azure.microsoft.com/en-us/updates/generally-available-ibm-websphere-on-azure-with-evaluation-licensing/      

Jupyter Notebooks are a popular way of consolidating a number of code batches together and them executing them as separate batches or all together. These are essentially a document with notes and code, all of which are stored together. Databricks can run these, as can a number of other services. They are also integrated into various tools, like Azure Data Studio. Just like many other technologies, we'd like to execute these in a way that suits our environment. While running these in a tool like ADS works fine, we might want to schedule these and check the results later. You can run notebooks with PowerShell, but keeping around results and managing the data is hard. Since many of us use SQL Server or Azure SQL Database, wouldn't it be great if we could find a way to have these run inside SQL Server and keep the results around? Read the rest of Executing Notebooks in a Stored Procedure

In Episode 253, Ben and Scott take a detour and talk about considerations for backup and disaster recovery in Azure. Sponsors ShareGate - ShareGate's industry-leading products help IT professionals worldwide migrate their business to the Office 365 or SharePoint, automate their Office 365 governance, and understand their Azure usage & costs Office365AdminPortal.com - Providing admins the knowledge and tools to run Office 365 successfully Intelligink - We focus on the Microsoft Cloud so you can focus on your business Show Notes Windows Subsystem for Android™️ Microsoft fixes Windows 11 AMD CPU performance issues with new update Backup and disaster recovery for Azure applications Azure Storage redundancy Microsoft Azure Well-Architected Framework - Reliability Automated backups - Azure SQL Database & Azure SQL Managed Instance Microsoft-managed failover Join us on Azure IaaS Day: Learn to increase agility and resiliency of your infrastructure Plan your Microsoft Azure experience at Microsoft Ignite 2021 IoT at Microsoft Ignite About the sponsors Every business will eventually have to move to the cloud and adapt to it. That's a fact. ShareGate helps with that. Our industry-leading products help IT professionals worldwide migrate their business to the Office 365 or SharePoint, automate their Office 365 governance, and understand their Azure usage & costs. Visit https://sharegate.com/ to learn more. Intelligink utilizes their skill and passion for the Microsoft cloud to empower their customers with the freedom to focus on their core business. They partner with them to implement and administer their cloud technology deployments and solutions. Visit Intelligink.com for more info.