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.
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.
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.
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.
Cost Optimizing Azure SQL Databases - More for Less
Dive deep into Azure SQL Database cost optimization strategies, exploring various dimensions and aspects to maximize efficiency and value.
Data Tiering Using Data Virtualization in SQL
Explore data tiering techniques using virtualization in SQL to optimize storage and improve query performance across diverse data sources.
Operational Insights for Hybrid and Multi-Cloud SQL Inventory Using Azure Arc SQL Server
Gain performance, inventory, and security insights for SQL Servers across hybrid and multi-cloud environments using Azure Arc for comprehensive management.
The New Database Landscape - Revealing Shifts and Charting the Next Horizon
Explore the evolving database landscape through personal experiences, customer insights, and industry trends, revealing shifts and future directions in database technologies.
Modern Models of Managing Database Fleets in Azure PaaS
Improve SaaS application management and virtualization with Azure PaaS offerings, enhancing scalability and efficiency for database fleets.
JSON as a First-Class Citizen in Azure SQL Database
Explore new T-SQL features in Azure SQL Database, focusing on JSON as a first-class data type. Learn to query and manipulate JSON data, enhancing data management capabilities.
Operational Insights for Hybrid and Multi-Cloud SQL Inventory Using Azure Arc SQL Server
Gain performance, inventory, and security insights for SQL Servers across hybrid and multi-cloud environments using Azure Arc for comprehensive management.
Designing and Building AI Applications with Vector Search Using Azure OpenAI and Azure Cosmos DB
Design and build AI applications using vector search with Azure OpenAI and Azure Cosmos DB, enhancing your skills in creating advanced AI solutions.
Confidential Development with Always Encrypted Using Enclaves
Explore Always Encrypted with secure enclaves for Azure SQL, learning best practices for developing applications with parameterized queries and collations.
Best Practices in PostgreSQL Tuning - Navigating Key Performance Bottlenecks in the Cloud
Optimize PostgreSQL performance in cloud environments through practical techniques for diagnosing and solving common bottlenecks, enhancing database efficiency and health.
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.
From SSIS to Synapse to Fabric - A Data Architect's Case Study
Explore a real-world EDW automation framework migration journey from SSIS to Synapse to Fabric. Learn migration processes, lessons, improvements, and unit testing strategies for data architects.
An Introduction to Extended Events
Learn to set up and utilize Extended Events for SQL Server performance monitoring and troubleshooting.