Articles

rogrammatic interaction with SQL Server or Azure SQL from a Python script is possible using a driver. A popular driver has been pyodbc that can be used standalone or with a SQLAlchemy wrapper. SQLAlchemy on its own is the Python SQL toolkit and Object Relational Mapper for developers. In the end of 2025 Microsoft released v1 of their own Python SQL driver called mssql-python. How do you get started using mssql-python for programmatic access to your SQL Server?

2026-03-11

Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers

by mehul.bhuva@gmail.com

SQLServerCentral

Get a short introduction to Liquid Clustering in Databricks.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-03-09

2,650 reads

Discuss

Fun with JSON

by André

SQLServerCentral

Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2026-03-09 (first published: 2026-02-18)

4,463 reads

Discuss

SQL Server Long-Running Query Detection: How to Find and Monitor Slow Queries

by Additional Articles

SimpleTalk

Performance and Tuning

Monitoring and alerting can be overwhelming tasks, especially for those new to the world of managing production data. One common challenge for any data professional is the identification and management of queries that run for longer than they should.

2026-03-09

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

by John Miner

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

This article will use the incremental data load pattern to load data in our raw zone tables.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2026-03-07 (first published: 2025-12-10)

1,051 reads

Discuss

Supervised versus Unsupervised Training of an Artificial Neural Network

by Stan Kulp

SQLServerCentral

Supervised training of an artificial neural network entails training the network to associate defined patterns with specified labels. Optical Character Recognition is an example of supervised training, where each input pattern is mapped to an alphanumeric character. In unsupervised training, a neural network learns to extract recurring patterns from noisy data. One of the earliest […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2026-03-06

1,138 reads

Discuss

How to Help Copilot Encourage Good Database Standards

by Additional Articles

Brent Ozar Blog

Uncategorized

I know a lot of y’all lag behind on upgrading SSMS, but v22.3 just introduced something that you need to be aware of. It’s going to impact any of your users who DO upgrade their SSMS, or who use Github Copilot. There’s something that you can do in order to improve Copilot’s code quality and make it match your preferred coding standards.

2026-03-06