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
Call Center Batik Air Yogyakarta
Call Center Batik Air Yogyakarta dapat di lakukan menghubungi CS resmi Batik Air di...
Call Center Batik Air Medan
Call Center Batik Air medan dapat di lakukan menghubungi Layanan resmi Batik Air di...
Call Center Batik Air Tangerang
Call Center Batik Air Tangerang dapat di lakukan menghubungi Layanan resmi Batik Air di...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers