Securing SQL Server in Containers
Learn strategies for securing SQL Server in containers, including pre-implementation considerations and methods to enhance container security in modern infrastructures.
Data Virtualization - Data Lake Power Using SQL Big Data Cluster
Explore data virtualization with SQL Server 2019 Big Data Cluster, enabling seamless integration of diverse data sources for efficient processing and analysis of structured and unstructured data across cloud and on-premises environments.
Animated Query Plans for the Visual Learner
Visualize SQL query execution with animated plans, demystifying concepts like Hash Match and Merge Join. Enhance your understanding of performance tuning through interactive, visual learning.
Modern Storage Technologies for Data Professionals
Explore cutting-edge storage technologies like Persistent Memory and NVMe, and learn how they enhance database performance. Understand storage-based data services and architectures for Big Data Clusters.
Make a Real SQL Cloud Transformation, Not Just a Migration
Explore cloud-native SQL transformation strategies, focusing on DevOps, scalability, and long-term outcomes beyond simple migration for optimal data management in the cloud era.
SQL Security Principals 101
Comprehensive introduction to SQL Server permissions, covering basics to advanced topics like stored procedures, views, and application roles, with practical demos for on-premise and Azure-based SQL platforms.
Getting the Most Out of the SQL Server Maintenance Solution
Explore advanced features of SQL Server Maintenance Solution for efficient database management, including availability groups, smart backups, parallel processing, and Azure integration.
Securing Network Access to Your SQL Servers
Learn effective strategies to secure SQL Servers from network attacks, including network segmentation, lateral movement prevention, and Azure IaaS VM options. Gain insights on protecting against ransomware and common vulnerabilities.
Get Your Optimizer to Give Up All Its Secrets
Uncover SQL Server's query optimization process, from parsing to rule application. Learn to analyze parse trees and memos for more efficient T-SQL writing and improved query performance.
Migrating Hundreds of SQL Server Instances to Azure at Scale
Learn strategies for migrating large numbers of SQL Server instances to Azure efficiently, including services, components, and automation techniques for minimal downtime and maximum scalability.
Azure SQL - What to Use, When, and What's New
Explore Azure SQL deployment options, latest capabilities, and updates. Learn to choose between VM, Managed Instance, and Database for optimal performance and scalability.
Query Store Best Practices
Optimize Query Store implementation with best practices, workload considerations, and performance insights for Azure SQL and SQL Server 2016+. Learn to address challenges and maximize benefits.
SQL Server Containers in Action
Explore SQL Server containers: use cases, recent improvements, and future roadmap. Hands-on demo showcases practical applications and benefits for database management and deployment.
Inside Waits, Latches, and Spinlocks Returns
Dive deep into SQL Server internals, exploring waits, latches, and spinlocks. Learn monitoring techniques, troubleshoot common wait types, and gain insights into Azure SQL-specific waits through demos and Windows Debugger analysis.
Deadlocks - Understanding and Troubleshooting
Explore complex deadlock scenarios in databases, learn to identify root causes, and discover effective solutions for this challenging aspect of concurrent query management.
SQL Server on Linux Performance
Explore SQL Server performance on Linux: configuration, monitoring tools, tuning techniques, and leveraging persistent memory for cost-effective optimization.
Data Warehouse Automation Using Agile Methods
Explore agile data warehouse development using Data Vault design and metadata-driven automation for faster delivery, flexible architecture, and improved documentation in business intelligence projects.
Find - So You Can Fix - Those Troublesome Queries
Explore tools and techniques to diagnose, troubleshoot, and optimize problematic SQL Server queries, enhancing database performance and efficiency.
Code Like a Snake Charmer Version 2.0 - Introduction to Python
Comprehensive introduction to Python for data science, covering basics and machine learning using real-world datasets. Ideal for beginners looking to integrate Python into Microsoft tools.
Think Like a Terminator - Internals of Classic SQL Server Indexes
Explore SQL Server index internals, including clustered and non-clustered types, space allocation, and optimization techniques. Learn to improve database performance through hands-on demonstrations and practical insights.
SQL Security for Everybody - Understanding Logins, Users, and Roles
Comprehensive guide to SQL Server security, covering instance-level controls, server and database principals, roles, and object-level permissions. Practical demos for developers and DBAs.