Adding Data Quality - Kimball Data Warehouse
Learn to enhance small to mid-size Kimball data warehouses with a design architecture for capturing, measuring, and relating data quality issues to existing fact and dimension tables.
Cross-Platform SQL Server Management - Taming Infrastructure and Application Usage
Learn to monitor SQL Server instances using extended events, capturing data for CPU utilization, resource usage, and performance analysis. Gain insights into best practices and practical implementation techniques.
Building Modern Data Pipelines with Spark on Azure HDInsight
Explore common patterns for building end-to-end data analytics pipelines using Apache Spark on Azure HDInsight, covering architecture, integration points, and various pipeline options.
Essential Linux for the DBA - Cross-Platform SQL Server Management
Learn essential Linux skills for database administration, focusing on cross-platform SQL Server management. Gain insights from a multi-platform DBA with extensive Unix/Linux experience.
Manage SQL Server Farm via SSMS - Cross-Platform SQL Server Management
Learn efficient management and monitoring techniques for multiple SQL Server instances, minimizing administration effort and maximizing productivity.
Azure Data Lake - Summit Preview
Explore Azure Data Lake technologies, their benefits, challenges, and implementation strategies for effective big data storage, processing, and analysis in the cloud.
Data Positioning - Self-Defense or a Brilliant New Architecture
Explore Data Positioning's evolution in data management, learning its history, principles, and architecture for delivering value in current and future scenarios.
Baselining and Alerting for Microsoft SQL Server
Learn techniques for monitoring SQL Server performance, establishing baselines, and implementing effective alerting strategies to optimize database performance and troubleshoot issues proactively.
Availability and Infrastructure for SQL Server Deployments
Explore SQL Server's 20-year evolution in availability and infrastructure. Learn about virtualization, storage trends, clustering, and future developments in this comprehensive overview.
Faster SSIS
Optimize SQL Server Integration Services packages with expert Andy Leonard. Learn tuning techniques for faster SSIS performance using sample and real-world data in this practical demonstration.
Integración de Datos con Azure Data Factory
Aprende a crear y gestionar proyectos de integración de datos escalables en la nube utilizando Azure Data Factory, abordando fuentes en la nube, on-premise y paquetes SSIS tradicionales.
Modelado y carga de datos con SSAS
Explora el papel de SSAS en Azure para soluciones BI, aprende sobre modelado y carga de datos, y descubre cómo visualizar información con Power BI y Excel.
Introduction to Azure Data Factory
Learn Azure Data Factory fundamentals, build new data pipelines, and migrate SSIS packages. Discover how to streamline your data integration processes in the cloud.
SQL Server 2019 Big Data Clusters Architecture - Modernizing Your Data Platform
Explore SQL Server 2019's big data cluster architecture, integrating SQL Server with HDFS for petabyte-scale storage and leveraging Kubernetes for scalable data processing and virtualization.
SQL Server 2019 on Linux and Containers - Modernizing Your Data Platform
Deploy and manage SQL Server on Linux and Containers, including at scale on Kubernetes clusters. Learn to modernize your data platform with expert insights.
High Availability - Disaster Recovery 101 - Data Architecture
Explore SQL Server 2017 HA/DR technologies, design strategies, and policies to meet specific RTO and RPO service levels. Learn to combine solutions for optimal infrastructure planning.
Azure Basics for the DBA - Cloud
Explore Azure fundamentals for DBAs, covering key concepts, terminology, and hands-on demos. Learn to set up virtual machines and SQL databases, enhancing your cloud skills for career growth.
Install & Configure SQL Server with PowerShell DSC
Implement infrastructure as code for SQL Server using PowerShell Desired State Configuration (DSC). Learn to prepare a new Windows Server and explore the advantages of this approach.
Big Data Architectures and The Data Lake - Cloud
Explore big data architectures, data lakes, and modern data warehousing. Learn about Hadoop, cloud benefits, and strategies to effectively manage and analyze large-scale data for business intelligence.
Log Shipping in SQL Server - High Availability and Disaster Recovery
Explore SQL Server log shipping for HA and DR, covering fundamentals, setup, use cases, and custom configurations. Gain practical insights through demos for server migration and business continuity.
The New ML Lifecycle - Deploying and Managing
Explore the challenges and solutions in adapting infrastructure for ML deployment, including automation, integration, and governance at scale. Learn best practices for the new ML lifecycle.