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.
Windows Azure Deep Dive
Explore Windows Azure's architecture, services, and capabilities with Microsoft Technical Fellow Mark Russinovich in this comprehensive deep dive session.
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.
Index Fragmentation - Internals, Analysis, and Solutions
Explore index fragmentation in SQL Server, covering internal structures, analysis techniques, and practical solutions for optimizing database performance and query efficiency.
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.
Dashboard Design Do's and Don'ts
Learn essential principles for creating effective business dashboards, including best practices and common pitfalls to avoid in data visualization and design.
Planeando e Implementando Servicios de Datos con Microsoft Azure
Aprenda a planear e implementar servicios de datos en Microsoft Azure, explorando estrategias efectivas y mejores prácticas para optimizar el rendimiento y la seguridad de sus soluciones en la nube.
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.
Introducción a Azure Data Warehouse
Explora Azure Data Warehouse: arquitectura, componentes clave y mejores prácticas para implementar soluciones de almacenamiento de datos escalables y eficientes en la nube.
Analizando patrones con SQL, Excel, Azure ML, R y más
Explora técnicas avanzadas de análisis de patrones utilizando SQL, Excel, Azure ML y R para obtener insights valiosos y mejorar la toma de decisiones en ciencia de datos.
10 Dicas para Escrever Codigos T SQL Melhores
Aprenda 10 dicas essenciais para aprimorar seus códigos T-SQL, melhorando a eficiência e qualidade das suas consultas e procedimentos armazenados.
24HoP Portuguese Edition - Powershell: Passar de scripts simples a funções avançadas
Aprenda a evoluir de scripts simples para funções avançadas no PowerShell, aprimorando suas habilidades de automação e gerenciamento de sistemas Windows.
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.
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.
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.