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.
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.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers