Start off the Season with Azure Snowflake
Discover Snowflake's cloud data warehouse: simplified management, scalable performance, and cost-effectiveness. Learn about its multi-cluster architecture, resource separation, and easy implementation for efficient data handling.
Improving Columnstore Load Scalability on Large Servers
Optimize columnstore index load times from 260 to 6 minutes using advanced techniques for SQL Server. Learn scalability improvements for large servers and data warehouse workloads.
TDE, Encryption, and Compliance With Azure Key Vault - Zero To Hero
Learn to secure and comply with data regulations using SQL Server TDE, encryption, and Azure Key Vault. Covers basics to advanced topics, including AlwaysON and hybrid cloud scenarios.
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.
Presenting Big Data Clusters for SQL Server 2019
Explore SQL Server 2019's Big Data Clusters, combining open-source technologies with SQL Server for advanced analytics. Learn how containers and Kubernetes integrate Apache Spark, Hadoop, and SQL Server into a unified analytics solution.
6 Months to 5 Minutes - DB & BI Deployments at the Speed of Light
Transforming database and BI deployments from months to minutes through Agile methodologies and Continuous Delivery, overcoming organizational barriers for faster innovation and happier teams.
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.
Encrypting Data Within SQL Server
Explore SQL Server encryption options, data privacy laws, and performance impacts. Learn to classify sensitive data, implement Always Encrypted, and audit data usage for enhanced security.
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.
The Future Is Here for Containers
Explore Docker Swarm for rapid container deployment, data persistence, and seamless migration between on-premise and cloud environments.
Reduce Cost by Tuning Queries on Azure DBaaS
Learn techniques to optimize queries on Azure SQL Database, improving performance and potentially reducing costs by lowering resource demands and compute size requirements.
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.
Code Like a Snake Charmer – Advanced Data Modeling in Python
Comprehensive Python data modeling tutorial covering extraction, cleaning, transformation, visualization, predictive modeling, validation, and deployment using popular libraries and Azure integration.
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.
SQL Injection - What Is It, Prevent It, Monitor For It
Comprehensive guide on SQL Injection: understanding attacks, monitoring systems, and implementing robust security measures to protect databases from vulnerabilities and unauthorized access.
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.
CosmosDB - Designing and Troubleshooting Lessons
Learn to design, query, and troubleshoot high-performance Cosmos DB solutions through hands-on labs covering partition design, SQL API querying, and request optimization techniques.
Data Classification - Taking Your First Step on the Road to Agile Data Governance
Learn to build and maintain an evergreen catalog of your SQL Server estate, enabling agile data governance. Discover best practices for data classification, protecting sensitive information, and ensuring compliance with privacy regulations.
Innovative Data Modeling for Cool Data Warehouses
Explore agile data warehouse modeling techniques beyond traditional norms. Learn to build flexible, auditable solutions adaptable to various industries, leveraging MDM and Azure for enhanced performance and data integration.