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

by Grant Fritchey

SQLServerCentral

Professional Development

Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.

Does Your GROUP BY Order Matter?

by Additional Articles

Brent Ozar Blog

T-SQL

Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:

Seagull Management

by Steve Jones

SQLServerCentral

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

by Prakash K

SQLServerCentral

Views

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

by Additional Articles

SimpleTalk

Virtualization, containers, and k8s

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?

by drsql@hotmail.com

SQLServerCentral

Database Weekly

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

by Farooq Aziz

SQLServerCentral

Power BI

In this article, we discuss market-based analysis techniques for customer purchasing patterns for different products over the years in Power BI.

Knowing What You Don’t Know

by Grant Fritchey

SQLServerCentral

Professional Development

Today Grant Fritchey warns us that what you don't know can hurt you.

Pagination and ordering by large values

by Additional Articles

SimpleTalk

T-SQL

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

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

Toilets and Your Systems

Does Your GROUP BY Order Matter?

Seagull Management

Unlocking Power with Updatable Views in SQL Server

Kubernetes For Complete Beginners

Do you listen to music when you work?

Identifying Customer Buying Pattern in Power BI - Part 1

Knowing What You Don’t Know

Pagination and ordering by large values

Blogs

Bicep Your Elastic Jobs

Check Azure SQL DB Space Used

Get row counts of all tables in a Microsoft Fabric warehouse

Forums

SSRS Web Service URL - getting rid of HTTP

SQL Server software and windows version compatibility level

Truncate tables where Referential Integrity exists

Question of the Day

Post Restore Tasks for the Resource Database