SQL Server Solutions to Deploy a Database to a Microsoft Azure VM
Deploy databases to Microsoft Azure VMs using SQL Server solutions. Learn efficient techniques for seamless migration and optimal performance in cloud environments.
SQL Server Execution Plans - From Compilation to Caching to Reuse
Comprehensive exploration of SQL Server execution plans, covering compilation, caching, reuse, and optimization strategies for improved database performance and scalability.
Page and Row Compression Deep Dive
Explore advanced techniques for optimizing database performance through in-depth analysis of page and row compression strategies for DBAs.
More DBA Mythbusters
Debunking SQL Server myths and misconceptions, covering data compression, file management, isolation levels, checkpoints, logging, recovery, and more for improved database administration.
What's New in Security for SQL Server Code Name "Denali"
Explore advanced security enhancements in SQL Server "Denali", including Audit improvements and enhanced manageability, to better protect against data breaches and meet compliance regulations.
Seeking SQL Server Secrets
Explore hidden SQL Server features, traceflags, and DBCC commands. Learn techniques to uncover undocumented secrets and enhance your database administration skills.
Building NextGen Scalable & Highly Available Architectures with Microsoft SQL Server 2008 R2
In-depth exploration of SQL Server 2008 R2's scalability, high availability, and disaster recovery features, with real-world architectures and implementation best practices for enterprise environments.
Virtualization and SAN Basics for DBAs
Explore virtualization and SAN technologies' impact on SQL Server performance from multiple perspectives, gaining insights from an expert with diverse administrative experience.
Expert Query Performance Troubleshooting
Dive deep into query processor optimization, exploring recompiles, memory issues, and execution plans to enhance SQL Server performance and efficiency.
New Paradigm for Performance Tuning in SQL Server 2016
Explore advanced performance tuning techniques in SQL Server 2016, focusing on Query Store for plan comparison, resource consumption analysis, and efficient query tracking.
New Paradigm for Performance Tuning in SQL Server 2016
Explore innovative performance tuning techniques for SQL Server 2016, focusing on new paradigms and advanced strategies to optimize database efficiency and speed.
A Lap Around Columnstore and 2016 Operational Analytics
Explore Columnstore and 2016 Operational Analytics in SQL Server, focusing on performance improvements and real-time analytics capabilities for data-driven decision making.
SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data
Explore SQL Server 2016's hero features, including record-breaking performance, enhanced availability, in-memory OLTP, and secure data protection, with practical applications in financial data management.
SQL Server 2016 Always On Availability Groups Enhancements
Explore SQL Server 2016 Always On Availability Groups enhancements, including improved failover, security, and performance features for high availability and disaster recovery.
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.
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.