Data Exposed - Channel 9

Jan 14 2021 13 mins 41

Data Exposed is all about data; relational and non-relational, on-premises and in the cloud, big and small. Get the inside scoop and join us as we demonstrate features, discuss the latest news and share our love for data technology including SQL Server, Azure Data Services like SQL DB, Cosmos DB, SQL DW, Data Factory, Databricks and more!
















The A to S of Azure Data Studio
Dec 22 2020 24 mins  
With Azure Data Studio turning/turned 3, it is maturing just like a fine wine. Azure Data Studio is a game-changer for all Data Professionals. Join Warwick Rudd as he shows you what Azure Data Studio has for Data Professionals and why it makes it easier for you to do your job. [00:35] About Warwick Rudd[01:40] Azure Data Studio overview[03:20] Azure Data Studio demo[10:32] Notebooks demo[18:50] New project demo[22:34] Exporting demoResources:Azure Data Studio Blog About Warwick Rudd:Warwick Rudd is a Data Platform MVP, Microsoft Certified Master, Founder and Principal Consultant at SQL Master Consulting. With 20+ years of experience beginning with the release of SQL Server 6.5, he has worked in both Australia and England from small start-ups to Multi-National Corporations. He hosts the PASS DBA Fundamentals Downunder Virtual Chapter, Organises the PASS SQL Saturday Brisbane event and has spoken at many SQL Server User Groups & SQL Saturday events globally. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.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 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 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: https://aka.ms/mvpprogram









How to Automate Disaster Recovery in SQL Server On-Prem
Dec 08 2020 19 mins  
Are you prepared if a tornado filled with sharks destroys your primary data center? You may have backed up your databases, but what about logins, agent jobs or extended events? Join Chrissy LeMaire in this episode of Data Exposed as she demos how disaster recovery can be simplified using the SQL Community's SQL Server PowerShell module, dbatools. [01:40] Key definitions[02:55] Why Disaster Recovery[03:50] SQL Server-specific database disaster recovery[04:35] Scenarios[05:45] SQL Server-specific disaster recovery[06:43] dbatools[07:50] How to get help[08:40] Demo[17:38] Getting started Resources:dbatoolsSimplifying Disaster Recovery with dbatoolsAbout Chrissy LeMaire:Chrissy is a Cloud and Datacenter Management & Data Platform MVP who has worked in IT for over 20 years. She is the creator of the popular SQL PowerShell module dbatools, holds a master's degree in Systems Engineering and is coauthor of Learn dbatools in a Month of Lunches. 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 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 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: https://aka.ms/mvpprogram









Azure SQL Database: Improving Performance Tuning with Automatic Tuning
Nov 24 2020 8 mins  
One of the performance benefits of using Azure SQL Database is the ability for Azure SQL Database to automatically add and remove indexes from the database, based on the workload that is running against the database. Join Denny Cherry as he shows you how to enable automatic tuning and when it won't help you as much as you think that it will.[01:25] Automatic tuning features[03:08] Indexes[03:40] Automatic tuning demo[04:40] When to use this feature[06:30] What indexes should be made Resources:Enable automatic tuning in the Azure portalEmail notifications for automatic tuningFind and apply performance recommendations About Denny Cherry:Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny's areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award. 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 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 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 m









Leveling Up Your Azure SQL Database Deployments
Nov 10 2020 10 mins  
The Basic, Standard, and Premium service tiers fulfill a lot of customers' needs. For some customers, though, the General Purpose, Business Critical, and Hyperscale service tiers offer additional performance and ability that is required for certain workloads. Even if you don't require those abilities, the technology and infrastructure behind these are worth learning about! In this episode with Matt Gordon, we'll discuss those service tiers as well as discussing the differences between Provisioned and Serverless deployments on the General Purpose tier. Come learn how to ramp up your Azure SQL Database experience! [00:45] vCore tier[01:20] General Purpose[02:04] Serverless[04:42] Hyperscale[05:56] Business Critical[08:30] Determining the right tier Resources:Creating Your First Azure SQL Database About Matt Gordon:Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.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 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








Creating Your First Azure SQL Database
Oct 27 2020 9 mins  
You need to ensure that you are getting the maximum value and performance from your Azure SQL Database for minimum cost. Learn the differences between the Basic, Standard, and Premium tiers of Azure SQL Single Database. Provisioning is one component of maximizing the value of your deployment - licensing is another. In this episode with Matt Gordon, we'll walk through the differences between licensing by DTU and by vCore and talk about what may be right for you and your needs. [01:37] What is a DTU[02:27] DTU options[03:32] Basic tier[03:53] Standard tier[05:42] Premium tier[07:13] Determining tiers Resources:What the heck is a dtu? About Matt Gordon:Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.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 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 quest f









No review available yet...