Amazon Aurora - Design for High Throughput Cloud-Native Relational DBs
Explore Amazon Aurora's innovative architecture for high-throughput cloud databases, focusing on network optimization, fast recovery, and fault tolerance without distributed consensus algorithms.
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.
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.
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.
Using the Power Platform to Radically Change Your Business
Explore how Microsoft Flow, PowerApps, and Power BI can revolutionize your business operations, enhance efficiency, and drive innovation through the Power Platform's integrated capabilities.
Managing ETL Change Using BIMLScript
Automate ETL processes using BIMLScript and metadata to easily adapt to source file changes, demonstrated with US census data and applicable to SSIS and Azure Data Factory.
Identifying Anti-Patterns in Analytical Queries
Learn techniques to optimize SQL-based analytical queries, restructure jobs, and eliminate performance bottlenecks. Improve efficiency and deliver results faster across various data tools and platforms.
Modernize Your SQL Server the Right Way
Learn to upgrade SQL Server efficiently using Microsoft's free tools. Discover a methodical approach for seamless migrations, ensuring reliability and success in modernizing your database infrastructure.
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.
Datacenter and/or Cloud - When to Use One, the Other, or Both
Learn to categorize workloads, evaluate SLAs, and choose optimal data locations between cloud, datacenter, or hybrid solutions. Includes cost estimation and SLA validation techniques.
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.