TopPodcast.com
Menu
  • Home
  • Top Charts
  • Top Networks
  • Top Apps
  • Top Independents
  • Top Podfluencers
  • Top Picks
    • Top Business Podcasts
    • Top True Crime Podcasts
    • Top Finance Podcasts
    • Top Comedy Podcasts
    • Top Music Podcasts
    • Top Womens Podcasts
    • Top Kids Podcasts
    • Top Sports Podcasts
    • Top News Podcasts
    • Top Tech Podcasts
    • Top Crypto Podcasts
    • Top Entrepreneurial Podcasts
    • Top Fantasy Sports Podcasts
    • Top Political Podcasts
    • Top Science Podcasts
    • Top Self Help Podcasts
    • Top Sports Betting Podcasts
    • Top Stocks Podcasts
  • Podcast News
  • About Us
  • Podcast Advertising
  • Contact
Not in our directory?
Add Show Here
Podcast Equipment
Center

toppodcastlogoOur TOPPODCAST Picks

  • Comedy
  • Crypto
  • Sports
  • News
  • Politics
  • True Crime
  • Business
  • Finance

Follow Us

toppodcastlogoStay Connected

    View Top 200 Chart
    Back to Rankings Page
    Technology

    Data Exposed – Channel 9

    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!

    Advertise
    • Apple Podcasts
    • Google Play
    • Spotify
    Latest Episodes:
    Azure SQL VM: Using PerfInsights to Evaluate Resource Health and Troubleshoot (Ep. 5) Sep 02, 2021
    Show notes 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
    Managing SQL Server Agent Jobs with Notebook Jobs in Azure Data Studio Aug 31, 2021
    Show notes

    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 Started

    Resources: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.
    Migrating to SQL: New Conversion Reports in SSMA (Ep. 7) Aug 26, 2021
    Show notes

    Reports have never looked so great! The new features in SQL Server Migration Assistant help you easily identify automatically converted objects and estimate the effort associated with manually converted objects. Incorporate your findings into your migration process and accelerate your journey to Azure SQL.

    [00:30] Introductions
    [01:46] Importance of SSMA reports
    [02:42] Demo: Challenges that led to enhancements
    [06:58] Demo: New, enhanced reports

    Resources:
    SQL Server Migration Assistant - SQL Server | Microsoft Docs
    Azure Database Migration Guides | Microsoft Docs
    Migrating to SQL series playlist

    Azure SQL VM: Get the best price-performance for your SQL Server workloads on Azure VM Aug 19, 2021
    Show notes

    When migrating your SQL Server workloads to Azure VM, there are literally hundreds of different VM sizes to choose from. Hopefully, you've seen our videos on sizing so you have an idea of the methodology we recommend to choose the right size, but what if you have a new SQL Server workload that you don't have metrics for? Where should you start? In part 4 of this eight-part series, we will highlight the Edsv4-series VMs and show you why we think they are the best VMs for your SQL Server workloads.

    [00:44] What are considerations for VM sizes
    [02:30] Favorite VM series
    [03:04] Edv4 and Edsv4-series documentation
    [07:37] Getting started

    Resources:Edv4 and Edsv4-seriesVM size: Performance best practices for SQL Server on Azure VMsHow to get the biggest bang for your buck with SQL Server on Azure VMAzure SQL Virtual Machine Reimagined Series
    Azure SQL VM: Use Azure Monitor Metrics to Track VM Cache Health (Ep. 3) Aug 12, 2021
    Show notes Azure Monitor is a technology used to collect telemetry data from your Azure and on-premises environments. You can use Azure Monitor to improve performance and support the stability of your applications by identifying issues quickly. Azure Monitor includes Azure Metrics and Azure Logs to store telemetry data and track data in real-time and for historical analysis.
    Azure Metrics track values collected at regular intervals and can be used to describe the health of your resources at a particular point in time. Azure Metrics are lightweight and useful for creating dashboard KPIs, alerting, and fast detection of issues.
    In part three of this seven-part Azure SQL VM series, we will use Azure metrics to identify the uncached and cached health of your virtual machine and disk resources. We will show how to find metrics at the VM scope, pin metrics to create a custom dashboard, how to manage alerts, and finally comparing cached and uncached metrics at the VM and disk levels. [00:48] Tracking VM cached health[02:55] Demo[09:23] Getting started Resources:Disk performance metricsAzure Monitor
    Azure SQL VM: Automate Management with the SQL Server IaaS Agent extension (Ep. 2) Aug 05, 2021
    Show notes In part two of this seven-part VM series, learn how to easily manage your Azure SQL virtual machines using the SQL IaaS Agent Extension with Pam Lahoud. Whether you are using an Azure Marketplace image or a custom image with a self-installed SQL Server, the SQL IaaS Agent Extension offers a number of features to discover and manage your SQL Server VMs quickly and easily through the Azure Portal. [00:44] What is SQL Server IaaS Agent Extension
    [01:30] Demo
    [05:23] Set-up
    [09:28] Getting started Resources:
    Automate Management with the SQL Server IaaS Agent ExtensionAutomatic Registration with SQL Server IaaS Agent Extension
    Azure SQL VM: Caching and Storage Capping (Ep. 1) Jul 29, 2021
    Show notes Optimizing Virtual Machine storage is one of the most critical areas to focus on when architecting for performance with SQL Server on Azure Virtual Machines (VM). Virtual machines have input/output operations per second (IOPS) and throughput performance limits based on the virtual machine type and size as well as storage. In part one of this seven-part VM series, we'll cover how capping occurs at the virtual machine and storage levels and how caching can help remove the impact of these performance limits. [00:40] Optimizing Storage Performance
    [02:46] Azure Virtual Machine and Storage
    [03:49] Disk IO Capping
    [06:46] Azure VM IO Capping Resources:Checklist: Best practices for SQL Server on Azure VMs
    VM size: Performance best practices for SQL Server on Azure VMs
    Storage: Performance best practices for SQL Server on Azure VMs
    How to get the biggest bang for your buck with SQL Server on Azure VMs
    Deep Dive: Azure SQL Virtual Machine Sizing | Data Exposed LiveAzure SQL Virtual Machine Reimagined Series
    SQL Server on Linux Storage Secrets Jul 27, 2021
    Show notes SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn't quite work like that by default. In a situation where you run out of space, you're out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before you put anything on the disks to properly set up the disks so you can expand them in a pinch in the future. In this episode with David Klee, we're going to walk through how to use this service to set up your object volumes the right way from the beginning and show you how to expand the disks with no outage. Break out your pocket protectors and come learn with someone who was compiling Linux kernels while in elementary school! [00:37] About David Klee
    [01:18] Challenge overview
    [02:14] Linux Logical Volume Manager
    [03:00] Demo: Logical Volume Manager Setup
    [09:22] Who should this set up
    [10:05] Getting started Resources:$2 Million Reasons to Start with TuningDavid Klee's websiteHeraflux Data Platform ConsultantsSQLlibrium Training About David Klee:David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies and SQLibrium Education. His areas of expertise are cloud, virtualization, performance tuning, and business continuity. David speaks at a number of national and regional technology-related events, including the PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups. 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
    Scale Out Your Databases with Azure SQL Hyperscale Named Replicas Jul 22, 2021
    Show notes

    In this episode of Data Exposed with Davide Mauri, get an overview of the newly released feature for Azure SQL Hyperscale Database: Named replicas. Named replicas allow for incredible scalability, giving you the option to scale out the database up to 30 named replicas, so that you can sustain any workload of any size. We'll dive into the key features that make Named replicas unique, the use case where Named replicas excels and some tips and tricks to architect solutions to take advantage of them, to get great performance and also to save a substantial amount of money.
    [00:36] Introductions
    [02:38] Azure SQL Hyperscale Overview
    [04:15] Azure SQL Hyperscale Replicas
    [05:30] High-Availability Replica
    [07:22] Named Replica
    [11:02] Named Replica - Use Cases & Sample Scenarios
    [15:06] Demo
    [20:00] Getting started

    Resources:Named replica (in Preview)
    Using SQL Data Sync for Bidirectional Data Replication in SQL Server and Azure SQL DBs Jul 15, 2021
    Show notes SQL Data Sync lets you synchronize the data you select bi-directionally across multiple databases, both on-premises and in the cloud. In this Data Exposed episode with Mara-Florina Steiu, we will cover common use cases and scenarios for Sync, discuss key technical implementation details, and try out a demo. [01:03] SQL Data Sync Overview
    [04:40] Use Cases
    [06:00] Additional Considerations
    [07:11] Demo
    [15:40] Getting started Resources:What is SQL Data Sync for Azure?Set up Data SyncBest practices for Azure SQL Data SyncTroubleshoot issues with SQL Data Sync
    1 2 3 Next

    Related Podcasts

    Reply All

    1

    Reply All Games & Hobbies
    Inside VR & AR

    2

    Inside VR & AR Gadgets
    Note to Self

    3

    Note to Self News
    BrainStuff

    4

    BrainStuff Natural Sciences
    This Week in Tech (Audio)

    5

    This Week in Tech (Audio) News
    Hands-On Tech (Audio)

    6

    Hands-On Tech (Audio) Technology
    footer-logo

    Contact Us

    Toll Free: 844-670-7747

    Links

    • Home
    • Top Charts
    • Networks
    • Apps
    • Independents Podcasts
    • Podcast Advertising
    • Podcast News
    • Contact Us
    • About Us
    • Analytics & Insights

    Stay Connected

      Privacy, Terms of Use & Our Code of Ethics Protecting Content Creators Copyrights