Query store hints enables changing query plan shapes without modifying application code. In this episode of Data Exposed with Denzil Ribeiro, we will look at an example of improving the performance of bulk loading data using query store hints. [00:30] Introduction Denzil Ribeiro[01:40] Memory Grants Overview [02:49] Demo[13:05] Getting Started Resources:Performance impact of memory grants on data loads into Columnstore tables
Sayed Hashimi, PM on the ASP.NET team, shows us how Visual Studio 2022 offers a new experience for building Web Forms projects. He shows the new Web Forms designer and Web Live Preview, which enables you to see changes reflected live in your running app. Check out this Visual Studio blog post to learn more.
April Edwards and Christopher Maneu are back for part two of this four-part series, Infra as Code in Action! Today, they'll be talking about secrets management! Is it really important to keep secrets? Yes! And there's more to it than keeping secrets including auditing and key rotation. Chris will demo zero-code change secured credentials with Infra as Code and talk about how NubesGen helps with secret management. Jump to:[00:52] Why think about Secrets management?[03:10] How to add Secrets management with NubesGen[07:40] Easy Secrets rotation Learn more:Secrets https://aka.ms/DevOpsLab/IaCSecretsTemplates https://aka.ms/DevOpsLab/IaCTemplatesTwelve factor config https://12factor.net/configNubesGen https://www.nubesgen.comGithub NubesGen https://github.com/microsoft/nubesgen Don't miss an episode https://aka.ms/AzDevOpsYouTubeChannel 9 https://aka.ms/TheDevOpsLab Follow April https://twitter.com/TheAprilEdwardsFollow Chris https://twitter.com/cmaneuCreate a Free Azure DevOps Account https://aka.ms/AA7uopu
Yuan Zheng joins Scott Hanselman to discuss and demonstrate Blob storage support for the NFS 3.0 protocol, which enables you to run your applications on a single storage platform. With no application rewrites necessary you will also help eliminate data silos.[0:00:00]– Introduction[0:02:00]– Overview of NFS v3[0:04:42]– Demo: Enabling NFSv3 in your Storage account[0:05:49]– Demo: Secure access using virtual networks[0:07:20]– Demo: Blob storage compatibility with VMs using NFS v3[0:09:12]– Demo: Writing to Blob storage from within a VM[0:12:45]– Wrap-upModernize large-scale NFS workloads and eliminate data silos with Azure Blob StorageNetwork File System (NFS) 3.0 protocol support in Azure Blob StorageAzure Blob Storage overviewConfigure blob storage – Microsoft Learn moduleCreate a free account (Azure)
It is important to ensure that your Azure Virtual Machine is meeting the performance and stability standards you have established in your organization. PerfInsights can help identify and report on your Azure SQL VM health and provide references to how administrators can mitigate the risks. PerfInsights is a self-help diagnostics tool that can be run through the portal or as a standalone tool that collects diagnostic data, produces analytic reporting, summarizes system information, and produces a system log output that can help troubleshoot virtual machine performance problems in Azure for various scenarios including SQL Server, Windows OS, Linux, Azure storage, and more. PerfInsights allows administrators to run quick analysis, produce a benchmark result, analyze slow virtual machines, analyze Azure files, and perform advanced scenarios including xperf, network tracing, storport tracing, perf counter traces, and diskspeed benchmarks. In part five of this seven-part series, we will analyze PerfInsights captures to review SQL Server findings, review storage analysis against Azure storage thresholds, resource reporting, and will review the system summary information that can make it a lot easier to document your Azure SQL Virtual Machine environment. [00:58] PerfInsights Overview[02:20] Demo[15:48] Getting started Resources:Advanced performance analysis: https://aka.ms/perfinsights/advancedAzure Files analysis: https://aka.ms/perfinsights/azurefilesQuick performance analysis: https://aka.ms/perfinsights/quickPerformance analysis: https://aka.ms/perfinsights/vmslowBPCheck - SQL Best Practices and Performance checks: http://aka.ms/BPCheckPremium storage disk sizes: https://docs.microsoft.com/en-us/azure/virtual-machines/premium-storage-performance#premium-storage-disk-sizesAzure SQL Virtual Machine Reimagined Series: https://aka.ms/azuresqlvmyt
As database professionals, we all know how to manage SQL Server Agent jobs using SQL Server Management Studio (SSMS), TSQL, and PowerShell. With Azure Data Studio and SQL Server Agent extension, we have new tools to create, maintain and manage SQL Agent jobs using Notebook. These are called Notebook Jobs. Once you successfully execute a Notebook job manually or via schedule, each run's results are saved into a separate Notebook, which you can easily share with others. In this episode of Data Exposed: MVP Edition, Taiob Ali will walk you through every step of Notebook Jobs.[00:31] About Taiob Ali[01:34] Benefits of SQL Server Agent Jobs[04:50] Demo[T012:30] Getting StartedResources:Github About Taiob Ali:Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 15 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience managing large database projects, including massive data migration, intricate process design, testing and deployment, performance tuning, and long-term capacity planning. Taiob is currently working at "GMO LLC" as Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, founder of 'Database Professionals Virtual Meetup Group', and organizer of Boston Data Saturday.About MVPs:Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have a very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products, and solutions, to solve real-world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and the quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more.
The DevOps Lab is back with host April Edwards. On the show today, April welcomes Christopher Maneu for Episode one of this four-part series, Infra as Code in Action! DevOps practitioners get a practical example of how to implement naming convention with Bicep. Checkout NubesGen and MS Docs: Why naming conventions are important, how to implement it with bicep, how to do it in 1 minute with NubesGen! Jump to:[01:40] What is NubesGen?[04:15] Why defining naming conventions is important[06:00] Defining convention in infrastructure as code Learn more:Define your naming convention https://aka.ms/DevOpsLab/IaC/NamingConvention ARM templates https://aka.ms/DevOpsLab/IaC/BicepARM NubesGen https://aka.ms/nubesgen Azure DevOps Docs https://aka.ms/AzureDevOps/DocsAzure DevOps YouTube https://aka.ms/AzDevOpsYouTubeFollow April https://twitter.com/TheAprilEdwardsFollow Chris https://twitter.com/cmaneuCreate a Free Azure DevOps Account https://aka.ms/AA7uopu
Delbert Murphy joins Scott Hanselman to show how quantum-inspired algorithms mimic quantum physics to solve difficult optimization problems. Quantum-Inspired Optimization (QIO) takes state-of-the-art algorithmic techniques from quantum physics and makes these capabilities available in Azure on conventional hardware, and callable from a Python client. You can use QIO to solve problems with hundreds of thousands of variables, combined into millions of terms, in a few minutes, with this easy-to-consume Azure service.[0:00:00]– Introduction [0:00:40]– What problems can you solve with quantum-inspired optimization?[0:05:35]– A concrete example: Secret Santa[0:08:52]– Demo, Part I: Solving Secret Santa with QIO[0:17:58]– Demo, Part II: Running the code[0:21:12]– Quantum-inspired algorithms[0:24:33]– Wrap-up Solve optimization problems by using quantum-inspired optimizationWhat are quantum-inspired algorithms?Ising formulations of many NP problems (Cornell University)A Tutorial on Formulating and Using QUBO Models (Cornell University)Sample code: delbert/secret-santa (GitHub)Azure Quantum optimization service samples (GitHub)Create a free account (Azure)
