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.
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.
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.
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.
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.
Practical Guidance to Make Your Tier-1 SQL Server Roar
Optimize high-performance tier-1 SQL Server systems with expert guidance on configuration, tuning, and maintenance for modern hardware, covering platform, server, and infrastructure considerations.
Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos
Explore SQL Server index optimization with real-world scenarios and demos. Learn to identify and resolve performance issues caused by problematic indexes for improved query efficiency.
Deploy Your Database Using AWS DevOps
Learn to implement DevOps database deployments in AWS, from basic setup to advanced processes. Gain practical skills to streamline and expand your deployment capabilities.
Monitor Azure SQL Databases - Cloud
Explore Azure SQL Database monitoring using Azure portal, DMVs, and tools for metrics, resource usage, and performance. Learn to configure alerts and analyze logs for effective database management.
Controlling Chaos with Resource Governor
Manage SQL Server resource consumption by setting limits on CPU, IO, and memory for incoming requests. Learn to deploy and configure Resource Governor effectively.
SQL Server Farm Management vs Single Instance Management - DBA Fundamentals
Discover efficient SQL Server farm management techniques, inspired by dairy farming, for large-scale database control. Learn FarmDataLanguage to enhance monitoring and management of multiple instances.
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.
Model and Partition Data for Azure Cosmos DB
Learn to migrate relational data to NoSQL for e-commerce, focusing on modeling and partitioning techniques in Azure Cosmos DB. Discover how NoSQL enables unlimited scale with millisecond response times.
PerCPU Atomics
Explore efficient per-CPU atomic operations in Linux kernel development with Google engineers, enhancing system performance and scalability.
Databases
Explore database performance optimization, IO challenges, and filesystem behaviors. Gain insights from industry experts on improving database systems and addressing common issues in Linux environments.
A Zone-Aware Cache System for Distributed Databases
Explore a zone-aware cache system designed to enhance performance and efficiency in distributed database environments, addressing challenges and optimizing data access across multiple zones.