Policy-Based Management and Central Management Server
Explore policy-based management and Central Management Server for efficient SQL Server administration, including server registration, policy creation, and evaluation modes.
Troubleshooting Clusters
Learn essential techniques for diagnosing and resolving issues in clustered environments, enhancing your ability to maintain high availability and performance in complex database systems.
Windows Azure SQL Database Design - Silver Lining and Dark Side
Explore Windows Azure SQL Database design, covering editions, limitations, costs, data types, and modeling. Learn 10 tips for effective design and migration strategies.
Building Your T-SQL Tool Kit - Window Function Fundamentals
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad
Explore how skewed data affects cardinality estimates and query plans, learning strategies to improve SQL Server performance and optimize database operations.
Hekaton - Why, What, and How
Explore Hekaton, Microsoft's in-memory OLTP engine for SQL Server, with David DeWitt. Learn its purpose, functionality, and implementation details in this comprehensive keynote presentation.
How to Use DMVs to Diagnose Performance Issues
Discover how to leverage Dynamic Management Views (DMVs) for effective SQL Server performance diagnostics and troubleshooting with expert Glenn Berry.
SQL Server 2014 In-Memory OLTP Overview
Explore SQL Server 2014's in-memory OLTP technology, its architectural pillars, and integration with SQL Server for optimized workloads and improved performance.
Did You Vote Today? A DBA's Guide to Cluster Quorum
Learn about cluster quorum in SQL Server, including dynamic quorum, witness types, and multi-site deployments. Gain practical insights for database administrators on maintaining high availability.
Mejores Prácticas para SQL Server en Ambientes Virtualizados
Aprenda las mejores prácticas para optimizar el rendimiento de SQL Server en entornos virtualizados, maximizando la eficiencia y minimizando los problemas comunes.
Advanced SQL Server Execution Plans
Aprofunde-se em planos de execução avançados do SQL Server, explorando técnicas para otimizar consultas e melhorar o desempenho do banco de dados.
Hekaton v2 e ColumnStore Index v3 - Nova Geração de DBAs
Explore Hekaton v2 e ColumnStore Index v3, tecnologias avançadas para DBAs modernos. Aprenda a otimizar bancos de dados e melhorar o desempenho com as mais recentes inovações do SQL Server.
Entendendo o Transaction Log
Explore o Transaction Log do SQL Server, sua importância, funcionamento e impacto no desempenho do banco de dados nesta palestra técnica em português.
Index Internals - RowStore, ColumnStore, and NoStore
Explore index internals in SQL Server, covering RowStore, ColumnStore, and NoStore structures. Learn when to use each type and understand their performance implications.
50 Things All SQL Server Developers Need to Know
Discover 50 essential SQL Server development tips, covering database design, T-SQL best practices, and query optimization techniques for improved performance and efficiency.
The Top 8 Reasons for Your Transaction Performance Problems
Explore the top 8 causes of transaction performance issues and learn effective strategies to identify, troubleshoot, and optimize database performance for improved efficiency.
The Enterprise Scripting Workshop
Learn enterprise scripting techniques to automate database tasks, improve productivity, and avoid common mistakes. Covers cursor usage, multi-database operations, and object deployment strategies.
Curious Cases of Availability Groups
Explore common and unique challenges in implementing AlwaysOn Availability Groups, with practical solutions and insights for seamless production deployment.
SQL Server Agent - The Life Preserver for the Drowning DBA
Learn to automate DBA tasks using SQL Server Agent. Discover job creation, alerts, monitoring, and common pitfalls to streamline your database management and boost efficiency.
The Art and the Science of Designing a Mission Critical SQL Server Solution
Explore mission-critical SQL Server design archetypes, selecting optimal features for high availability and scalability. Learn best practices and real-world advice for robust database system implementation.
Data Pages, Allocation Units, IAM Chains Oh My!
Explore SQL Server's data organization, including row structure, data pages, and index types. Learn how understanding these internals can improve database design and performance.