How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
This article explains how I use sqlpackage to detect schema drift and generate a delta script that shows exactly what’s different.
2026-03-13
2,471 reads
This article explains how I use sqlpackage to detect schema drift and generate a delta script that shows exactly what’s different.
2026-03-13
2,471 reads
SSMS 22 has several new features. Is there a compilation list of the new features? How will these features help me as a SQL Server professional?
2026-03-13
The next installment of the Fabric Modern Data Platform looks at Spark pools for executing code.
2026-03-11
1,907 reads
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
Get a short introduction to Liquid Clustering in Databricks.
2026-03-09
3,209 reads
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 […]
2026-03-09 (first published: 2026-02-18)
5,143 reads
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
This article will use the incremental data load pattern to load data in our raw zone tables.
2026-03-07 (first published: 2025-12-10)
1,419 reads
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 […]
2026-03-06
1,284 reads
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
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers