Introduction to the Wonders of Azure DevOps
Explore Azure DevOps for end-to-end build and release solutions. Learn core components, implement secure deployment pipelines, and utilize CI/CD with unit tests and gating.
Building SaaS Solutions on Azure SQL Database
Explore real-world architectures for SaaS solutions on Azure SQL Database, from small-scale to millions of tenants. Learn multi-tenancy models and apply them to your scenarios.
Understanding SQL Server Checkpoints - Why They Matter
Explore SQL Server's checkpoint process, its impact on performance, and recent changes in SQL 2014 and 2016+. Learn to influence checkpoint intervals for optimal database management.
A to Z Azure SQL Security Concepts
Explore multi-layer defense-in-depth security techniques for Azure SQL databases, covering network security, RBAC, data protection, auditing, encryption, and monitoring.
Azure Stack HCI and Microsoft Hybrid Data Services for SQL Server 2022
Explore Dell's Integrated System for Azure Stack HCI with AMD processors, simplifying SQL Server 2022 deployment and operations as a flexible DBaaS platform for modern cloud-native applications.
Azure Data Studio and the Surprises Inside
Discover hidden features and maximize your use of Azure Data Studio for enhanced database management and productivity.
Gathering Requirements for Your Star Schema
Collaboratively design dimensional models with business users for effective star schema requirements gathering and data visualization.
The Wonderful World of Collations, Encodings and Text Storage
Explore characters, collations, encodings, and text storage in databases. Gain insights into sort orders, diacritics, and code pages for improved data management and development.
From Your Couch to the Cloud - When and Why to Choose the Azure Portal for SQL Administration
Maximize Azure Portal capabilities for SQL administration. Learn when and why to use it for efficient cloud database management.
Performance Tuning Azure SQL Database
Learn Azure SQL Database performance tuning techniques, monitoring tools, and scaling strategies to optimize cloud database performance and overcome common challenges.
Data Protection Technologies in Azure SQL and SQL Server 2022
Explore latest data protection innovations in Azure SQL and SQL Server 2022, including Always Encrypted, Transparent Data Encryption, and Azure confidential computing for end-to-end security.
SQL Migrations to Azure Made Easy - Leveraging Microsoft's Migration Tools
Leverage Microsoft's Migration Tools to evaluate and accelerate SQL migrations to Azure, using Azure Data Studio extensions for optimized speed and productivity.
FinOps: How Data Engineers Get Their Cloud Costs Under Control
Discover techniques for managing cloud costs through architecture, monitoring, and optimization. Learn best practices for data engineers to control expenses effectively.
Keep the Integrity of your Database with Azure SQL Ledger
Protect valuable company data using Azure SQL Ledger. Learn how to maintain data integrity and enhance security for your business's critical information.
Migrating Data Solutions to the Cloud - A Comprehensive Checklist
Explore a comprehensive checklist for migrating data solutions to the cloud, covering planning, evaluation, discovery, assessment, architecture, costs, migration, and post-migration steps.
Azure Data Explorer: Introduction and Setup - The Last Crusade
Explore Azure Data Explorer setup and usage through practical examples in this introductory session on modern analytics and big data engineering.
Don't Let Your Permissions Be Hijacked - Preventing Permission Exploitation in SQL Server
Discover techniques to prevent malicious users from exploiting power user permissions through permission hijacking, ensuring robust database security.
SQL Server vs Azure Cosmos DB: Choosing the Right Database for Cloud Projects
Compare Azure SQL and Cosmos DB functionalities for legacy app migration or new cloud project database selection. Explore partitioning, data models, indexing, and performance tuning.
7 Things I Wish I'd Known Before Building a 60TB Data Warehouse on a Dedicated Pool
Discover key insights and lessons learned from building a 60Tb data warehouse on Azure Dedicated Pool. Explore challenges, solutions, and best practices for large-scale data management.
How to Get the Auditors Off Your Butt with dbachecks - SQL Server Security Compliance
Leverage dbachecks to ensure SQL Server security compliance and streamline auditor interactions. Learn efficient methods for proving system requirements.
Lessons Learned from Optimizing Enterprise Data Models
Discover tips and tricks for optimizing enterprise data models, reducing size, and meeting business needs when DirectQuery is the only option.