Spatial Analysis with SQL Server, R and Power BI
Discover the power of spatial analysis using SQL Server, R, and Power BI. Learn to analyze location-based data, make informed decisions, and create compelling visualizations for real-world 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.
Delivering a Data Warehouse in the Cloud
Learn to evaluate, provision, and optimize Azure SQL Data Warehouse. Covers scalability, cost-effectiveness, data loading, performance improvement, and security best practices for cloud-based data warehousing.
Query Analysis Deep Dive - 13 Causes of a Slow Query
Comprehensive exploration of 13 common query performance issues, providing practical solutions and a checklist for optimizing slow SQL queries.
Microsoft Data Engineering Unplugged
Meet Microsoft's Data Engineering team, discuss SQL Server, Azure SQL, and data services. Gain insights into product development, engineering processes, and future plans. Engage directly with PMs in this interactive session.
Complete CI - CD for C# and SQL
Practical demonstration on automating CI/CD for C# applications and SQL databases, covering source control, build processes, and deployment strategies for different environments.
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.
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.
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.
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.
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.
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.