The Bit Bucket

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

I’ve spent a lot of time lately considering the ethics surrounding AI usage in the workplace, but the title of a new book had me intrigued. I was sent a review copy of The Psychology of AI Adoption at Work: From Resistance to Results by the author.

Author

Dr. Gleb Tsipursky is a behavioural scientist, author and consultant who specialises in workplace change, decision-making and the future of work. He is the CEO of Disaster Avoidance Experts, a consultancy that helps organisations adopt new technologies and improve business performance. He previously spent more than 15 years in academia, including seven years as a professor at Ohio State University. He has written eight books and has been featured in publications including Harvard Business Review, Forbes and The New York Times, which described him as an office whisperer.

2026-11-06

As I’ve pointed out in other posts, Betteridge’s Law of Headlines says you already know that the answer to this is no.

There is a persistent myth among SQL Server users that having more indexes always slows things down, particularly anything that needs to modify data (INSERT, UPDATE, DELETE, MERGE).

However, there are two aspects of this to consider:

The first is that you need to decide how much the modifications actually matter in the overall performance of the system. In an earlier blog post, I noted that when I trace typical transactional systems, I often see reads making up about 99% of page I/O’s. Writes barely even appear. I’m not saying they are irrelevant but you need to focus on what the system is spending most of its time doing.

2026-11-05

The other day I posted a shortcut article about how to use SQL Server Management Studio (SSMS) to generate INSERT statements for data.

In one of the comments, a reader asked if there was a way to do that from the command line.

The answer is yes, sort of. Apart from a variety of 3rd party tools, a few years back, Microsoft released tools to do just that.

The easiest tool was probably mssql-scripter and you’ll find an intro to it here:

2026-11-04

In a previous post , I was discussing why magic values were a problem. They are often added by developers when they are trying to avoid having any NULL data in a database.

While discussing this, I think it’s worth also highlighting the overall dangers of placeholder values. These are values that aren’t magic values but are ones that are intended to be replaced at a later time.

If you use any of these, you need to have a solid process in place to:

2026-11-03

In recent years, I’ve done a lot of consulting work with companies who are involved in financial trading. Invariably nowadays, they have leaned heavily on using Python. I recently received an early review copy of Hands-on Financial Trading with Python (2nd Edition): Build, backtest, and deploy professional trading strategies using a proven end-to-end framework from my friends at PacktT.

NOTE: This is the second edition of this book. I haven’t previously read the first edition.

2026-11-02

Recently, I was having trouble saving a PowerPoint slide deck as a set of PNG files.

The error message said:

Sorry we couldn’t find slide1.PNG. Is it possible that it was moved, renamed, or deleted?

After trying to copy the slides into another deck to replace the original deck, the same problem existed. Saving in PPTX format was fine. Curiously, saving individual slides was also fine.

I found a few blog posts online that said it might be to do with an embedded period in the filename. That wasn’t the case but it gave me the clue that I needed.

2026-11-01

One of the interesting aspects of recent AI work is the idea that we’re fast moving beyond prompt engineering. Not that long ago, it was all the rage, so I was fascinated to receive a review copy of The Practical Prompt Guide for GPT-6 Astra from my friends at PacktT.

Author

Curiously, this book is listed as being written by Steve T. As noted on his official Leanpub biography page , the authors behind Steve Publications often choose to write under pseudonyms or partial names for privacy or professional reasons. Consequently, he only operates publicly under the name Steve. I’m not a fan of this as it limits his perceived authority.

2026-10-31

I was watching a preview (but public) presentation today, and I noticed the button in Power BI for a whole new way of creating reports said Modern Report. I really hope that it doesn’t get out the door with that name.

One thing the IT industry never seems to learn is that calling anything New or Modern is a mistake.

I was recently working with a client, and they were changing the working IT environments for their staff. What struck me as odd was that they called the new environments Modern. Amazingly, Modern was actually the name of the environment. I’m sure they currently see the environments as the modern ones, but soon enough, it won’t be modern or new, and then the name looks really, really odd.

2026-10-30

In previous reviews, I’ve mentioned that I spend much of my time nowadays working with Microsoft Fabric but in many of those projects, I still regularly need to use Power Query. Doing that effectively means using the M language. I was pleased to receive a review copy of The Definitive Guide to Power Query (M) from my friends at PacktT.

Authors

Gregory Deckler is a fellow Microsoft Data Platform MVP, actibe blogger and Fabric/PowerBI community member. He is the author of many books on related topics.

2026-10-29