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.
Expert Query Performance Troubleshooting
Dive deep into query processor optimization, exploring recompiles, memory issues, and execution plans to enhance SQL Server performance and efficiency.
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.
SQL Server 2016 Reporting Services & Mobile BI
Explore modern reporting with SQL Server 2016, featuring enhanced paginated reports, mobile BI, and integration with Power BI. Learn to create interactive, responsive reports for various platforms.
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.
Swimming in the Data Lake
Explore data lake concepts, best practices, and tools for effective data management and analytics in modern cloud environments.
SQL Server 2016 Just Works Faster - Performance Improvements in Database
SQL Server 2016 performance enhancements: DBCC scaling, TEMPDB improvements, automatic Soft NUMA, dynamic memory management, and more. Learn about key upgrades for faster database operations.
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.
Schizophrenic High Availability with SQL and Windows 2016
Explore advanced high availability solutions for SQL Server, including failover clustering, HADR, Azure integration, and new features in Windows 2016 for enhanced database resilience and performance.
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.
A Lap Around Columnstore and 2016 Operational Analytics
Explore Columnstore and 2016 Operational Analytics in SQL Server, focusing on performance improvements and real-time analytics capabilities for data-driven decision making.
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.