Top 10 Methods to Improve ETL Performance Using SSIS

Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.

The promise – and the perils – of GitHub Copilot

There’s been a lot of talk about GitHub Copilot recently, loudly touted as Your AI pair programmer. According to GitHub, Copilot for Business brings the power of generative AI to engineering teams, accelerating the speed of software development and innovation.

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