Litestream: Making Single-Node Deployments Cool Again
Explore Litestream's approach to single-node deployments, SQLite's architecture, and database replication strategies for efficient and cost-effective data management.
Advanced Database Systems - Course Overview and Logistics
Explore advanced database systems concepts with CMU's comprehensive overview, covering course logistics and key topics in modern database management.
Migrating Oracle and Open Source Workloads to Azure - Innovations in Microsoft's Migration Tools
Discover innovations in Microsoft's Migration Tools for evaluating and accelerating Oracle and Open Source migrations to Azure, including new Azure Data Studio extensions.
An In-Depth Review of the Latest Advancements in Authentication for Azure SQL and SQL Server 2022
Explore advanced authentication features in Azure SQL and SQL Server 2022, including multi-factor, managed identities, and policy-based methods for secure, passwordless access.
Managed Instance Link - Seamless Migration to Azure SQL
Explore SQL migration tools and learn how Azure SQL Managed Instance Link enables minimum downtime migration from on-premises SQL Server to Azure SQL Managed Instance.
Connecting the Dots of Azure SQL DevOps
Implement modern, secure database DevOps for Azure SQL using VS Code, Azure Data Studio, GitHub, and Azure DevOps through project/declarative approaches.
Beware of Nondeterministic T-SQL Code
Explore the implications of nondeterministic T-SQL calculations and learn best practices to avoid potential issues in your database development.
Tidy Space, Tidy Mind - How to Better Manage SQL Environments Across Cloud Providers
Learn to efficiently manage SQL Server and Azure SQL estates across multiple cloud services, improving performance and creating budget space for new initiatives.
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.
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.
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.
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.
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.
Navigating Modern Authentication in Azure SQL and Arc-Enabled SQL Server
Explore modern authentication and credential management for Azure SQL and Arc-Enabled SQL Server. Implement best practices to secure your infrastructure effectively.
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.
When to Stop Tuning a Query - Optimization Techniques and Challenges
Explore SQL query tuning techniques, challenges, and optimization strategies to determine when a query is sufficiently optimized.
A Deep Dive into Microsoft Fabric Data Warehouse
Explore Microsoft Fabric Data Warehouse's capabilities, strategies, and implementation techniques for effective data management and analytics in this comprehensive deep dive.
Extendable by Design - Building Generative AI Apps with PostgreSQL, Vector Storage, and Azure AI
Harness PostgreSQL's extensibility to build AI-enabled apps using pgvector and Azure OpenAI. Gain hands-on experience through live demonstrations and practical insights.
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.
A Deep Dive into Microsoft Fabric Data Warehouse
Explore Microsoft Fabric Data Warehouse's capabilities and strategies for effective utilization in this comprehensive deep dive led by industry experts.