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.
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 Data Studio and the Surprises Inside
Discover hidden features and maximize your use of Azure Data Studio for enhanced database management and productivity.
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.
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.
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.
Security is Not a Feature: Implementing Modern Security in Legacy SQL Versions
Explore how modern security features can be implemented in older SQL versions, challenging the notion that security is tied to specific updates.
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.
Extended Governance of Power BI with Microsoft Purview
Enhance Power BI governance using Microsoft Purview. Learn about data catalog, mapping, lineage, DLP, lifecycle management, and information protection through live demos and best practices.
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.
Managing Replication with dbatools
Explore dbatools commands for managing SQL Server replication, from setup to teardown. Learn to automate and streamline replication processes efficiently.
Zero to Lakehouse in Microsoft Fabric
Build a full Data Lakehouse platform using Microsoft Fabric's unified SaaS data platform, exploring architecture patterns and implementation without Azure resources.
SQL Modernization Journey to Azure SQL - Tools, Assets, and Migration Best Practices
Explore SQL modernization to Azure SQL using migration tools, custom solutions, and best practices for a seamless transition to cloud-based database management.
Business Continuity of On-Premise SQL Servers Using Azure Services Through Arc
Leverage Azure Arc to enhance on-premises SQL Server management with automated backups, point-in-time restore, long-term retention, and monitoring for mission-critical clusters.
GitHub Copilot for SQL Development - Integrating AI into Database Development
Discover how to leverage GitHub Copilot as an AI assistant for efficient SQL coding and database development, enhancing your daily workflow.