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.
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.
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.
Every Byte Counts - Why Your Data Type Choices Matter
Explore how data type choices in SQL Server impact performance and storage efficiency. Learn best practices for optimizing database design and mitigating performance issues through informed data type selection.
Making the Leap from Developer to DBA
Discover strategies for transitioning from developer to DBA, including essential skills and knowledge needed for success in database administration.
Optimizing Your Data Warehouse for OLAP Processing
Optimize data warehouse processing for OLAP with SSAS best practices, enterprise features, and database engine alignment. Learn compression, partitioning, and file group strategies for 200%+ performance improvement.
Planes de ejecución en SQL Server 2014
Aprenda a optimizar consultas SQL analizando planes de ejecución en SQL Server 2014. Mejore el rendimiento de su base de datos y resuelva cuellos de botella.
Storage Melhores Práticas com SQL Server
Aprenda a otimizar o desempenho do SQL Server através de configurações eficientes de armazenamento. Descubra boas práticas, noções de armazenamento e estratégias de I/O para maximizar o potencial do seu ambiente de banco de dados.
Are You Optimistic About Concurrency?
Explore optimistic concurrency in SQL Server, focusing on in-memory OLTP, isolation levels, and transaction management for improved database performance and scalability.
Right-Sizing Your SQL Server Virtual Machine
Learn to optimize SQL Server VM performance through proper sizing, resource allocation, and configuration techniques for enhanced efficiency and cost-effectiveness.
The Role of Polybase in the Modern Data Warehouse
Explore PolyBase's role in modern data warehousing: streamline ETL, export dimensions, use Hadoop for archiving, and enrich relational data with ambient data from Hadoop.
Field Testing Buffer Pool Extension and In Memory OLTP Features
Explore SQL Server 2014's In-Memory OLTP and Buffer Pool Extension features through field testing results, benchmarks, and real-world examples to enhance database performance and scalability.
In Memory OLTP Memory Storage Monitoring and Troubleshooting
Explore In-Memory OLTP monitoring, troubleshooting, and management using familiar tools like PerfMon, Profiler, DMVs, and XEvents for optimal performance and operational stability.
Buffer Pool Extension and Resource Governor for IO
Explore SQL Server 2014's Buffer Pool Extension for OLTP performance and Resource Governor enhancements for improved IO control in resource pools.
SQL Server 2014 - In-Memory OLTP End-to-End - Preparing for Migration
Explore SQL Server 2014's In-Memory OLTP feature, its performance benefits, and learn how to plan and execute a successful migration using a sample workload demonstration.
Columnstore Technical Deep Dive
Explore SQL Server 2014's updateable columnstore for massive query performance gains. Learn internals, differences from row store, and metadata insights in this technical deep dive.
Always-On Enhancements in SQL Server 2014
Explore AlwaysOn enhancements in SQL Server 2014, including increased secondary replicas, improved read availability, and seamless Azure deployment. Learn the business value and see practical demonstrations.