Introduction When developers first learn SQL aggregation, they usually start with the GROUP BY clause. It works well for summary reports because it combines multiple rows into a single result for each group. For example, you can calculate total sales per region or average salary per department. The limitation of GROUP BY appears when you […]
2026-06-05
44 reads
Data build tool (dbt) is an open-source command line tool that helps engineers transform data using SQL scripts. However, there are limitations to what can be done with the Structure Query Language (SQL). That is where dbt Python models can be used to perform complex tasks. A dbt Python model is a function that reads […]
2026-06-03
1,251 reads
2026-06-03 (first published: 2026-05-06)
1,774 reads
I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]
2026-06-02 (first published: 2024-09-06)
6,867 reads
Learn about the new fuzzy matching functions in SQL Server 2025.
2026-06-01
2,281 reads
Explore how Andrej Karpathy’s “vibe coding” trend reached databases. Uncover risks, real incidents, and 5 critical failure patterns
2026-06-01
SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.
2026-05-29
5,026 reads
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses. It already assumes that data is extracted and loaded into raw tables. The dbt core framework is written in Python with the translations defined as a combination of SQL scripts, Jinga Template Language, and YAML […]
2026-05-27
995 reads
Learn how to choose which application to move first in a cloud migration with five practical guidelines
2026-05-27
Learn about how you can better prompt your AI Assistant in solving problems and producing code.
2026-05-25
3,335 reads
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
By Arun Sirpal
Second in a series on Ai and databases. One Story, three signals – I...
I’ve been working on a project that combines two things I spend a lot...
Are there any good articles on all the trace flags that are enabled on...
Comments posted to this topic are about the item The Data Model Matters
Comments posted to this topic are about the item Understanding SQL Server PARTITION BY...
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers