Inside SQL Server Latches
Explore advanced SQL Server internals, focusing on latches for critical operation synchronization. Gain insights into internal data structures and advanced diagnostics for optimizing database performance.
Tales from the Trenches - GUIDs - Use, Abuse and How to Move Forward
Explore GUID usage in databases, its impact on performance, and alternative solutions for efficient data handling and scalability in SQL Server environments.
CSS Update Queries — Under the Hood
Dive deep into the mechanics of CSS Update Queries with expert Conor Cunningham, exploring their inner workings and optimizing query performance.
Building NextGen Scalable & Highly Available Architectures with Microsoft SQL Server 2008 R2
In-depth exploration of SQL Server 2008 R2's scalability, high availability, and disaster recovery features, with real-world architectures and implementation best practices for enterprise environments.
Virtualization and SAN Basics for DBAs
Explore virtualization and SAN technologies' impact on SQL Server performance from multiple perspectives, gaining insights from an expert with diverse administrative experience.
Techniques to Beautiful Data Insights with R and SSRS
Discover five powerful techniques for creating stunning data visualizations using R and SQL Server Reporting Services, enhancing your ability to derive meaningful insights from data.
Got Data? Go Modern and Monetize - Learn How to Run Hortonworks HDP
Discover modern data monetization strategies using Hortonworks HDP. Explore efficient techniques for managing and extracting value from your data assets.
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.
New Paradigm for Performance Tuning in SQL Server 2016
Explore advanced performance tuning techniques in SQL Server 2016, focusing on Query Store for plan comparison, resource consumption analysis, and efficient query tracking.
New Paradigm for Performance Tuning in SQL Server 2016
Explore innovative performance tuning techniques for SQL Server 2016, focusing on new paradigms and advanced strategies to optimize database efficiency and speed.
Treasure Map - Choosing the Right Algorithm in Azure ML
Discover how to select optimal algorithms in Azure ML for data analysis and predictive modeling, enhancing your machine learning capabilities and decision-making processes.
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.
SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data
Explore SQL Server 2016's hero features, including record-breaking performance, enhanced availability, in-memory OLTP, and secure data protection, with practical applications in financial data management.
Relational Databases vs Non Relational Databases vs Hadoop
Explore the differences between relational, non-relational databases, and Hadoop, covering origins, key features, use cases, and Microsoft's data platform solutions.
Using JSON with SQL Server 2016
Explore JSON integration in SQL Server 2016, covering history, examples, support features, and practical applications for efficient data handling and querying.
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.
Advanced R Analytics in SS2016 Using R Tools for Visual Studio
Explore advanced R analytics using R Tools for Visual Studio, covering predictive modeling, data access, parallelization, and integration with SQL Server for improved performance and efficiency.