The Bit Bucket

SSMS: Making sense of the colors in the SSMS scroll bar

SSMS: Making sense of the colors in the SSMS scroll bar

In an earlier post, I described how I didn’t particularly like all the colors that are shown in the scroll bar now in SQL Server Management Studio (SSMS):

In that post, I described how to turn them all off, or at least how to kill off some of them. But, of course they are there for a reason. Instead of turning them all off, you might decide to make sense of what they are there for.

2026-11-16

Book Review: Apache Kafka in Action

Book Review: Apache Kafka in Action

I come across Apache Kafka at client sites quite often now. I recently purchased Apache Kafka in Action to find out what the authors really think about it.

Authors

Alexander Kropp is an architect and trainer in communications networks and cloud computing.

Anatoly Zelenin is an expert and trainer in Apache Kafka.

Both authors are part of the DataFlow Academy , a European training and consulting company.

Apache Kafka in Action

Apache Kafka is one of those technologies that seems quite simple when someone first explains it. Applications produce messages, other applications consume them, and Kafka sits in the middle. What could be easier? Of course, once you start thinking about reliability, ordering, performance, replication, and operating the system in production, things become considerably more complicated. That is where this book really earns its place.

2026-11-15

SDU Tools: SQL Variant Info for T-SQL

SDU Tools: SQL Variant Info for T-SQL

If you aren’t aware of the SQL Server data type called sql_variant, don’t feel bad; you’re not alone. Many people who’ve worked with SQL Server for a very long time haven’t used it.

sql_variant is a very special data type. It’s the data type that you use when you need to store other data but you’re not sure what type you will need to store. Once it is stored though, it has the appropriate data type.

2026-11-14

Book Review: Azure SQL Hyperscale Unveiled

Book Review: Azure SQL Hyperscale Unveiled

So much of my recent work has been around Azure SQL Database, and Fabric Warehouse. But in terms of Azure SQL Database, the Hyperscale tier is the one I haven’t used as much. So I was pleased to see a new book from an old friend (Bob Ward from Microsoft) that covers it. Azure SQL Hyperscale Unveiled: The Cloud SQL AI Database for Everyone .

Author

Bob Ward is a Principal Architect for the Microsoft Azure Data team that owns the development of Microsoft SQL. I’ve been involved with SQL Server since 1992 and Bob is one of the few people at Microsoft that I can recall having been there pretty much the whole time. Bob knows what he’s talking about with both SQL and with baseball. (I’ve enjoyed discussing that with him over the years).

2026-11-13

SQL: Implicit vs Explicit Transaction Handling - JDBC Driver I'm looking at you

SQL: Implicit vs Explicit Transaction Handling - JDBC Driver I'm looking at you

In a relational database like SQL Server, transactions are the mechanism used to ensure that entire operations either complete or are rolled back. They are a core part of the Atomicity: i.e., the A in ACID.

Typical example

The obvious example used to be that if you transfer funds from one place to another, that both the debit and the credit need to occur, or neither occurs.

Fair enough and straightforward enough.

2026-11-12

DevOps: To branch or not to branch

DevOps: To branch or not to branch

One of the discussions that comes up from time to time when working with DevOps is branching strategy.

Common strategy

The general strategy nowadays is to have a main branch (used to be called master) that is used for deployment. When features are being developed, a feature branch is forked from the main branch, the changes are built and tested, and then the feature branch is merged back to the main branch.

2026-11-11

SDU Tools: Update Statistics on SQL Server Tables

SDU Tools: Update Statistics on SQL Server Tables

Having up to date statistics is critical for SQL Server choosing appropriate query plans. Poor statistics can lead to poor query plan outcomes.

Generally, SQL Server manages this well by itself. As a rough rule, most versions auto-update statistics when the number of changes is about twenty percent of a count of the number of rows in the table. (Some recent changes have slightly altered how this works but the ball park is pretty good).

2026-11-10

SQL: Should you use bit columns?

SQL: Should you use bit columns?

I’ve previously discussed why bit columns can be useful in SQL Server Indexes. But an interesting question is whether you should use them at all.

I previously showed an example of a transaction table that had an IsFinalized column. And if it did, then it’s very likely that I’d want to have it indexed. But what I didn’t discuss was whether that bit column made sense in the first place.

2026-11-09

PG Down Under is now PGSQL Down Under

PG Down Under is now PGSQL Down Under

A few years back, I created a new podcast to focus on PostgreSQL. I had already registered a number of down under names like sqldownunder.com, cosmosdownunder.com, fabricdownunder.com and so on. So it seemed logical to register pgdownunder.com. I checked and it was available so I used it for the podcast, and have done ever since.

A while back though, I became aware of a local PostgreSQL conference, and that they called it PG Down Under. Curiously, they hadn’t registered that name, or even the .org variant.

2026-11-08

SQL - Fabric: FABCON and SQLCON are coming to Sydney in April 2027 - Discounts now

SQL - Fabric: FABCON and SQLCON are coming to Sydney in April 2027 - Discounts now

It’s awesome that FABCON is coming to Sydney early next year. It’s now one of the best conferences each year globally and has loads of Fabric and SQL goodness. Our friends at Microsoft have provided this info to let you get an early bird discount.

Register today and Save AUD$300 with code: FABSQL-UG

The APAC Microsoft Fabric + SQL Community Conference (6–9 April 2027, ICC Sydney) brings together data, analytics, BI, and AI professionals from across Asia-Pacific. Hear from Microsoft and community experts with practical guidance, real-world patterns, and lessons learned.

2026-11-07