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.
Open Source Databases - Summit Preview
Learn to centrally monitor, diagnose, and report on open source databases alongside SQL Server, Oracle, and DB2 deployments in a single pane of glass.
Performance Tuning Wisdom Needs Expiration Dates
Brent Ozar and Erik Darling challenge conventional SQL Server performance tuning wisdom through demos, debunking myths about indexing, scans, and seeks while offering updated insights for effective database optimization.
Monitoring Page Splits in SQL Server - Cross-Platform SQL Server Management
Learn to accurately monitor page splits in SQL Server, debunking common misconceptions and exploring the only documented method for correct monitoring. Gain insights into transaction logs and best practices.
DBA's Proper Handling of Corruption
Learn to detect and plan for database corruption, including monitoring techniques, backup strategies, and recovery options for effective disaster management.
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.
Database DevOps to Ensure Compliance
Discover how Database DevOps can streamline your software development process, ensuring compliance and gaining approval from auditors and security staff. Learn to implement best practices for efficient and secure database management.
Migrating On-Premise Workload to Azure SQL DB
Comprehensive guide to migrating on-premise workloads to Azure SQL DB, covering planning, assessment, tools, and best practices based on real-world experiences.
Is the DBA Dead?
Explore the evolving role of DBAs, current challenges, and insights for career success in database administration through real-world statistics and expert analysis.
Prepare for Change, Because It's Coming
Explore 45 years of data technology evolution and learn strategies to drive your career forward in this rapidly changing field.
Dashboard Designing - From 0 to Hero
Transform raw data into actionable insights with Power BI. Learn data modeling, visual slicing, report creation, and advanced features for effective dashboard design.
Performance Optimization with Azure SQL Database
Discover built-in Azure tools for identifying and resolving database performance issues, enhancing customer experience and streamlining troubleshooting processes.
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.
Text Analytics API with Cognitive Services - Achieving AI Analytics
Learn to analyze feedback using Azure Cognitive Services, transforming data from Dynamics 365 to create insightful models and gain valuable AI-driven analytics insights.
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.
Intelligent Query Processing in SQL Server 2019 - Modernizing Your Data Platform
Explore groundbreaking query performance enhancements in SQL Server 2019's Intelligent Query Processing, revolutionizing data platform modernization and boosting efficiency.
Introduction to SQL Server Temporal Tables
Learn SQL Server temporal tables for versioning and historical data analysis. Explore creation, querying, and practical applications of this powerful feature for time-based data management.
Using Graph Databases to Understand Complexly Connected Data - Application Development
Explore Neo4j and graph databases, their use cases, and advantages over relational databases. Learn about property graph models, query languages, and practical applications in data analysis.
What's New in SQL Server 2019
Explore SQL Server 2019's enhancements in performance, security, Linux support, and Big Data Clusters. Learn about new features and improvements across the SQL Engine and Availability groups.
SQL Server Security Basics - Security
Learn SQL Server database security essentials, including permissions, principals, and best practices. Gain practical knowledge to protect your company's valuable data and manage security effectively.