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
52 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,822 reads
Learn about the new fuzzy matching functions in SQL Server 2025.
2026-06-01
1,903 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
4,743 reads
2026-05-29 (first published: 2026-05-06)
1,706 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
963 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,266 reads
Learn how to efficiently run SQL Server using Amazon Elastic Container Service for a hassle-free Docker container experience.
2026-05-25
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
You kick off a distributed job expecting it to finish in minutes — but...
A while ago we suddenly had an error while trying to deploy one Fabric...
Comments posted to this topic are about the item Secure Cached Plans
Comments posted to this topic are about the item Complex Data Processing with dbt...
Comments posted to this topic are about the item Over or Under Provisioned
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers