Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:
Seagull Management
Management is important to ensuring the success of a team. Steve talks about an anti-pattern that is often used by poor managers.
Unlocking Power with Updatable Views in SQL Server
An updatable view in SQL Server is a view that allows modifications such as INSERT, UPDATE, or DELETE operations on the underlying tables through the view.
Kubernetes For Complete Beginners
Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential.
Do you listen to music when you work?
I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies? For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I […]
Identifying Customer Buying Pattern in Power BI - Part 1
In this article, we discuss market-based analysis techniques for customer purchasing patterns for different products over the years in Power BI.
Pagination and ordering by large values
Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing tagged questions on Stack Overflow. Nobody could consume all of the results in a single shot, and no site wants to spend the resources required to present them all to us
Full vs. Incremental Loads – Data Engineering with Fabric
Learn how to perform full and incremental loads in Fabric with a little SparkSQL.
Missing the Office
Steve talks about being back in an office today, at a customer where everyone comes in every day.
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
Bagaimana Cara Reschedule Tiket Batik Air
Reschedule tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
Bagaimana Cara Refund Tiket Batik Air
Refund tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
BCA Finance Kelapa Gading Layanan Mobil Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Ruko Mall Of Indonesia Blok B 32-33, RT.18/RW.8, Klp. Gading Bar., Kec. Klp....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers