Podcasts about azure sql

Evan and Russell host David Stamen and Vaclav Jirovsky from Pure Storage, diving into how they've integrated their Pure Storage solution as an Azure native service. Media file: https://azpodcast.blob.core.windows.net/episodes/Episode520.mp3 YouTube:  {to follow} Resources: Azure Marketplace – Pure Storage Cloud Contact Me : A fully managed, Azure-native block storage-as-a-service offering from Pure Storage designed to simplify and optimize VMware migrations to Azure. YouTube Playlist – Pure Storage Cloud for Azure VMware Solution : A video series showcasing technical overviews, deployment guides, and use cases for Pure Storage Cloud integrated with Azure VMware Solution. Pure Storage Blog – Pure Storage Cloud for Azure VMware Solution : A deep dive into the architecture, benefits, and deployment of the Azure-native Pure Storage Cloud service for VMware workloads. Microsoft Tech Community – Public Preview Announcement : Announcement of the public preview of Pure Storage Cloud for Azure VMware, highlighting its native integration, scalability, and enterprise-grade storage capabilities. Microsoft Tech Community – Azure Storage Blog : Overview of Pure Storage Cloud’s public preview, emphasizing its VMware vVols support, native Azure experience, and simplified storage management. Microsoft Learn – Configuration Guide : Step-by-step guidance on configuring Azure Native Pure Storage Cloud for Azure VMware Solution, including deployment and integration details.   Other updates: General Availability: Instance Mix for Virtual Machine Scale Sets : Azure now supports deploying up to five VM sizes in a single scale set using Flexible Orchestration Mode, improving capacity, cost-efficiency, and deployment simplicity. Azure SQL Trigger for Azure Functions : This documentation explains how to use Azure SQL triggers in Functions to respond to database changes using change tracking and managed identities for secure integration. O3 and O4 Mini Unlock Enterprise Agent Workflows : Microsoft introduces O3 and O4 Mini models to enhance enterprise agent workflows with advanced reasoning via Azure AI Foundry and GitHub integration. Public Preview - Azure Logic Apps now available as Agent tool in Azure AI Foundry Generally Available: Azure Storage Actions – Serverless storage data management

Join Cale and Sujit in this exciting episode as they dive into the world of Azure Confidential Ledger with special guests Shubhra Sinha Kamath and Yagnesh Setti Subramanian from the Azure Product Team. Discover the latest updates and features of this auditable, tamper-proof ledger service, and learn how it integrates with Azure SQL and BLOB storage to ensure data integrity and confidentiality. Explore real-world applications in financial services, healthcare, AI, and more. Don't miss out on insights into server-side programming, multi-party capabilities, and upcoming previews. Tune in for a comprehensive look at how Azure Confidential Ledger is revolutionizing data security and compliance.   Media file: https://azpodcast.blob.core.windows.net/episodes/Episode518.mp3 YouTube: https://youtu.be/scWpKSKLsGs Resources: https://aka.ms/ACL-Docs https://aka.ms/ACL2025Preview    Othwr updates: Creating better healthcare outcomes with Azure OpenAI Service and Azure AI Foundry https://azure.microsoft.com/en-us/blog/creating-better-healthcare-outcomes-with-azure-openai-service-and-azure-ai-foundry/   Learn more about what’s new with Microsoft Azure Storage at KubeCon Europe 2025 https://azure.microsoft.com/en-us/blog/learn-more-about-whats-new-with-microsoft-azure-storage-at-kubecon-europe-2025/ https://learn.microsoft.com/en-us/azure/azure-monitor/app/kubernetes-codeless https://azure.microsoft.com/en-us/products/copilo

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

In the second episode of this series about migrating to Microsoft Azure SQL, the focus turns to what's involved in moving from SQL Server to Azure SQL, and First Distribution's Preegan Chetty returns to unpack the key priority of securing databases in the cloud. If you missed episode 1 in the series, you can find it here – or dive straight into this interview. Preegan Chetty, who is Microsoft Azure product manager at First Distribution, unpacks: • What makes Azure SQL a secure choice for companies today, including features such as data encryption (when data is at rest or in transit), threat detection and firewall protection; • Why companies shouldn't simply assume that the cloud is secure because it's being managed by a hyperscale cloud services provider; • Azure SQL's performance, and the optimisations that can be done to make the system fly; and • The role of AI in cloud database management. Don't miss any of the episodes in this insightful series. TechCentral

Is your company thinking about modernising its IT infrastructure? Is it planning to migrate from an on-premises Microsoft SQL Server database to the cloud-based Azure SQL solution? Then this podcast is for you. In this two-part series, we delve into greater detail on what's involved in a cloud database migration. First Distribution's Microsoft Azure product manager Preegan Chetty is our guest in the studio for this episode. He unpacks: • The risks and opportunities involved in the migration; • What companies need to be aware of before they even embark on a migration to Azure SQL; • How Microsoft helps companies with their migration projects; and • The top motivating factors driving companies to migrate away from an on-premises SQL Server solution to Azure SQL. Don't miss this informative discussion – and be sure to catch episode 2 in this series with First Distribution. TechCentral

Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL Edge to Cloud. Bob has worked for Microsoft for 30-plus years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2022, including Azure SQL. Bob is a well-known speaker on SQL Server, Azure SQL, AI, and Microsoft Fabric, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, DevIntersection, and VS Live. You can also learn Azure SQL from him on the popular series aka.ms/azuresql4beginners. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, Azure SQL Revealed, and SQL Server 2022 Revealed, available from Apress Media.   Topics of Discussion: [4:22] Bob's long history with Microsoft and the evolution of SQL Server. [6:41] What are the big use cases that SQL Server can now do? [7:38] Beyond RDBMS framework. [9:34] Building innovation off an already trusted brand. [9:50] What's the vision of AI on SQL Server? [10:51] It's all about smarter searching. [14:26] AI assistance features in SQL Server, such as the SQL Copilot and natural language to SQL query generation. [16:02] Hybrid searching. [19:41] Challenges and opportunities in AI Integration. [20:43] Content moderation is now being added to the loop. [22:39] The categories of different models. [23:16] The potential for industry-specific models to enhance AI capabilities in fields like insurance underwriting. [28:19] Knowing which model to use. [33:17] The trend towards industry-specific training of AI models to better suit specific business needs. [34:07] The current vision for SQL Server. [35:22] Innovating in the cloud. [38:30] The potential for SQL Server to handle AI workloads on small form factors, such as edge devices and standalone boards.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us at programming@palermo.net. Clear Measure, Inc. (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's Twitter — Follow to stay informed about future events! Ep 162 with Bob Ward Bob on LinkedIn Azure SQL Revealed: The Next-Generation Cloud Database with AI and Microsoft Fabric SQL-AI-Samples Samples Intelligent Applications with Azure SQL Database LangChain   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

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

The team catches up with Daniel Taylor and Bradley Ball of the Azure Fast Track team and learns about how Database Watcher can help customers better manage and debug their Azure SQL, Elastic Pools, SQL Managed Instances, and Hyperscale and the replicas.  Daniel and Bradley also share the really cool work they are doing helping Azure customers learn about Azure with their Tales from the Field YouTube channel, plus we hear about some upcoming events where you can see Daniel and Bradley in person!!!   Media file: https://azpodcast.blob.core.windows.net/episodes/Episode500.mp3 YouTube: https://youtu.be/Z_jBWLUBY9g   Resources:  https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-overview?view=azuresql https://youtu.be/qr1Qxwao68M?si=mO24KZF3PAvTnnmn   Other updates: https://azure.microsoft.com/en-us/updates/v2/Guest-OS-Family-Retirement https://azure.microsoft.com/en-us/updates/v2/cmk-for-backup-vaults-ga/ https://azure.microsoft.com/en-us/updates/v2/Azure-Elastic-SAN-Feature-Updates Azure classic resource providers will be retired on 31 August 2024 | Azure updates | Microsoft Azure

Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correctly in AlwaysOn Availability Groups. Relevant links: SQLBits Free Videos - YouTube JSON data type (preview) - SQL Server | Microsoft Learn Efficient Time-Based Audit Log Filtering for Azure SQL Database - Microsoft Community Hub UNISTR and ANSI SQL concatenation operator (||) (microsoft.com) SQL Server on Azure VMs: I/O analysis (preview) - Microsoft Community Hub Announcing the retirement of SQL Server Stretch Database - Microsoft SQL Server Blog 30 SQL Server Security Checks in 30 Days Archives - Straight Path Solutions Use Sparse Columns - SQL Server | Microsoft Learn SQL Server Jobs & AlwaysOn Interoperability | HADRMyJobs

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  

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

Guy and Eitan continue discussing HADR solutions. But this time focusing on Transactional Replication, its cons and pros and potential use cases. Also, some important announcements from Microsoft about Azure SQL! Relevant links: Data API builder General Availability (microsoft.com) Build REST API with Azure Data API Builder (DAB) (mssqltips.com) Zero ETL, Near-real time replication, Mirroring Azure SQL Databases in Fabric (microsoft.com) Announcing EAP for Vector Support in Azure SQL Database - Azure SQL Devs' Corner (microsoft.com) Update Policy for Azure SQL Managed Instance - Microsoft Community Hub Transactional Replication - SQL Server | Microsoft Learn MadeiraData/ReplicationManagementMechanism: Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures (github.com)

Bringing Microsoft Copilot to more customers worldwideMicrosoft Copilot for Security is generally available on April 1, 2024 with new capabilities - Microsoft Switzerland News CenterAI Data Drop: The 11 by 11 Tipping Point (microsoft.com)Mustafa Suleyman, DeepMind and Inflection Co-founder, joins Microsoft to lead Copilot - The Official Microsoft BlogMicrosoft pays Inflection $650 mln in licensing deal while poaching top talents, source says | ReutersGitHub Copilot in Visual Studio: A Recap of 2023Russian businesses get shut out from Microsoft cloud services at the end of this month – new EU sanctions come into effect NY Times sues OpenAI, Microsoft for infringing copyrighted works | ReutersCustomer Copyright Commitment Required Mitigations | Microsoft LearnNäkökulmia tekoälyyn, osa 2 – Riku Neuvonen: Tekijänoikeudella suojattu aineisto tekoälyn koulutuksessa - AkavaWorksRetirement notice: Azure Media Services is being retired on 30 June 2024Visual Studio App Center retirementNow available: Free data transfer out to internet when leaving Azure | Azure updates | Microsoft AzureIntroducing database watcher for Azure SQL

Niko Neugebauer and Vladimir Ivanovic are our esteemed guests for today, and they have a HUGE announcement to make about Azure SQL Managed Instances. Extra! Extra!

Let's not talk about AI, but instead let's talk about Azure SQL backup and recovery. What aspects to consider for disaster recovery? What options are available for backups in Azure SQL? How to test for recovery? Also, Jussi asks Tobi an unexpected question.(00:00) - Intro and catching up.(03:27) - Show content starts.Show links- Disaster Recovery in WAF- Disaster recovery in Azure SQL- Give us feedback!

Guy and Eitan talk about some great things about SQL Server, and mostly Guy's experience in digging into execution plans and generating synthetic IO workloads. Relevant links: What's new in SQL Server and Azure SQL 2023 Year in Review Multi-Tenancy in the Real World | Eitan Blumin (Data Weekender 6.5)  

How do you choose an Azure data storage solution? Richard talks to Nicole Stevens about her experiences helping companies move data into the cloud - typically in SQL Server. The obvious answer is Azure SQL, but that doesn't always make it the best solution! Nicole talks about a customer moving to Cosmos DB for the unstructured data capabilities and a lot of speed. But does the price make sense? All these factors are in play in choosing a data storage solution, and there is never one right choice - often, a mix of services makes the most sense!Links:Azure SQLAzure Cosmos DBAPIs in Cosmos DBAzure Table StorageAzure Queue StorageAzure Messaging Servicesdapr - Distributed Application RuntimeMicrosoft CertificationsData Architecture GuideData Landing Zones Azure Security BaselinesRecorded September 6, 2023

