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.
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.
A Beginner's Guide to Becoming a Performance Tuner
Discover hidden performance killers in SQL Server through worst practices. Learn server configuration, T-SQL parallelism, and TempDB issues to jumpstart your journey as a performance tuner.
SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It
Explore SQL Server 2017's Database Engine enhancements, including improved query processing, scalability features, and reasons to upgrade from previous versions.
Roles and Responsibilities of the Azure Data Engineer
Explore the role of Azure Data Engineer, including key responsibilities, required skills, and relevant Azure services. Learn how to align your career path with the Microsoft certification.
Performance Tuning Azure SQL Databases
Optimize Azure SQL Database performance using Automatic Tuning, Intelligent Insights, and Extended Events. Learn to leverage these features for time and cost savings while maximizing database efficiency.
Eliminating Anti-Patterns and RBAR for Faster Performance
Learn to boost SQL Server performance by identifying and fixing schema and code design issues, focusing on real-world examples and reproducible workloads to achieve faster query execution and better scalability.
How to Deploy SQL Server Containers on Kubernetes in Azure
Explore deploying SQL Server containers on Azure Kubernetes Service. Learn container creation, SQL Server deployment, and automation techniques for scalable and highly available database management.
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.
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.
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.
Should I Move My Production SQL Server Workloads to Containers
Explore the pros and cons of containerizing SQL Server workloads, examining architectural differences, advantages, and challenges to help decide if containers are right for your production environment.
Choosing Database Hardware for SQL Server 2019
Optimize SQL Server 2019 hardware selection for performance and cost-efficiency. Learn to evaluate workloads, choose processors, and navigate licensing changes to maximize database server capabilities.
Azure SQL Database - Maximizing Cloud Performance and Availability
Optimize Azure SQL Database performance and availability for mission-critical applications. Learn best practices, configuration tips, and troubleshooting techniques to maximize cloud resources and achieve 99.995% uptime.
Privacy and Security by Design in a Cloud Environment
Learn security and privacy design principles for cloud architectures, with practical implementation examples and best practices for integrating these crucial aspects into your solutions.
True SQL Server Detective
Explore real-world SQL Server performance issues through engaging detective stories. Learn to diagnose and solve complex problems in performance tuning, blocking, and server management.
Why the Database is at the Heart of DevOps Success
Discover how to integrate database changes into Agile practices, optimize development workflows, and bridge silos between teams for faster, more reliable software delivery in DevOps environments.
Power BI Report Server Enterprise Architecture, Tools to Publish
Explore enterprise-grade Power BI Report Server architecture, publishing tools, and best practices for improved performance, security, and scalability in large-scale implementations.
Successful ORM Design Strategies
Explore effective Object Relational Mapper design patterns for improved data access, schema management, and object structures. Learn strategies to ensure maintainable and flexible ORM implementations.
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.
HA - DR - Too Many Choices
Explore various high availability and disaster recovery options for SQL Server, weighing pros and cons to find the best fit for your company's needs and requirements.