Cloud IaC with Terraform
Learn to implement Infrastructure as Code in cloud environments using Terraform, enabling efficient and scalable infrastructure management and deployment.
High Availability - Disaster Recovery 101
Learn SQL Server 2019 HA/DR strategies to meet RTO/RPO goals. Compare technologies, design solutions, and develop policies for effective implementation in various scenarios.
Azure Synapse Analytics
Unified data analytics platform for ingesting, preparing, managing, and serving data, combining enterprise data warehousing and big data analytics capabilities.
SQL Server Replication - Data Architecture
Explore log-based Change Data Capture for SQL Server replication, covering file system-level CDC, DDL propagation, and type/version support for high-volume environments.
Improving HA and DR for SQL Server on Pure
Explore modern storage-based architectures for SQL Server High Availability and Disaster Recovery, reducing administrative overhead while improving performance and data throughput capabilities.
My Romantic Relation with Powershell Generally - and with dbatools Especially
Discover the power of PowerShell and dbatools for efficient database management. Learn practical scenarios like automatic restore testing, log shipping, migrations, and upgrades to enhance your DBA skills.
Data Types Do Matter
Explore the critical importance of selecting appropriate data types for optimal data quality, storage, performance, and query accuracy in database management.
MSAs, GMSAs, and Groups - Use SQL Without Traditional User Accounts
Explore Active Directory features for enhanced SQL security, including AD Groups, MSAs, and GMSAs. Learn to simplify access management and reduce risks in database environments.
SQL Server in Containers - Your Next Dev - Test - Integration - Upgrade Server
Learn to leverage Docker containers for rapid SQL Server deployment, streamlining development, testing, and upgrade processes. Discover how containers differ from VMs and accelerate your software development lifecycle.
Designing Azure Data Disaster Recovery Strategies
Explore strategies to protect Azure data from regional outages, covering SQL Databases, VMs, and Managed Instances. Learn to meet recovery objectives and safeguard your cloud-based applications.
Relational Data Modeling Trends for Transactional Applications
Explore modern data modeling trends for transactional applications, addressing challenges in NoSQL, microservices, and cloud environments. Learn to adapt traditional principles to meet current business demands and facilitate rapid changes.
Azure Data Studio - The New Frontier
Explore Azure Data Studio's features for managing data platforms, including dashboards, snippets, profiling, charting, and more. Learn when to use it over SQL Server Management Studio.
JSON for the Data Mortals
Explore JSON in databases: learn its origins, investigate, manipulate, and validate JSON data using Microsoft SQL Server tools and example code.
Virtual SQL Server Performance Deep Dive
Explore virtualization's impact on SQL Server performance, covering CPU scheduling, storage, networking, and optimization techniques for maximum efficiency in virtual environments.
SQL Containers in 5 Minutes and 5 Lines of Code
Learn to quickly set up and manage SQL Server containers using PowerShell and Docker. Discover how containers support development and testing environments with rapid deployment and easy management.
Head to Head - SSIS Versus Azure Data Factory
Comparative analysis of SSIS and Azure Data Factory, exploring strengths, weaknesses, and real-world applications for data movement and transformation in SQL Server environments.
Surviving the Next Azure Outage Like a Boss
Learn strategies to protect SQL Server instances from Azure outages. Explore HA/DR solutions, Azure Site Recovery, Availability Zones, and Fault Domains to ensure business continuity during cloud service disruptions.
DataOps - Deploy SQL Server Databases Using Azure Pipelines
Learn to automate SQL Server database deployments using Azure Pipelines and Visual Studio Database Projects. Covers creating projects, manual deployments, and setting up automated pipelines with secure credential management.
Take Me to the Multiple Clouds Above Seattle
Explore multi-cloud strategies, benefits, and challenges. Learn from experienced architects about best practices, data integration, and migration in cherry-picking cloud services for optimal data platform design.
Enterprise-Grade BI with Power BI - EIM, Scale and Performance
Explore enterprise-grade BI with Power BI, focusing on EIM, scale, and performance. Learn about data lineage, impact analysis, semantic models, and data protection for optimized large-scale analytics solutions.
Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory
Streamline SQL Server and SSIS migration to Azure using ADF. Learn to provision SSIS-IR, run SSIS packages in ADF pipelines, and leverage DMA and DMS for efficient batch migrations.