The Bit Bucket

One of the things many people don’t know about me, is that I spent many years both playing and umpiring baseball. Clearly that’s not so common for Australians.

In many ways, the umpiring was probably the most interesting. I’ve umpired up to state level games, including the Pan Pacific games. It certainly teaches you how to deal with strong views effectively.

Most people have seen the classic images of managers/coaches racing out to have a very heated discussion with an umpire. I’ve had so many people asking me how I dealt with that when I was umpiring.

2025-07-09

Intellisense is one of the best things that’s ever been added to Visual Studio or to SQL Server Management Studio (SSMS). It’s hard to remember back to before it was added, or how we worked then.

I had a young friend from the United Kingdom who had just completed a Computer Science degree and one of the things that he was most proud of, is that he knew so many HTML tags and which attributes went with which tags. When I showed him HTML Intellisense in Visual Studio, I think he was about to cry.

2025-07-08

This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.

Section: Administration Level: Medium

Question:

You are reviewing database settings for a server.

You notice that one database has AUTO_CLOSE configured. Your model database does not have it enabled.

What is the most likely cause for that setting to be enabled, and what effect does enabling it have?

2025-07-07

Unlock your potential with Analysis Services !

We’re pleased to announce that this course is now available. We had so many requests for this course. You can find details of it here:

Analysis Services for Data Professionals

Are you ready to elevate your skills in working with Analysis Services?

Our comprehensive course is your gateway to becoming proficient at working with both SQL Server Analysis Services, and with Azure Analysis Services.

Ask Yourself:

2025-07-06

I mentioned in an earlier post that I think the online documentation is now superior to any version that you can install locally.

I particularly like the way that the online version is cross-version ie: each page covers all supported versions, instead of having a separate page for each version.

But one of the really big bonuses is that you also have the opportunity to change the documentation if you think it’s incorrect or you think it could be improved. Microsoft have placed all the documentation in a GitHub repository and you can change it. Doing so is easier than you might expect.

2025-07-06

I’ve heard several people complaining that Azure Data Factory (ADF) is expensive to use, and yet I’ve seen many others talking about it as a really low cost service.

So which is true?

Our experience

We’re very careful about which features of ADF that we use as there are a few that can increase the cost substantially. And without those, it becomes a very low cost service.

None of my current clients has any issue with ADF costs. The people that I hear complaining about the cost are using one or both of:

2025-07-05

Years ago, I used to always recommend that people install Books Online (BOL) on their systems. It’s ironic that it was called “Online”, given we’re really talking about “Offline”, but back when we first were talking about it, we were comparing it to a physical book, not to a live reference on a computer screen.

Nowadays though, I find that the version online is so far superior to the one that you can install locally, that I think it’s better to just use the online version. I particularly like the way that the online books are now cross-version ie: each page covers all supported versions, instead of having a separate page for each version.

2025-07-04

This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.

Section: Development Level: Medium

Question:

You are reviewing T-SQL code from an application.

You notice in the definition of some tables, the timestamp data type has been used. In other tables, the rowversion data type has been used for similar purposes.

2025-07-03

When I’m doing a lot of query editing, I often get a bit mesmerized, particularly if there’s a lot of manual copy and paste or cut and paste going on.

One thing that often drives me crazy is when I use Ctrl-C (ie: copy) when I meant to use Ctrl-V (ie: paste). Invariably, I do this when I have nothing highlighted at all. So not only did I not get the value pasted, I just copied an empty value into the clipboard.

2025-07-02

My friends at PackT recently sent me a review copy of fellow MVP Greg Deckler’s third edition of Learn Microsoft Power BI . It’s not released yet but is available for pre-order.

Production quality and additional resources

The book is written well and the copy and tech editing seem well handled.

I was particularly impressed to see that Art Tennick was a tech reviewer. I regularly mention Art’s books. I like the way he presents recipe style books. He did it with MDX and again with DAX. Many people don’t want a detailed coverage of a language, just a series of recipes on how to use it. That’s what some of Art’s books provide.

2025-07-01