Metadata Driven Pipelines – Data Engineering with Fabric
This article explains metadata driven pipelines and shows an example in Microsoft Fabric.
Snake draft sorting in SQL Server, part 1
I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times
Exporting and Importing Registered Servers in SSMS
This article shows how to import and export a list of registered servers from SSMS.
Why Early Code Review is Important for Database Deployments
Today, Kendra Little talks about code reviews and why they should be done early.
Learning Spark SQL String Functions with Explanations and Code Examples
Learn how to use different Spark SQL string functions to manipulate string data with explanations and code examples.
One more reason to use foreign key constraints
Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]
Good Luck is Needed with Old Versions
Today, Grant talks about reasons that companies don't upgrade.
SQL Logic
In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code.
Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator
The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.
Toilets and Your Systems
Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Dewi Sartika Telp:cs.(0821)3111185
BCA KCP Dewi Sartika Telp:cs.(0821)3111185 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati,...
BCA KCP Menara Imperium Telpon/wa.0853.7373.7699
BCA KCP Menara Imperium Telpon/wa.0853.7373.7699.Jl. HR Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi, Kota...
BCA KCU DAAN MOGOT Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers