Como Leer Planes de Ejecución
Aprende a interpretar planes de ejecución en SQL Server para optimizar consultas y mejorar el rendimiento de bases de datos con el experto Enrique Catala.
Modular Data Extraction and Integration Patterns
Explore modular data extraction and integration patterns for efficient business analytics, enhancing data-driven decision-making processes.
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.
Taking the Scare out of Monster Reports - Pam Shaw
Learn techniques to simplify complex reporting tasks, focusing on breaking down large projects, handling disparate data, and creating efficient dashboard and control table solutions.
Integrating SQL Server Analysis Services with Hadoop
Explore the integration of SQL Server Analysis Services with Hadoop, focusing on leveraging big data for enhanced business intelligence and analytics capabilities.
Optimize All Data with a Modern Data Warehouse Solution
Explore modern data warehouse solutions for optimizing data lifecycle, enhancing business insights, and maximizing value from your data infrastructure.
Don't Repeat Yourself - An Introduction to Agile SSIS Development
Learn to streamline SSIS development using Biml and BimlScript. Generate packages from metadata, implement changes efficiently, and reuse code across projects for faster, more agile development.
Understanding and Visualizing Data Using R in SQL Server
Explore data analysis using R with SQL Server. Learn to connect, validate, and visualize data through statistical methods and reporting tools. Includes sentiment analysis demo of Twitter PASS MVP Summit.
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.
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.
Patrones de busquedas aceleradas con Lookup entre periodos con Integration Services
Aprende técnicas avanzadas para optimizar búsquedas en Integration Services utilizando Lookup entre periodos, mejorando el rendimiento de tus procesos ETL.
24 Hours of PASS Portuguese Edition 2014 - SSIS Revolution with BIML
Introdução ao BIML e demonstração de como revolucionar o uso do SSIS, transformando radicalmente a abordagem atual para maior eficiência e produtividade no desenvolvimento de soluções de integração 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.
Agile Data Warehousing - Start to Finish
Learn agile data warehousing techniques to streamline production, maintenance, and evolution using SQL Server Data Platform, balancing cost-cutting and resource investment for optimal business value.
AMA Open Questions and Answers on SQL Server 2014 In Memory OLTP
Open Q&A session addressing queries about SQL Server 2014 In-Memory OLTP, offering expert insights and solutions for database professionals seeking to optimize performance.
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.
In Memory OLTP Performance Troubleshooting
Troubleshoot In-Memory OLTP performance issues: diagnose and resolve log IO bottlenecks, index tuning, and query plan problems to achieve desired performance improvements.
A Case Study Featuring In Memory OLTP and Hybrid Cloud Scenarios
Practical insights on upgrading mission-critical databases to SQL Server 2014, implementing In-Memory OLTP, Managed Backup, and Azure Storage integration for large workloads.
Unlocking Data Insights
Empower users with robust BI tools to transform raw data into business insights. Learn to enable easy data access, leverage Microsoft's tools, and build a comprehensive data platform across on-premises, cloud, and devices.
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.