Azure Synapse Analytics - A Data Lakehouse
Explore Azure Synapse Analytics, a unified service combining data warehousing and Big Data analytics. Learn about its features, scalability, and integration in modern data warehouses through demonstrations.
One Bite at a Time
Efficient techniques for anonymizing PII data, archiving old data, and performing garbage collection in databases. Learn to create procedures for updating large datasets while maintaining performance and avoiding blocking operators.
Common Data Service - Why Is It Not Common Yet?
Explore Common Data Service's strengths and weaknesses in the Power Platform. Learn to build, ingest, and extract data through demos, understanding its role in centralizing business logic across applications.
Scaling a DWH Beyond the Petabyte
Learn strategies for planning, architecting, and scaling data warehouse infrastructure from terabytes to petabytes using real-world examples for on-premises and cloud solutions.
Real-World Challenges to Implementing Database DevOps
Explore practical strategies for implementing database DevOps, addressing challenges in data management, and optimizing deployment processes for both on-premises and cloud-based environments.
Polybase - It's What's for Dinner!
Explore Polybase, Microsoft's linked server replacement, for connecting to diverse data sources. Learn setup best practices, scale-out groups, AlwaysOn integration, and performance optimization techniques.
Dr. DMV with Jupyter Notebooks
Comprehensive guide to using Dynamic Management Views for SQL Server diagnostics, leveraging Jupyter Notebooks to detect and resolve performance issues with detailed result interpretation.
SQL Server Business Intelligence on Amazon RDS
Explore SQL Server Integration Services, Analysis Services, and Reporting Services on Amazon RDS. Learn cost-saving strategies, configuration, security, and reliability for Microsoft BI toolkit on cloud infrastructure.
Data Governance for Beginners
Learn data governance basics for Microsoft Data Platform, including master data management and data stewardship. Discover practical steps for implementation and documentation to enhance organizational data value.
Normalization Beyond Third Normal Form
Explore higher Normal Forms in database design, debunking myths and enhancing your skills. Learn to identify, check, and understand the consequences of violations for improved database architecture.
Data Virtualization - Data Lake Power Using SQL Big Data Cluster
Explore data virtualization with SQL Server 2019 Big Data Cluster, enabling seamless integration of diverse data sources for efficient processing and analysis of structured and unstructured data across cloud and on-premises environments.
Intro to Azure Data Catalog
Learn how Azure Data Catalog can help your organization efficiently discover, understand, and utilize vast amounts of data across various sources, improving data accessibility and decision-making.
Skill up on Azure with Microsoft Learn - Professional Development
Explore Microsoft Learn's comprehensive training options for advancing your technical skills in Azure, including free self-paced learning, instructor-led training, and certifications.
SQL Notebooks in Azure Data Studio for the DBA
Explore SQL Notebooks in Azure Data Studio for DBAs: simplify workflows, run diagnostic queries, and leverage powerful features for daily database management tasks.
Unified Data Governance with Azure Purview
Explore Azure Purview's innovative approach to unified data governance, including automated discovery, lineage extraction, and centralized access control for cloud-scale data estates across various systems.
Transform Your Data Estate
Explore Microsoft's Intelligent Data Platform and its potential to revolutionize data management through seamless integration of databases, analytics, and governance.
Build a Modern Data Strategy and Put Your Data to Work
Explore AWS's outcome-driven pathways for SQL Server transformation, featuring customer success stories on migrating and modernizing workloads to unlock innovation and improve decision-making.
Doing More with Less - The Challenges Ahead for Every Data Professional
Explore challenges facing data professionals and strategies for maximizing efficiency with insights from industry leaders at Redgate's 2022 PASS Data Community Summit Keynote.
Enable Intel LAM in Linux
Explore Intel LAM implementation in Linux, covering usage, linker changes, metadata, compatibility, kernel status, and future plans for enhanced performance.
Strings Seven Ways
Explore seven diverse approaches to understanding and working with strings in Swift, from Unicode characters to typographic content, enhancing your string manipulation skills.
Case Study - Making the Most out of a Doomed Project
Explore strategies for salvaging doomed ML projects, handling challenges, and extracting value from difficult situations in this insightful case study presentation.