Understanding Locking, Data Modification and Committing Data in SQL Server

Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.

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.

New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries

Decision Tree - Credit Card Fraud Detection

Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.

Alternatives To SQL Server 2022 Built-in function GREATEST

If you haven’t already heard, SQL Server 2022 introduced a new built-in system function called GREATEST. Simply put, it is to a set of columns, variables, expressions etc. what the MAX function is to a set of values (i.e., rows) of a single column or expression.