SQL and MongoDB - When Two Worlds Collide
Explore hybrid SQL-NoSQL solutions, focusing on integrating MongoDB with SQL Server. Learn scenarios, implementation techniques, and performance considerations for leveraging strengths of both database types.
Infrastructure for the DBA - An Introduction
Comprehensive overview of infrastructure layers for DBAs, covering hardware, network, storage, virtualization, and operating systems to enhance problem-solving and proactive management skills.
Columnstore Indexes in 2017-2019
Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.
Turbocharge Your SQL Server with In-Memory Database
Discover how to leverage SQL Server 2019's memory-optimized technologies to enhance performance and scalability, taking advantage of modern hardware innovations for database applications.
Query Optimization Statistics - Driving Force Behind Performance
Explore SQL Server query optimization statistics, their impact on performance, and techniques to address common issues for improved query execution.
Never Lose Data - Digging Out From Corruption
Learn essential recovery techniques to prepare for, detect, and repair various corruption-based problems in databases, ensuring data integrity and minimizing disruptions in your enterprise.
Aggregations in Power BI
Explore high-performance data analysis using Power BI Aggregations. Compare with Analysis Services, learn implementation strategies, and understand architectural approaches for optimized analytical solutions.
Working with SQL Server Containers to Build Database Solutions
Explore efficient SQL Server solution deployment using containers, covering basic and advanced methods, real-world scenarios, and cross-platform portability for streamlined database management.
Query Store In-Depth
Explore Query Store's capabilities, quirks, and real-world applications for troubleshooting performance issues in SQL Server, including updates for SQL Server 2019.
Handling Role Playing Dimensions in Tabular Models
Explore various methods for implementing role-playing dimensions in tabular models, including DAX expressions, with a focus on model maintainability and user experience in data analysis.
Linux Fundamentals for SQL Server DBAs
Explore SQL Server on Linux: installation, configuration, and management. Learn essential Linux commands and file systems for DBAs transitioning to this open platform.
Introducing Azure Synapse Analytics - The End-to-End Analytics Platform
Explore Azure Synapse Analytics, a comprehensive platform integrating relational and big data systems for efficient data ingestion, preparation, modeling, and serving in a unified workspace.
SQL Server 2019 - Your Next Modern Data Platform
Comprehensive overview of SQL Server 2019's features, including improved performance, data integration capabilities, and advanced security, highlighting its evolution as a modern data platform.
dbatools - A PowerShell Toolkit for the DBA
Explore dbatools PowerShell module for efficient SQL Server management. Learn installation, automation of routine tasks, and advanced features to streamline database administration workflows.
AI for the DBA
Explore the AI ecosystem for DBAs, covering basics, support skills, and in-depth understanding to thrive in AI. Learn about architecture and operationalizing models using Azure ML Server.
SQL Migration to Azure - Best Practices, Accelerators, and Production Case Studies
Explore SQL workload migration to Azure, covering best practices, tools, and real-world case studies. Learn end-to-end migration lifecycle and determine the best approach for your organization.
Revenge - The SQL
Discover humorous and creative SQL techniques to enforce best practices, prevent errors, and maintain control over your database environment. Learn unconventional methods to address common DBA challenges.
Getting Started with PowerShell as a DBA
Learn PowerShell fundamentals for DBAs: syntax, TSQL translation, and practical applications. Discover how this powerful tool can enhance your database administration skills and workflow efficiency.
What is Power BI Doing to My Database?
Explore Power BI's impact on databases, including query types, frequency, and volume. Learn essential considerations for DBAs before, during, and after Power BI deployment in organizations.
Inside the VertiPaq Engine
Explore VertiPaq engine internals, database architecture, and optimization techniques for improved performance and compression in SQL Server Analysis Services Tabular, Power BI, and Power Pivot.
Learn Faster in a Container - A Docker Introduction
Discover Docker's power for DevOps, from basics to advanced uses. Learn to set up, modify images, and deploy databases. Accelerate your tech learning with practical examples and hands-on demos.