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.
Database Administration Through the Ages
Explore modern DBA roles across platforms, leveraging existing skills for maintenance, monitoring, and disaster recovery on Windows, Linux, Azure SQL DB, and containers. Future-proof your career in database administration.
Data Engineering Brick-by-Brick - An Intro To Azure Databricks
Explore Azure Databricks for cloud-based big data analytics. Learn cluster setup, collaborative notebooks, and machine learning integration. Discover its role in modern cloud data warehousing.
What's Going On in My Power BI Environment?
Discover effective methods for monitoring and managing your Power BI environment, including usage tracking, license management, and data collection automation using Azure and PowerShell.
Microsoft Power BI for the Data Engineer
Explore Power BI's capabilities for enterprise-grade insights, performance, governance, and security over massive datasets. Learn simplified data modeling and visualization techniques for actionable insights.
Securing SQL Server in Containers
Learn strategies for securing SQL Server in containers, including pre-implementation considerations and methods to enhance container security in modern infrastructures.
Make a Real SQL Cloud Transformation, Not Just a Migration
Explore cloud-native SQL transformation strategies, focusing on DevOps, scalability, and long-term outcomes beyond simple migration for optimal data management in the cloud era.
SQL Security Principals 101
Comprehensive introduction to SQL Server permissions, covering basics to advanced topics like stored procedures, views, and application roles, with practical demos for on-premise and Azure-based SQL platforms.
Getting the Most Out of the SQL Server Maintenance Solution
Explore advanced features of SQL Server Maintenance Solution for efficient database management, including availability groups, smart backups, parallel processing, and Azure integration.
Securing Network Access to Your SQL Servers
Learn effective strategies to secure SQL Servers from network attacks, including network segmentation, lateral movement prevention, and Azure IaaS VM options. Gain insights on protecting against ransomware and common vulnerabilities.
Get Your Optimizer to Give Up All Its Secrets
Uncover SQL Server's query optimization process, from parsing to rule application. Learn to analyze parse trees and memos for more efficient T-SQL writing and improved query performance.
Azure SQL - What to Use, When, and What's New
Explore Azure SQL deployment options, latest capabilities, and updates. Learn to choose between VM, Managed Instance, and Database for optimal performance and scalability.
Query Store Best Practices
Optimize Query Store implementation with best practices, workload considerations, and performance insights for Azure SQL and SQL Server 2016+. Learn to address challenges and maximize benefits.
Inside Waits, Latches, and Spinlocks Returns
Dive deep into SQL Server internals, exploring waits, latches, and spinlocks. Learn monitoring techniques, troubleshoot common wait types, and gain insights into Azure SQL-specific waits through demos and Windows Debugger analysis.
Deadlocks - Understanding and Troubleshooting
Explore complex deadlock scenarios in databases, learn to identify root causes, and discover effective solutions for this challenging aspect of concurrent query management.
Data Warehouse Automation Using Agile Methods
Explore agile data warehouse development using Data Vault design and metadata-driven automation for faster delivery, flexible architecture, and improved documentation in business intelligence projects.
Code Like a Snake Charmer Version 2.0 - Introduction to Python
Comprehensive introduction to Python for data science, covering basics and machine learning using real-world datasets. Ideal for beginners looking to integrate Python into Microsoft tools.
Think Like a Terminator - Internals of Classic SQL Server Indexes
Explore SQL Server index internals, including clustered and non-clustered types, space allocation, and optimization techniques. Learn to improve database performance through hands-on demonstrations and practical insights.
SQL Security for Everybody - Understanding Logins, Users, and Roles
Comprehensive guide to SQL Server security, covering instance-level controls, server and database principals, roles, and object-level permissions. Practical demos for developers and DBAs.
Improving Analytics Performance With Columnstore Indexes
Explore columnstore indexes for efficient OLAP data storage and analytics in SQL Server. Learn architecture, optimization techniques, and best practices to enhance query performance on large datasets.
Move Your Entire BI Platform to Azure and Power BI
Comprehensive guide to migrating BI platforms to Azure and Power BI, covering architecture, implementation, governance, and support. Includes real-world examples and demos for enterprise-level deployment.