Benvenuti e benvenute su Azure Italia Podcast, il primo podcast su Microsoft Azure Cloud interamente in italiano! Come promesso in questo decimo episodio vi porto il primo di una serie di ospiti coi quali affronteremo varie tematiche. Per l'occasione abbiamo l'onore di ospitare Davide Mauri, Principal Product Manager per Azure SQL DB a Microsoft, col quale parleremo di database e specialmente di Azure SQL. Vi invito a seguirci passando dal nostro:Sito: ⁠⁠⁠⁠⁠azureitalia.cloud⁠⁠⁠⁠⁠ (ancora in fase di presentazione);Canale: ⁠⁠⁠⁠⁠telegram⁠⁠⁠⁠⁠;Profilo: ⁠⁠⁠⁠⁠twitter⁠⁠⁠⁠⁠;Novità: ⁠⁠⁠⁠⁠profilo LinkedIn⁠⁠⁠⁠⁠Email: ⁠⁠⁠⁠⁠azureitaliadevops@gmail.com⁠⁠⁠⁠⁠ Buy Me a coffee: ⁠⁠⁠⁠buymeacoffee.com/azureitalia⁠⁠⁠⁠ Un po' di link utili citati nell'episodio:⁠Pagina di Azure SQL Database;Azure SQL Blockchain: Ledger database vs ledger tables;Case History 1 - Deutsche Post DHL Group;Case History 2 - Hi-Rez Studios.Azure Italia Podcast ha bisogno della tua opinione! Ho creato questo piccolo sondaggio raggiungibile al seguente link. Ci vogliono solo 2 minuti ✍️

Novità del 30 agosto, è arrivata l'integrazione di ASP.NET Core nelle Azure Function, il che avvicina lo sviluppo classico web all'uso del HttpTrigger.Parleremo poi di qualcosa che mi ero perso, il SqlTrigger, per richiamare una Azure Function al cambiamento di dati in una tabella su Azure SQL.https://azure.microsoft.com/en-us/updates/public-preview-azure-sql-trigger-for-azure-functions/https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-azure-sql-triggerhttps://github.com/Azure/azure-functions-sql-extensionhttps://azure.microsoft.com/en-us/updates/generally-available-aspnet-core-integration-in-azure-functions/https://learn.microsoft.com/en-us/azure/azure-functions/dotnet-isolated-process-guide#aspnet-core-integration

In this episode, we take a lap around Microsoft Fabric. Our guest, Oskari Saarinen, a Data Platform MVP, is the expert, and we pick his brains to learn more about the capabilities. Also, Jussi asks Oskari an unexpected question. (00:00) - Intro and catching up.(02:10) - Community highlights.(03:20) - Show content starts.Community Highlights- Davide Mauri: Vector Similarity Search with Azure SQL database and OpenAI- Vinod Soni: Azure OpenAI GPT model to review Pull Requests for Azure DevOpsShow links- Oskari Heikkinen contact info- Microsoft Fabric on Microsoft Learn- Microsoft Fabric learning path- Microsoft Fabric pricing- Give us feedback!SPONSORThis episode is sponsored by Sovelto. Stay ahead of the game and advance your career with continuous learning opportunities for Azure Cloud professionals. Sovelto Eduhouse – Learning as a Lifestyle - Start Your Journey now: https://www.eduhouse.fi/cloudpro

There are a lot of technology people looking for jobs these days, especially after all the layoffs that have occurred in 2023. At the same time, I have a number of friends and clients that are struggling to hire qualified people. They get lots of candidates, but they are dismayed at how little the candidates they interview seem to know, or at least how little candidates know in the areas that their organization has needs. Today, I want to help people get better at growing and managing their careers. Therefore I'm asking those of you that are employed to describe your job. Give us your title in the comments and then list 5-10 things that you've done lately. What types of queries have you written? What tasks did you complete with SQL Server or Azure SQL? Have you needed to research something to solve a problem? What knowledge or concepts helped you complete a task?  Read the rest of What's Your Job?

The demand for effective data analytics within organizations continues to grow – how do you build your analytics team? While at SQLBits in Wales, panelists Maria Zakourdaev, Falek Miah, and Anupama Natarajan discussed their experiences with building teams - from recruiting to training, up-skilling, and retention. The discussion spans the different roles, including architects and data modelers, that help to provide the data sets analysts need. Do you train from within, hire into the role, or use consultants? There are many choices for growing your data analytics team!Links:SQLBitsRecorded March 18, 2023

On the First episode of the Xians Navigating their way through the Clouds of Azure, Anushka Dissanayake, A Senior Tech Lead from 99x alongside our Host for this series, Nishara Ramasinghe a Software Engineer at 99x Introduces you to Azure SQL Databases and Pricing models and also talks about: How to migrate the existing SQL Server to Azure SQL Single Instance or Azure SQL managed instance. Monitoring tools and a basic overview about the Azure SQL solutions currently in market. For more updates regarding our podcast episode releases, Follow us on our social media channels or Anchor.fm/99x

Our guest this week, Paul Henwood joins Kendall and Russell to talk about many different aspects of sustainability, and how Azure embraces and supports customers with their sustainability goals.   Media File: https://azpodcast.blob.core.windows.net/episodes/Episode454.mp3 YouTube: https://youtu.be/HSPeE6Hpmns Sustainability Resources: Microsoft Sustainability - Products for a Sustainable Future What is Microsoft Cloud for Sustainability? | Microsoft Learn Calculating My Carbon Footprint - Microsoft Sustainability Sustainability workload documentation - Microsoft Azure Well-Architected Framework | Microsoft Learn   Green Software Foundation | GSF Azure Update Links:   General availability: Azure Data Explorer Dashboards | Azure updates | Microsoft Azure Public Preview: Azure Communication Services Chat for Bot Framework | Azure updates | Microsoft Azure Azure SQL—General availability updates for mid-February 2023 | Azure updates | Microsoft Azure Azure Backup: Enhanced experience for creating and managing private endpoints for Recovery Services vaults is now available | Azure updates | Microsoft Azure    

Improve hybrid workloads with updates to SQL Server 2022, now generally available. Link local SQL Servers to Azure SQL Managed Instances for bidirectional disaster recovery, achieve massive speedups with differential snapshot-based backup and restore, as well as anywhere management of your SQL Servers with Azure Arc-enabled SQL provisioning, and new pay-as-you-go licensing. For raw performance, we'll demonstrate intelligent Degree of Parallelism feedback where SQL optimizes the thread count of queries automatically. Bob Ward, Principal Architect for Microsoft SQL Server, joins Jeremy Chapman to share improvements to query performance, Azure integration, and costs for both licensing and compute, local or in the cloud. ► QUICK LINKS: 00:00 - Introduction 01:01 - Backup and disaster recovery 02:31 - Failover between SQL Server and Managed Instance 05:24 - Snapshot backups 07:57 - Restore a snapshot backup 08:59 - SQL Server management: Pay-as-you-go 10:40 - SQL Server performance: Query optimizations 13:21 - Wrap up ► Link References: Start a free version of SQL Server 2022 at https://aka.ms/getsqlserver2022 Check out our free online workshop at https://aka.ms/sql2022workshop ► 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 

