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.
Building a Lakehouse on the Microsoft Intelligent Data Platform
Explore Lakehouse architecture on Microsoft Intelligent Data Platform. Learn Synapse Analytics, Delta format, and Spark-based engines for efficient big data processing and analytics.
Taking the "Public" out of Public Clouds: Getting Started with Private Endpoints
Discover private endpoints' basics, deployment, and security benefits for cloud platforms. Avoid common mistakes and enhance your infrastructure's safety.
Keeping Historical Data in Tables Forever - Mission (Im)possible
Explore solutions for storing and managing historical data in databases, addressing complex requirements for data retention, editing, and querying while optimizing performance.
Query Store Best Practices for Production Environments
Discover essential Query Store best practices for successful implementation in production environments. Learn from common issues and optimize your SQL Server performance.
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.
DataOps 101 - A Better Way to Develop and Deliver Data Analytics
Discover DataOps principles for reliable, timely, and trustworthy Power BI analytics. Learn to continuously improve data development and delivery processes.
Chaos Engineering for SQL Server
Explore Chaos Engineering concepts and methodologies to identify potential weaknesses in SQL Server, enhancing system resilience and reliability.
Merging Power BI into Azure DevOps - Version Control and CI/CD Pipelines
Integrate Power BI with Azure DevOps for centralized version control, change tracking, and streamlined deployment in team development environments.
Stop Indexing the Query - Optimizing Database Workload Indexing
Learn a methodology for optimizing database performance by indexing for your entire workload, not just individual problem queries.
Choosing the Right Database for Modern Cloud Applications
Design a data strategy and choose the optimal database for modern cloud applications. Learn about managed instances, Postgres, MySQL, and database engines across platforms.
Code Repos and Automated Deployment with Azure DevOps
Implement Azure DevOps for efficient code management and automated deployment, from concept to execution.
A DBA's Guide to the Proper Handling of Corruption
Learn to detect, investigate, and respond to database corruption effectively, ensuring minimal impact on your company's operations.
Extend Azure Capabilities Anywhere with Azure Arc-Enabled SQL Server
Explore Azure Arc for SQL Server: view, manage, secure, and govern on-premises or multi-cloud SQL Servers from Azure. Learn use cases, onboarding, inventory management, and Azure service integration.
PaaS-like Benefits Outside Azure with Azure Arc Enabled SQL Managed Instance
Modernize SQL servers with Azure Arc enabled SQL managed instance for PaaS-like benefits outside Azure. Explore architecture, backups, HA, DR, monitoring, and provisioning with demos.
Azure Data Engineering Tools: Choosing Between Data Factory, Databricks, and Synapse Analytics
Explore Azure data engineering tools: Data Factory, Databricks, and Synapse Analytics. Learn their strengths, use cases, and how to choose the right one for your project.
To Bicep or to Terraform - Choosing the Right Infrastructure as Code Tool
Compare Bicep and Terraform for Infrastructure as Code, exploring differences in state handling, configuration scoping, and change evaluation to choose the best tool for your implementation.
Azure Data Explorer - A Torch in the Dungeon of Observational Analytics
Explore Azure Data Explorer for observational analytics, learning its capabilities and getting a quick start in this powerful platform for handling big data and IoT scenarios.
Power BI and Azure Synapse Analytics - Creating a Unified Analytics Solution
Embark on a unified analytics journey using Power BI and Azure Synapse Analytics. Learn essential techniques to create powerful data solutions and gain valuable insights.
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.