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.
Open Questions and Answers on Azure SQL Database
Live Q&A session with SQL Server Product Managers addressing user-submitted questions about Azure SQL Database, offering expert insights and solutions.
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.
AMA Open Questions and Answers on SQL Server 2014 HA-DR in the Cloud
Live Q&A session with SQL Server Product Managers addressing High Availability and Disaster Recovery solutions for SQL Server 2014 in cloud environments.
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.
Extending Your Hadoop Implementations to the Cloud
Explore cloud-based Hadoop deployment benefits, including scalability and cost-efficiency. Learn to integrate on-premise and cloud implementations for optimal performance and flexibility.
Breakthrough Data Platform Performance with SQL 2014
Explore SQL Server 2014's in-memory technologies for enhanced OLTP, Data Warehousing, and BI performance. Learn about mission-critical features and hybrid cloud capabilities for improved database management.
AlwaysOn in Microsoft SQL Server 2014
Explore upgrading mission-critical databases to SQL Server 2014, enabling new features like in-Memory OLTP and Managed Backup, with minimal downtime for large workloads.
The Modern Data Warehouse
Explore Microsoft's approach to evolving data warehouse infrastructure, addressing explosive data growth and new data types. Learn about scale-out technologies, in-memory performance, and Hadoop integration.
SQL Server 2014 In-Memory OLTP Management
Explore SQL Server 2014's in-memory OLTP technology, focusing on ACID compliance, storage optimization, memory provisioning, high availability, and manageability for enhanced database performance.
SQL Server Solutions to Deploy a Database to a Microsoft Azure VM
Deploy databases to Microsoft Azure VMs using SQL Server solutions. Learn efficient techniques for seamless migration and optimal performance in cloud environments.
Who's Responsible - The Vendor or the DBA?
Explore the roles and responsibilities of database vendors and DBAs in managing SQL Server environments, addressing common challenges and best practices.
Page and Row Compression Deep Dive
Explore advanced techniques for optimizing database performance through in-depth analysis of page and row compression strategies for DBAs.
End-to-End SQL Server PowerPivot
Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative business intelligence within familiar Microsoft tools.
Top 10 Things You Didn't Know About SSIS in SQL Server Code Name "Denali"
Explore SSIS improvements in SQL Server "Denali": enhanced developer experience, project & parameter model, server-based deployment, and hundreds of customer-reported fixes for highest quality release.
Query Tuning Mastery - Zen and the Art of Workspace Memory
Explore advanced query tuning techniques, focusing on workspace memory optimization for improved performance and scalability in SQL Server. Learn monitoring, query hints, and memory internals for complex queries.
What Happened? Exploring the Plan Cache
Explore SQL Server's plan cache to identify problematic queries and performance issues. Learn tools and techniques for analyzing cached plans, their lifespan, execution frequency, and potential optimization opportunities.
DBA Mythbusters
Debunking common SQL Server myths and misconceptions, covering topics like non-logged operations, corruption risks, MAXDOP settings, and table-scan behaviors. Gain accurate insights for better database management and maintenance.