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.
SQL Server 2016 Stretch Databases
Aprenda sobre Stretch Databases en SQL Server 2016, una función que permite extender datos de tablas locales a Azure para optimizar el almacenamiento y rendimiento.
Optimizando SQL Server 2014 para MS Dynamics AX 2012 R3 ERP
Aprenda técnicas avanzadas para optimizar SQL Server 2014 y mejorar el rendimiento de MS Dynamics AX 2012 R3 ERP, maximizando la eficiencia de su sistema empresarial.
Filegroups - Ótimas Práticas
Aprenda práticas recomendadas para gerenciar filegroups no SQL Server, otimizando o desempenho e a manutenção do banco de dados.
Extended Events - Receitas de Sucesso para Troubleshooting
Aprenda técnicas avançadas de troubleshooting usando Extended Events no SQL Server, com receitas práticas para otimizar o desempenho e resolver problemas complexos de banco de dados.
Azure VMs with SQL Server - Notes from the Field
Insights and practical tips for optimizing SQL Server performance on Azure VMs, based on real-world experiences and best practices.
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.
Query Store no SQL Server 2016
Explore Query Store in SQL Server 2016, a powerful feature for performance tuning and query optimization, presented in Portuguese by Andre Batista.
SQL Azure Database
Explore SQL Azure Database fundamentals, features, and best practices with expert Vitor Faria Tomaz in this comprehensive Portuguese-language session.
Hacking Exposé Too - Just How Transparent is TDE?
Explore Transparent Data Encryption (TDE) in SQL Server, its implementation, and potential vulnerabilities through hands-on demonstrations and practical insights.
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.
Curious Cases of Availability Groups
Explore common and unique challenges in implementing AlwaysOn Availability Groups, with practical solutions and insights for seamless production deployment.
Common SQL Server Mistakes and How to Avoid Them
Learn common SQL Server mistakes and best practices for installation, configuration, and support to optimize your environment and avoid critical errors.
Overlord Tracking Changes, Real Time, in Your Environment
Track database changes in real-time with Event Notifications. Learn to set up automated alerts, reports, and source control integration for immediate awareness of modifications, enhancing performance and security.
Turbo Charged Transaction Logs
Optimize SQL Server transaction log performance, prevent issues, and improve throughput. Learn about log structure, settings, and troubleshooting techniques for efficient database management.
Protecting Your Data with Encryption
Explore SQL Server's encryption methods to safeguard data from hackers. Learn about hashes, cell-level, database-level, and backup encryption, as well as key protection strategies.
Introduction to Microsoft Azure DocumentDB
Learn to create and manage Azure DocumentDB instances, work with JSON documents, and develop application logic using JavaScript for efficient NoSQL database operations.
SQL Server 2014 - ¿Cómo crear soluciones de bases de datos híbridas
Aprenda a diseñar e implementar soluciones de bases de datos híbridas utilizando SQL Server 2014, combinando entornos locales y en la nube para optimizar el rendimiento y la escalabilidad.
SQL Server 2014 Backup Encryption
Explore SQL Server 2014's backup encryption features, enhancing data security and protection for your database backups.
Durabilidad diferida de transacciones y mejoras en gestión de bloqueos para tareas
Explora avances en durabilidad diferida de transacciones y gestión de bloqueos, optimizando el rendimiento y la eficiencia en sistemas de bases de datos.
Novidades e Futuro de Azure SQL Database
Explore as novidades e o futuro do Azure SQL Database, incluindo as características da nova oferta que substituirá as edições Web e Business atuais, e teste as últimas atualizações do serviço.