Azure Databricks Tables - Delta Lake, Hive Metastore, TempViews, Managed, External

Learn about the different tables that can be created using Azure Databricks with a dive deep into the importance of Delta Lake tables.

Query processing architecture guide

The SQL Server Database Engine processes queries on various data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following sections cover how SQL Server processes queries and optimizes query reuse through execution plan caching.

Designing Databases for Distributed Systems

Several data management patterns have emerged for microservices and cloud-native solutions. Learn important patterns to manage data in a distributed environment.

What I Wish Everyone Knew About ETL Processes - Traditional to Modern Cloud Solutions

Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.

Explore Natively Compiled SQL Server Stored Procedure Execution Plans

In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.

What Is Good Database Design?

Find out how good database design is essential to ensure data accuracy, consistency, and integrity and that databases are efficient, reliable, and easy to use.

Integrating Python with MongoDB

This article gives an overview of MongoDB and outlines steps to integrate python with MongoDB

The SQL Developer Experience: Beyond RDBMS

Microsoft has built an amazing platform with Azure SQL Database and has recently announced an offer to use this for free. Read about the capabilities and options with this cloud database platform.

New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries

Parsing a Pairs of Values in a String While Preserving Order

Learn how you can parse a series of parameters that are passed in a string of tuples, meaning pairs, of values and preserve order without using STRING_SPLIT with the ordinal parameter.