A Deep Dive into Execution Plans & How to Use Them
Explore SQL Server Query Optimizer's execution plans, learn to read and fine-tune them for better performance, and master troubleshooting techniques to enhance database efficiency.
How to Put DevOps Into Action for Your Databases
Learn to implement DevOps practices for database deployments, covering source control, automated testing, and continuous integration/delivery through live demonstrations and practical insights.
From Docker to Big Data Cluster - A New Era for SQL Server
Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.
The Good, Bad, and Ugly of Migrating SQL Server to Public Clouds
Explore the challenges and best practices for migrating SQL Server to public clouds like Azure, AWS, and GCP. Learn from real-world experiences to ensure a successful transition from on-premises to cloud environments.
Congratulations, You Are Now a DBA
Essential roadmap for new DBAs: daily, weekly, and monthly checklists for SQL Server administration, data protection, and server maintenance. Learn key responsibilities and long-term career prospects in data-driven decision-making.
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.
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.
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.
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.
Serving Trillion-Record Table on TiKV
Explore TiKV's architecture and recent developments, including Titan storage engine and multithreaded raft store. Learn how these features enable serving massive datasets in distributed key-value databases.
Zero Database Downtime with etcd-operator
Explore how Etcd-operator automates etcd operations, enabling zero downtime upgrades, multi-zone redundancy, and automatic recovery. Learn to integrate it for efficient database administration.
Vitess - A Distributed Scalable Database Architecture
Explore Vitess, a distributed database system for MySQL scaling. Learn about sharding, data distribution, and integration with development frameworks for high-traffic OLTP sites.
Postgres Extensions in Kubernetes
Explore dynamic loading of Postgres extensions in Kubernetes, addressing challenges with container immutability and introducing innovative solutions like pod-local controllers for efficient extension management.