SQL Server 2014 – New Feature – Delayed Transaction Durability
Explore os princípios ACID, WAL e a nova funcionalidade Delayed Durability Transaction no SQL Server 2014, com foco em melhorar o desempenho e a durabilidade das transações.
Como fazer bonito para o DBA
Estratégias e dicas para desenvolvedores otimizarem o uso do SQL Server, melhorando a eficácia na extração de informações e atendendo aos requisitos internos do sistema.
Managing 1 Million+ DBs - How Big Data is Used to Run SQL Azure
Explore big data management in SQL Azure, covering telemetry scaling, data collection, batch pipelines, and machine learning for efficient database administration at scale.
Dealing with Multipurpose Procs and PSP the Right Way
Learn effective strategies for handling multipurpose stored procedures and plan-stability problems in SQL Server, improving query performance and database efficiency.
Query Tuning Mastery - Manhandling Parallelism, 2014 Edition
Mastering parallel query execution techniques for optimal SQL Server performance, focusing on advanced tuning strategies and best practices.
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.
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.
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.
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.
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.
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.
Using JSON with SQL Server 2016
Explore JSON integration in SQL Server 2016, covering objects, arrays, path expressions, functions, and indexing for enhanced data handling and querying capabilities.
Elastic Database Client Library and Elastic Database Transactions
Explore Azure SQL Database's elastic capabilities for scalable data-tier apps, including sharding patterns and distributed transactions across multiple databases.
Perfect Fits for Azure SQL Database Migrations
Explore Azure SQL Database migrations, including challenges, limits, and best practices for new projects, instrumentation, web apps, parallel processing, and data warehousing.
Elastic Database Client Library and Elastic Database Transactions
Explore Azure SQL Database's elastic tools for scalable multi-tenant applications. Learn about sharding, data-dependent routing, multi-shard queries, and elastic transactions.
Winning with Column Store in SQL Server 2016 - A Customer Story
Explore SQL Server 2016's Column Store feature through a real customer migration case, covering challenges, best practices, and performance improvements in data warehousing.
Four Reasons to Migrate Your SQL Server Databases to the Cloud
Explore AWS solutions for SQL Server migration, covering deployment, security, performance monitoring, scaling, storage options, and high availability features.
Columnstore Technology Improvements in SQL Server 2016
Explore the latest enhancements to Columnstore technology in SQL Server 2016, improving database performance and efficiency for large-scale data processing and analytics.