The Bit Bucket

I’ve been a big fan of Shaun Micallef for many years. So I was very excited to listen to his new book Tripping Over Myself, A Memoir of a Life in Comedy both to learn more about his background, and to hear his thoughts on it.

I truly appreciate his sense of humour, and as someone who speaks publicly regularly, I appreciate watching his timing and delivery. That’s the number one reason why I wanted to listen to this on Audible rather than reading the book. Shaun reads the book himself, and I knew that hearing him deliver the content would add to the value it brings.

2023-07-29

On July 27th 1993, Microsoft released Windows NT, the forerunner to the versions of Windows we use today, particularly the server versions.

If you’re old enough, one thing you’d remember about this event is how signficant it was. At the time, if you wanted a server-based operating system on a PC, you didn’t have that many choices. We were predominantly using variants of Unix, most commonly Xenix.

Importantly, most other server systems were largely text-based. With Windows NT, Microsoft brought the power of a graphical interface to mass market server operating systems.

2023-07-27

I had an email from a friend today where he asked what was wrong with SQL Server, and wondered if ROUND() didn’t go to the same school that he did.

The example was:

SELECT '0.5' [SOURCE VALUE], '1' [SHOULD ROUND TO], ROUND('0.5',0) [SQL SAYS]
UNION
SELECT '1.55', '1.6', ROUND('1.55',1)
UNION
SELECT '94.55', '94.6', ROUND('94.55',1);

The output was:

What was puzzling him is why SQL Server’s ROUND was converting 94.55 to 94.5 and not 94.6. Now writing numbers as strings is problematic to start with, but that aside, he was puzzled by the output.

2023-07-11

I’m a fan of Seth Godin, and have always enjoyed listening to him. Recently I finished listening to Leap First on Audible. 

When I started listing to this book, I didn’t quite know what to make of it. I always enjoy Seth’s anecdotes. At first, the book seemed more like a series of anecdotes than an in-depth treatment of the topic. It seemed to lack a continuous train of thought. I started feeling like I was listening to a collection of anecdotes from Seth, rather than a “real” book.

2023-07-06

Ever since I watched Professor Alice Roberts’ series on travelling Egypt by Train, I’ve been quite a fan of her work. (It also means I probably came to knowing about her later than I should have). Since then, I’ve been working through a number of her books. On Audible, I just finished listening to The Incredible Unlikeliness of Being.

Amongst many other things, Alice is an English biological anthropologist. She also worked as a doctor in the National Heath Service in Wales for a while, but she left clinical medicine to focus on anatomy.

2023-06-11

I’ve previously posted about the procedure ListUseOfDeprecatedDataTypes in our free SDU Tools for developers and DBAs. I mentioned that I’m often reviewing existing databases and one of the first things I go looking for is the way they’ve used data types, and that in particular, I’m keen to know if they’ve used any deprecated data types (i.e. ones that will/might be removed at some point).

The procedure was updated in version 21 to now include a ChangeScript column. (Thanks to Michael Miller for the suggestion).

2023-06-02

This is part 3 of a series on working with change data capture (CDC) in Azure SQL Database. This part discusses how to enable it and how to use it.

To show how this works, I have created an Azure SQL Database called CDCTest. I created it as a DTU-based database with a service level objective (SLO) of S3. I’ll discuss more about the licensing implications of CDC in part 4.

2023-06-02

I’ve mentioned in a previous post how important I think Microsoft Fabric is going to be.

So, in addition to our existing SQL Down Under, and Cosmos Down Under podcasts, we have a brand new podcast called Fabric Down Under.

In the preview for Microsoft Fabric, one of the key participants from the product group has been Pawel Potasinski. I’ve known Pawel for many years and he’s been the driving force behind many important things. It was great to see him driving community around Microsoft Fabric in preview.

2023-05-24

Microsoft has had a strong lead in BI and analytics for a long time now. The introduction of the tabular data models in 2012 was a watershed moment.

Today, they have announced a private preview of Microsoft Fabric. It’s a bigger deal than the tabular model was, and will set the direction of BI tooling for a long time to come.

The opposition was already struggling to keep up, and in fact, hadn’t managed to do so. Microsoft Fabric will up the ante much, much higher than where we already were.

2023-05-24

I recently noticed a blog post from Jay Gordon that was calling out interesting content from Blaize Stewart on antipatterns for development with Azure Cosmos DB.

I thought this would be a perfect topic for one of our Cosmos Down Under podcasts and Blaize agreed to take part.

So much content talks about what to do with a product, and even though everyone knows there are things you shouldn’t do, very little content talks about these antipatterns. It was great to speak to Blaize about it, and to get his updated thoughts.

2023-05-17