A glimpse into the world of end-to-end Shiny app testing with shinytest2, and an important look at the spectrum of reproducibility within R using container technology and services. Episode Links This week's curator: Batool Almarzouq - @batool664 (https://twitter.com/batool664) (Twitter) End-to-end testing with shinytest2 Part 2 (https://www.jumpingrivers.com/blog/end-to-end-testing-shinytest2-part-2/) MRAN is getting shutdown - what else is there for reproducibility with R, or why reproducibility is on a continuum? (https://www.brodrigues.co/blog/2023-01-12-repro_r/) Entire issue available at rweekly.org/2023-W02 (https://rweekly.org/2023-W02.html) Supplement Resources {leprechaun}: Code generator for lean and robust Shiny applications https://leprechaun.opifex.org Bruno's excitement for our episode on Twitter (https://twitter.com/brodriguesco/status/1615688889485897728) and Mastodon (https://fosstodon.org/@brodriguesco/109710235621904734) Looking to the future for R in Azure SQL and SQL Server https://cloudblogs.microsoft.com/sqlserver/2021/06/30/looking-to-the-future-for-r-in-azure-sql-and-sql-server/ {groundhog} Reproducible R Scripts Via Date Controlled Installing & Loading of CRAN & Git Packages https://groundhogr.com Toward practical transparent verifiable and long-term reproducible research using Guix: https://www.nature.com/articles/s41597-022-01720-9#Abs1 {scenes} demo app (https://r4dscommunity.shinyapps.io/scenes) Supporting the show Use the contact page at https://rweekly.fireside.fm/contact to send us your feedback Get a New Podcast App and send us a boost! https://podcastindex.org/apps?elements=Boostagrams%2CValue A new way to think about value: https://value4value.info Get in touch with us on social media Eric Nantz: @theRcast (https://twitter.com/theRcast) (Twitter) and @rpodcast@podcastindex.social (https://podcastindex.social/@rpodcast) (Mastodon) Mike Thomas: @mike_ketchbrook (https://twitter.com/mike_ketchbrook) (Twitter) and @mike_thomas@fosstodon.org (https://fosstodon.org/@mike_thomas) (Mastodon)

Happy New Year to all here in 2023. It's going to be a great year. It's a great time to be a programmer. A great time to be building with .NET; you are going to do great things this year. You have what it takes. You are smart, you have great tools, and you have a great team. You are a great leader. This episode is going to be all about remembering what happened this past year at the podcast.   Topics of Discussion:  [1:15] Jeffrey talks about the architect forums he's hosting and facilitating in 2023. You can register here. [1:46] Huge announcement in Microsoft Developer news including: - Android apps on Windows 11 - ARM processors getting big investments - Microsoft Dev Box — in preview — dev workstation in the cloud - Power Pages websites - Large SKU app service; up to 256GB RAM available for those who need it - Azure Arc, the new name of Hybrid Azure. And a single-node Azure Stack for remote locations but the programming model of Azure — looking forward to testing it at the right time. - Azure Container Apps tooling got better, and it became ready for prime time. Every team should be looking at this. - .NET 7 released. [4:11] What might the default application stacks and environments look like on the platform in 2023? - Windows 11 - Visual Studio 2022 w/ ReSharper - .NET 7 - Onion Architecture - Blazor for interactive applications - .NET service workers for back-end jobs and queue listeners - Entity Framework with Azure SQL — add on other storage services as per application. - Azure App Service for hosting while prototyping Azure Container Apps. - Application Insights with the Open Telemetry NuGet packages. - Azure Pipelines paired with Octopus Deploy (keep an eye on GitHub Actions as they fill out support for scenarios you need). - NordVPN for developer workstation work-from-home or remote Wi-Fi. [9:11] When it comes to developer workstations, desktop computers are still giving the most bang for the buck with power, and only a few laptops do the job really well. I have not reviewed all computers, and there are a lot out there. I can vouch for Alienware R series desktops. Liquid-cooled, so they are really quiet, even under full load. Dell Precision laptops are amazing for software engineers. I really wanted to love the Lenovo P1, but the fan was just too loud when it was under load. And we all know that cooling is so important in laptops. When a laptop gets too hot, your BIOS will slow down the processor to keep it from burning up. Then you no longer have a fast processor. And video calls use a good deal of processor, surprisingly — or not. For super mobile laptops that you can use for programming, I really do like the Microsoft Surface Laptop. I wanted to like the Surface Studio laptop, but they inverted the cooling and the battery placement, so it's very uncomfortable on my lap and my wrists unfortunately under load. The wrist wrest gets really hot. Normally the battery is under the wrist rest, but Microsoft swapped it on this one, so it's not fun using it as a laptop on your lap or even on a desk while hot and under load. [13:11] Highlighting some past episodes that will be interesting:  - Highlighting some past episodes over the year that might be interesting. - With Microsoft Orleans providing a new implementation of the Actor design pattern, we have a two-part series interview with Aaron Stannard, the creator of Akka.NET, episodes 172 and 173. - On the IoT front, Wilderness Labs has been trucking along creating system-on-a-chip options that run .NET natively and easily. I interviewed founder and CEO Bryan Costanich. - For those educating themselves for a career in software engineering, my interview with Henry Quillin might be useful. He talks about a programming internship and his education journey, his work earning his Eagle Scout, and how he became a working programmer even as he is just starting university. - More on embedded. Kevin Kirkus was with us in episode 186. He runs a testing team at Intel doing automated testing for their Xeon processor line. The design necessary for testing in this specialized environment gives us all plenty to think about. - For team leaders out there, I interviewed Mark Seemann. He wrote a recent book, Code That Fits In Your Head. He talks about the principles that are in the book. I subsequently bought and read the book, and I wish I had this book earlier in my career. Would have saved me a great deal of time. - On distributed systems, Udi Dahan is always a fascinating gentleman to listen to. Check out episode 192. As the founder and CEO of Particular Software, and the creator of NServiceBus, he is one of the world's leading experts on distributed systems, microservices, and messaging architectures. - Time-tested ideas are continually useful. I had the pleasure of interviewing Philippe Kruchten. He worked at Rational Software back when they were at the forefront of the software process in the 1990s. He published a paper outlining a framework for emergent, agile architecture. He didn't call it that. He called it the 4+1 Architecture, but only because it predated the agile manifesto. If you are an architect, and you aren't aware of this approach to architecture, give episode 195 a listen. - For the Blazor developers, I had Steve Sanderson on in episode 202. Steve is the original designer of Blazor, which has become the new default web application on .NET. He shared about the future of Blazor and WebAssembly. - Because there is so much going on in this space, Daniel Roth also joined me to discuss more Blazor Futures. - GitHub Actions is being talked about quite a bit. While loads of people are using it for builds, people are scratching their heads about where it fits in regarding deployments. Damian Brady, on the GitHub team and a former employee of Octopus Deploy, sheds light on this in episode 206. - Scott Hunter joined me in episode 211. He announced his new role at Microsoft running more of Azure development and .NET. He shared quite a bit behind the scenes regarding Microsoft's strategy there. - For the UX people. Mark Miller is the Chief Architect of DevExpress, the big UI components company. He has a brilliant user experience mind, and I was able to get him talking in episode 212. - Telemetry. We all need it to keep our software stable in production. The Serilog and AutoFac maintainer, Nicholas Blumhardt, joined me to discuss the fundamentals of modern logging and telemetry. Check out episode 217 for that. - More on the testing front, Eduardo Maltez, a software engineer doing some really interesting full system test work shares his thoughts on what makes tests reliable, stable, and fast — and how to fight brittle tests. Episode 224. - We closed out the year on the security front. With LastPass getting hacked and now Rackspace having a hacking-induced major outage, we all need to take action. Troy Vinson, a multi-certified security professional and certified ethical hacker, gave his perspective on the Rackspace breach and what every .NET team should learn from it.   Mentioned in this Episode: Architect Tips — New video podcast! Azure DevOps Clear Measure (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's YouTube Jeffrey Palermo's Twitter — Follow to stay informed about future events! Programming with Palermo programming@palermo.network   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

Guy and Eitan finally celebrate the generally available release of SQL Server 2022! And also discuss other announcements from PASS Data Community Summit, and also various interesting news and features of Azure SQL announced in November 2022. Relevant links: SQL Server 2022 is now generally available Consumption-based PAYG billing model for SQL Server 2022 on-prem PASS Data Community Summit Hug a DBA song by Killa DBA SQL Server 2022 song by Killa DBA The SQL Server Native Client has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server or the latest Microsoft ODBC Driver for SQL Server going forward. Mid-November 2022 Public Preview updates to Azure SQL Azure SQL database external REST endpoints integration in public preview Mid-November 2022 General Availability updates to Azure SQL Public Preview Azure SQL Managed Instance feature wave for November 2022 General Availability Azure SQL Managed Instance feature wave for November 2022 Learn more about the November 2022 Feature Wave for Azure SQL Managed Instance Azure SQL - General availability updates for late November 2022 Azure SQL - Public preview updates for late November 2022 DR Secondary licensing is free with Azure VM and SQL Managed Instance in PAYG model

Jeff Fritz is an experienced developer, technical educator, and PM on the .NET team at Microsoft. He founded The Live Coders team on Twitch, and regularly livestreams builds of websites and fun applications. You can follow Jeff for more .NET, .NET Core, and Visual Studio content on Twitch and Twitter at @csharpfritz.   Topics of Discussion: [2:41] Jeff talks about surviving the .com bomb and his background as a longtime web developer and technical educator. [3:57] What have been some of the recent developments that Jeff and his team are most excited about at Microsoft? [5:45] Jeff talks about how the application has been growing and how he's had some bumps in the road. [7:40] How to make video clips searchable and discoverable on the web. [12:12] What made Jeff go for MySQL instead of serverless Azure SQL? [18:01] What's the duration of the journey from the first line of code to enterprise patterns? [21:09] As we grow applications, we need to figure out a better way to show people what happens when you make a mistake, and to help them through the growth. [27:13] How do you know what's going to happen at a certain level of production? [22:48] Does Jeff really believe we're going to end up at Kubernetes? [32:27] Re-architecting your database architecture.   Mentioned in this Episode: Architect Tips — New video podcast! Azure DevOps Clear Measure (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's YouTube Jeffrey Palermo's Twitter — Follow to stay informed about future events! Programming with Palermo programming@palermo.network Jeff on Twitch KlipTok Fritz's Tech Tips and Chatter   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

What can SQL 2022 do for you? Richard chats with Bob Ward about the upcoming release of SQL Server 2022 and its evolution toward data anywhere. Bob talks about running SQL on edge devices, on-premises, in containers, virtual machines, and, of course, in the cloud. The management tools like Azure Arc make it easy to take care of all the places your SQL data can now live - and let you be the data administrator you can be! Check out Bob's latest book on SQL Server 2022 and all its hybrid data capabilities!Links:SQL Server 2022SQL Server 2022 RevealedMicrosoft PurviewAzure Role-Based Access ControlAzure Data LakesAzure Arc-Enabled SQL Managed InstanceAzure SQL Managed InstanceMicrosoft Intelligent Data PlatformSQL Server 2022 PreviewRecorded October 26, 2022

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  

In this episode, Josh Bregman discusses a critically important feature in MDE - Tamper Protection which helps prevent unwanted changes to your security and essential functions.We also cover the latest security news about Synapse SQL, Service Bus, Storage, Redis, Azure SQL, MySQL, AKS, Managed Disks and Microsoft Defender.

Show Notes Whether it's summer or winter where you live, one thing is for certain - it's the season of .NET MAUI! Tune in for the latest and greatest in Azure, Visual Studio, and .NET MAUI news. New releases .NET Community Toolkit 8.0 (https://devblogs.microsoft.com/dotnet/announcing-the-dotnet-community-toolkit-800/?WT.mc_id= dotnet-70280-masoucou) Visual Studio 17.3 (https://devblogs.microsoft.com/visualstudio/visual-studio-2022-17-3-is-now-available/?WT.mc_id= dotnet-70280-masoucou) Visual Studio Mac 17.3 (https://devblogs.microsoft.com/visualstudio/visual-studio-for-mac-17-3-is-now-available/?WT.mc_id= dotnet-70280-masoucou) Visual Studio 17.4 Preview 1 (https://devblogs.microsoft.com/visualstudio/visual-studio-2022-17-4-preview-1/?WT.mc_id= dotnet-70280-masoucou) Latest News .NET MAUI – Learn Live! (https://docs.microsoft.com/events/learn-events/learnlive-mobile-desktop-apps-dotnet-maui/?WT.mc_id= dotnet-70280-masoucou) .NET Conf – Focus on MAUI recap (https://devblogs.microsoft.com/dotnet/dotnet-conf-focus-on-maui-recap/?WT.mc_id= dotnet-70280-masoucou) .NET MAUI Beautiful UI Challenge (https://devblogs.microsoft.com/dotnet/announcing-dotnet-maui-beautiful-ui-challenge/?WT.mc_id= dotnet-70280-masoucou) Local events (https://dev.to/dotnet/local-net-maui-events-happening-around-the-world-2h8i) .NET MAUI Cloud Skills Challenge (https://aka.ms/maui/cloudchallenge) Azure News Azure SQL temporal tables (https://docs.microsoft.com/en-us/shows/azure-friday/azure-sql-database-an-introduction-to-temporal-tables/?WT.mc_id= dotnet-70280-masoucou) Azure SQL multi-model (https://docs.microsoft.com/en-us/shows/azure-friday/azure-sql-database-multi-model-features/?WT.mc_id= dotnet-70280-masoucou) Azure Service of the Month Azure SignalR (https://docs.microsoft.com/en-us/azure/azure-signalr/?WT.mc_id= dotnet-70280-masoucou) Pick of the Pod MapsUI (https://mapsui.com) Point of Sale print (https://github.com/Bliitze/PointOfSale/blob/master/PointOfSale/Helpers/PosPrint.cs) SunmiV2MAUI (https://github.com/exendahal/SunmiV2MAUI/tree/master/SunmiV2MAUI) Follow Us: * James: Twitter (https://twitter.com/jamesmontemagno), Blog (https://montemagno.com), GitHub (http://github.com/jamesmontemagno), Merge Conflict Podcast (http://mergeconflict.fm) * Matt: Twitter (https://twitter.com/codemillmatt), Blog (https://codemilltech.com), GitHub (https://github.com/codemillmatt) * David: Twitter (https://twitter.com/davidortinau), Github (https://github.com/davidortinau)

Microsoft wants more people to move their database workloads to Azure. They are constantly adding new features, capabilities, even tools to help people move databases to some part of Azure. It's working well, as the latest quarterly report shows tremendous growth in Azure revenue. We don't know precisely how SQL Server or Azure SQL databases impact this, but I certainly see more and more customers moving relational workloads to the cloud. Some to Azure, some to other providers. In an effort to entice people, Microsoft has a promotion that they were running in March, which was asking SQL Server 2012 customers to move to Azure and save with free extended security updates. They reiterated the promotion on July 12, when SQL Server 2012 went out of support. They calculate savings and promote benefits, which might be tangible and desirable to some of you. After all, not having a supported platform isn't an option for some people. Read the rest of The Azure Carrot

121. What's it like trying to manage 10 Microsoft 365 tenants with hundreds of environments, apps and citizen developers. Rene Modery, Power Platform Technical Lead shares his journey at global advertising company, WPP. Managing ten Microsoft 365 tenants for a global company with hundreds of subsidiaries.Power Platform environment policies and other guard rails to help makers.How do you know what apps have already been built and what problems have already been solved within a large organisation so that makers don't reinvent the wheel?Which data sources and connectors are proving to be the most popular in your Power Platform environments? SharePoint, Microsoft Lists, Excel, Azure SQL, Dataverse?Why Rene is not ready to ask makers to standardise on Dataverse quite yet.How the new Fluent UI controls will help app makers build apps that are better looking and more useful.If Rene could direct the Microsoft product teams to improve one thing, it would be...licensing!And he'd love to see some of the Center of Excellence features brought into the Power Platform Admin Center too.  And in person events are returning to the Power Platform user groups in Singapore.ResourcesRene Modery on TwitterRene Modery on LinkedInRene's book, Hands-On Microsoft ListsSingapore Power Platform User GroupSupport the show

In this episode Michael talks to Sravani Saluru who is a Senior Program Manager in the Azure Data Platform, about Azure SQL Managed Instance and Windows authentication support which is in preview. We talk about where SQL MI fits in the SQL family, as well as how to configure SQL MI so your one-prem client can access SQL MI in Azure seamlessly.

Datamart is a new self-service capability included with Power BI Premium that reduces the time it takes to do custom departmental reporting, from weeks to minutes. In just a few clicks, both business users and analysts can easily create and access their own mix of data from dozens of the most common data types and services, all backed by Azure SQL that brings elastic scale and ad-hoc analysis to Power BI. Charles Webb, from the data team at Microsoft, joins Jeremy Chapman to show you a Datamart in action. ► QUICK LINKS: 00:00 - Introduction 00:43 - What changes with Datamart? 02:21 - See Datamart in action 05:34 - Analyst experience 06:32 - Complex requests 09:24 - Pull Data with T-SQL 12:01 - Where to get started ► Link References: For more guidance, check out https://aka.ms/DatamartDocs ► 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. ► 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

In Las Vegas, once again, this is the Q&A session from the SQL Server & Azure SQL Conference in April 2022. Richard moderated questions and answers from SQL luminaries, including Bob Ward, Buck Woody, Pam Lahoud, Bradley Ball, Des Fitzgerald, Davide Mauri, Rie Merritt, and Kevin Farlee. The conversation ranges over Azure SQL migration, new features in SQL Server 2022, challenges in scaling, reliability, disaster recovery, and more!Links:SQL Server and Azure SQL ConferenceRecorded April 7, 2022

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/      

Justin Mourfield, PM in CXP (Customer Experience Program) comes on the Azure Podcast and spoke to the team about dangling domains, the danger, the consequences of subdomain takeover, and some short- and long-term steps Microsoft is taking to help address these concerns. Media File: https://azpodcast.blob.core.windows.net/episodes/Episode375.mp3 YouTube: Episode 375 - The Case of the Dangling Domain - YouTube Resources:  Prevent subdomain takeovers with Azure DNS alias records and Azure App Service's custom domain verification Azure-Network-Security/Cross Product/DNS - Find Dangling DNS Records at master Updates: An invitation to innovate and transform your business on Azure SQL  Upgrade your infrastructure with the latest Dv5/Ev5 Azure VMs in preview Register for Build

The team meets with recurring guest Bob Ward and meet a new one, Anna Hoffman, to talk about their Learn Azure SQL video series. Media file: https://azpodcast.blob.core.windows.net/episodes/Episode369.mp3 Resources: https://aka.ms/azuresqlyt --> Data Exposed / Data Exposed Live / Azure SQL 61 video serieshttps://aka.ms/azuresqlbook --> Azure SQL Revealedhttps://aka.ms/azuresqlfordevelopers --> Practical Azure SQL Database for Modern Developershttps://aka.ms/learnliveazuresqlfundamentals --> Learn Live Azure SQL Fundamentals (6 week live series)https://aka.ms/azuresqlfundamentals --> Learning Path on Microsoft Learn with free hands on exercises YouTube Video: https://youtu.be/I42ikJ1IfU8 Other updates: Our commitment to expand Azure Availability Zones to more regions (https://azure.microsoft.com/en-gb/blog/our-commitment-to-expand-azure-availability-zones-to-more-regions/) Limited-time free quantities offer for Azure Synapse Analyticshttps://azure.microsoft.com/en-us/blog/limited-time-free-quantities-offer-for-azure-synapse-analytics/Do more for the National Security mission with Azurehttps://azure.microsoft.com/en-us/blog/do-more-for-the-national-security-mission-with-azure/  

Five years after his last appearance, Gaurav Malhotra comes back to talk to the team about his current work with Azure Purview. Media File: https://azpodcast.blob.core.windows.net/episodes/Episode366.mp3 Other Resources: Azure Purview Overview Azure Purview Docs Azure Purview Feedback Azure Purview blog on Tech Community Azure Purview discussion on Tech Community Updates: Apache Spark Connector for SQL Server and Azure SQL now compatible with Spark 3.0 Customers unify hybrid and multicloud IT operations with Azure Arc Future-proof your network with Azure for Operators Microsoft will establish its next U.S. datacenter region in Georgia’s Fulton and Douglas Counties Public preview: Application Insights work item integration for Azure DevOps & GitHub    

Lots of new stuff to talk about this month! Ever want to get down to the nitty gritty and do some drawing in Xamarin.Forms! Well, now in Xamarin.Forms 4.8 you can! James and Matt discuss all the ins and outs of brushes, gradients and shapes and how you can implement them in your Xamarin.Forms app. There's also new releases for Visual Studio and Visual Studio for Mac. Find out about how you can make your .NET meetups shine - and attend some new ones too. And tell us all about your experience about Entity Framework and Xamarin. And of course, the Azure Service of the Month and Pick of the Pod! Show Notes New Releases Xamarin.Forms 4.8 (https://devblogs.microsoft.com/xamarin/xamarinforms-4-8-gradients-brushes/?WT.mc_id=xamarinpodcast76-podcast-masoucou) Visual Studio 2019 v16.7 (https://devblogs.microsoft.com/visualstudio/visual-studio-2019-v16-7-releases/?WT.mc_id=xamarinpodcast76-podcast-masoucou) Visual Studio for Mac (https://devblogs.microsoft.com/visualstudio/visual-studio-2019-for-mac-version-8-7-is-now-available/?WT.mc_id=xamarinpodcast76-podcast-masoucou) Twitch Visual Studio channel (https://www.twitch.tv/visualstudio) Latest News Multi-lingual support in Xamarin.Forms (https://devblogs.microsoft.com/xamarin/mastering-multilingual-in-xamarin-forms/?WT.mc_id=xamarinpodcast76-podcast-masoucou) Drawing your user interface in Xamarin.Forms with shapes and paths (https://devblogs.microsoft.com/xamarin/xamarin-forms-shapes-and-paths/?WT.mc_id=xamarinpodcast76-podcast-masoucou) A Dev Story: College Diary with Xamarin.Forms (https://devblogs.microsoft.com/xamarin/college-diary-xamarin-theodora-tataru/?WT.mc_id=xamarinpodcast76-podcast-masoucou) Meetup resources, presentations and workshops (https://dotnetfoundation.org/community/meetups) .NET Foundation virtual user groups (https://dotnetfoundation.org/community/virtual-user-group) .NET Conf Focus on Microservices (https://channel9.msdn.com/Events/dotnetConf/Focus-on-Microservices?WT.mc_id=xamarinpodcast76-podcast-masoucou) Azure News Quick start with Xamarin.Forms and Entity Framework (https://docs.microsoft.com/ef/core/get-started/xamarin?WT.mc_id=xamarinpodcast76-podcast-masoucou) 61 videos of beginner Azure SQL content (https://channel9.msdn.com/Series/Azure-SQL-for-Beginners?WT.mc_id=xamarinpodcast76-podcast-masoucou) Azure Service of the Month Azure App Configuration (https://docs.microsoft.com/azure/azure-app-configuration/overview?WT.mc_id=xamarinpodcast76-podcast-masoucou) Pick of the Pod! Matt: Microsoft.Identity.Web (https://github.com/AzureAD/microsoft-identity-web/wiki) James: PancakeView v2 (https://github.com/sthewissen/Xamarin.Forms.PancakeView) As always, get yourself some free Azure here (https://azure.microsoft.com/free?WT.mc_id=xamarinpodcast76-podcast-masoucou)! Follow Us: * James: Twitter (https://twitter.com/jamesmontemagno), Blog (https://montemagno.com), GitHub (http://github.com/jamesmontemagno), Merge Conflict Podcast (http://mergeconflict.fm) * Matt: Twitter (https://twitter.com/codemillmatt), Blog (https://codemilltech.com), GitHub (https://github.com/codemillmatt)

Xamarin.Forms 4.7 is out and the Inverter Converter is all the rage!! ... well ... multi-value bindings are all the rage - but that doesn't have quite the ring of Inverter Converter. This month James and Matt run down the rest of the great features in Xamarin.Forms 4.7 including how it helps you manage light and dark themes, eliminates the need for James' image circle plug-in, and makes writing Grid row and column definitions so, so, so much easier. Tune in to hear about some new requirements for submitting Android 10 apps to the Google Play store and get some quick tips on implementing back navigation with Xamarin.Forms Shell too! Plus - get your blog featured on an upcoming podcast by registering your blog with Planet Xamarin today! And of course, the Azure Service of the Month and Pick of the Pod! Show Notes Register your blog on Planet Xamarin (https://www.planetxamarin.com) New Releases Xamarin.Forms 4.7 new features (https://devblogs.microsoft.com/xamarin/xamarin-forms-4-7/?WT.mc_id=xamarinpodcast75-podcast-masoucou) Xamarin.Forms multi-bindings (https://docs.microsoft.com/xamarin/xamarin-forms/app-fundamentals/data-binding/multibinding?WT.mc_id=xamarinpodcast75-podcast-masoucou) Android 10 requirements (https://devblogs.microsoft.com/xamarin/android-10-requirements/?WT.mc_id=xamarinpodcast75-podcast-masoucou) Latest News Shell Quick Tip: Back navigation (https://devblogs.microsoft.com/xamarin/xamarin-forms-shell-back-navigation/?WT.mc_id=xamarinpodcast75-podcast-masoucou) Azure News Azure SQL is the best database for developers (https://devblogs.microsoft.com/azure-sql/10-reasons-to-use-azure-sql-in-your-next-project/?WT.mc_id=xamarinpodcast75-podcast-masoucou) Azure SQL is the best on Data Exposed (https://channel9.msdn.com/Shows/Data-Exposed/Why-Azure-SQL-is-Best-For-Developers-Part-1?WT.mc_id=xamarinpodcast75-podcast-masoucou) Azure Service of the Month Azure Custom Vision Service (https://azure.microsoft.com/services/cognitive-services/custom-vision-service/?WT.mc_id=xamarinpodcast75-podcast-masoucou) Power Automate (https://docs.microsoft.com/power-automate/getting-started?WT.mc_id=xamarinpodcast75-podcast-masoucou) Pick of the Pod! Matt: Fluent design system icons (https://github.com/microsoft/fluentui-system-icons) James: Sharpnado (https://www.nuget.org/packages/Sharpnado.Presentation.Forms/) As always, get yourself some free Azure here (https://azure.microsoft.com/free?WT.mc_id=xamarinpodcast75-podcast-masoucou)! Follow Us: * James: Twitter (https://twitter.com/jamesmontemagno), Blog (https://montemagno.com), GitHub (http://github.com/jamesmontemagno), Merge Conflict Podcast (http://mergeconflict.fm) * Matt: Twitter (https://twitter.com/codemillmatt), Blog (https://codemilltech.com), GitHub (https://github.com/codemillmatt)

Hope everybody is staying healthy! We have lots of news and new releases to cover this month for you! Xamarin.Essentials and Xamarin.Forms have new releases. And the Xamarin engineering team was hard at work to get a cross-platform API out for the new contact tracing API from Apple and Google. James and Matt also talk about //Build, a couple of cool new case studies, and recap the wackiness of the Crazy Cognitive Service Combo Challenge! And of course, the Azure Service of the Month and Pick of the Pod! Show Notes Latest Releases Xamarin.Essentials 1.6 is on the loose (https://devblogs.microsoft.com/xamarin/xamarin-essentials-now-with-permissions-app-theme-authentication?WT.mc_id=xamarinpodcast73-podcast-masoucou) Xamarin.Forms 4.6 brand new features (https://devblogs.microsoft.com/xamarin/xamarin-forms-4-6?WT.mc_id=xamarinpodcast73-podcast-masoucou) Find out about the new Contact Tracing API (https://devblogs.microsoft.com/xamarin/contact-tracing-exposure-notification-api?WT.mc_id=xamarinpodcast73-podcast-masoucou) Events Register for //Build now! (https://register.build.microsoft.com/?WT.mc_id=xamarinpodcast73-podcast-masoucou) Xamarin News Crazy Cognitive Services Combo Challenge Wrap-Up (https://devblogs.microsoft.com/xamarin/cognitive-services-xamarin-challenge?WT.mc_id=xamarinpodcast73-podcast-masoucou) Volotea + PGS Software Case Study (https://devblogs.microsoft.com/xamarin/volotea-pgs-software-xamarin-showcase/?WT.mc_id=xamarinpodcast73-podcast-masoucou) Changesets with Azure SQL (https://devblogs.microsoft.com/xamarin/azure-sql-change-tracking-data-sync/?WT.mc_id=xamarinpodcast73-podcast-masoucou) Magic Gradients ... with animated gradients! (https://devblogs.microsoft.com/xamarin/magic-gradients-xamarinforms/?WT.mc_id=xamarinpodcast73-podcast-masoucou) Azure News Brokered Auth in MSAL.NET (https://developer.microsoft.com/identity/blogs/announcing-xamarin-broker-support-in-msal-net-4-9-0/?WT.mc_id=xamarinpodcast73-podcast-masoucou) Azure Cosmos DB and Minecraft World Case Study (https://azure.microsoft.com/en-us/blog/minecraft-earth-and-azure-cosmos-db-part-1-extending-minecraft-into-our-real-world/) Azure Service of the Month Azure Maps (https://docs.microsoft.com/azure/azure-maps/about-azure-maps?WT.mc_id=xamarinpodcast73-podcast-masoucou) Pick of the Pod! Matt - Material Frame with Blur (https://www.sharpnado.com/materialframe-blur) James - Azure Table Storage (https://docs.microsoft.com/azure/storage/tables/table-storage-overview?WT.mc_id=xamarinpodcast73-podcast-masoucou) As always, get yourself some free Azure here (https://azure.microsoft.com/free?WT.mc_id=xamarinpodcast73-podcast-masoucou)! Follow Us: * James: Twitter (https://twitter.com/jamesmontemagno), Blog (https://montemagno.com), GitHub (http://github.com/jamesmontemagno), Merge Conflict Podcast (http://mergeconflict.fm) * Matt: Twitter (https://twitter.com/codemillmatt), Blog (https://codemilltech.com), GitHub (https://github.com/codemillmatt)

Gaurav Malhotra joins Scott Hanselman to show how to build a modern data warehouse solution from ingress of structured, unstructured, semi-structured data to code-free data transformation at scale and finally to extracting business insights into your Azure SQL Data Warehouse.Jump To: [01:21] Demo Start Azure Data Factory overviewAzure SQL Data Warehouse overviewAzure Data Factory docsAzure SQL Data Warehouse docsCreate a free accont (Azure)

Gaurav Malhotra joins Scott Hanselman to show how to build a modern data warehouse solution from ingress of structured, unstructured, semi-structured data to code-free data transformation at scale and finally to extracting business insights into your Azure SQL Data Warehouse.Jump To: [01:21] Demo Start Azure Data Factory overviewAzure SQL Data Warehouse overviewAzure Data Factory docsAzure SQL Data Warehouse docsCreate a free accont (Azure)

Ron Ortloff talks with Scott Hanselman about the new Azure SQL Data Warehouse compute optimized tier that enables you to analyze ever growing amounts of data more easily, and how the team used NVM Express caching for up to 100x better performance.Azure SQL Data Warehouse previews 3x compute scale with unlimited columnar storage (blog)Faster compute optimized performance tier for Azure SQL Data Warehouse (blog)Azure SQL Data Warehouse performance tiers (Preview) (docs)Create a Free Account (Azure)Follow @SHanselman Follow @AzureFriday Follow @RonOrtloff