The Bit Bucket

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:

If you are SELECTing from a table and the ORDER BY clause in your query is in the same order as a non-clustered index, will the non-clustered index be used?

Answer:

It might or it might not.

2025-12-19

I recently received a review copy of DAX for Humans: The No CALCULATE Guide that Makes DAX Easy by Greg Deckler from my friends at PackT.

Author

Greg Deckler is the vice president of a global consulting services company. He’s a fellow Data Platform MVP and an active data community member. Greg also wrote DAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence .

Content

If you’ve worked with Power BI or semantic data models for any length of time, you’ve probably encountered the same challenge millions of others have: DAX is powerful… but it often feels unnecessarily difficult to learn. Much of that frustration stems from the traditional teaching approach, which centers heavily on the CALCULATE function — arguably the most complicated and unintuitive function in the entire language.

2025-12-18

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: Intro

Question:

A developer in your team has suggested that better formatted and laid-out SQL code will perform better?

Is this true?

Answer:

Because the optimiser reduces queries down to a format that it can work with the format of your code doesn’t make a difference. Better formatted code is more readable and maintainable though, so it’s always a good idea.

2025-12-17

SQL Server has a number of built-in database roles. The ones I see used the most are db_datareader and db_datawriter. They let you either read from all tables or read and write from all of them. Curiously, what has never been supplied is a db_procexecutor.

Developers and administrators who set up the use of these permissions think they are at least not using dbo or sa and while that’s true,

2025-12-16

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 have created a table named dbo.Customers. The column CustomerID has been declared as

INT NOT NULL IDENTITY(1, 1)

No contraints are defined on the table.

Can the CustomerID contain a duplicate value? If so, how?

Answer:

2025-12-15

More Microsoft Fabric love !

Turn data into insights the moment it happens because yesterday’s data is already too late !

We’ve added more Microsoft Fabric love to our courses. We’re pleased to announce that our new course Mastering Microsoft Fabric Real-Time Intelligence is now available. This is another course that we’ve had so many requests for. You can find details of it here:

Mastering Microsoft Fabric Real-Time Intelligence

Do you need to master Real-Time Intelligence in Microsoft Fabric?

2025-12-14

One of the most important tables in any business intelligence style analytic system is a Date table.

In most formal documentation, that’s ironically referred to as a time dimension, but in so many systems, time isn’t part of it. That’s because the exact time that something happened often isn’t of interest for the aggregated data that often forms the majority of analytic analysis.

Storing time?

Do we ever store the time though?

2025-12-13

I recently received a review copy of Introduction to .NET Aspire: Mastering Cloud-Native Microservices Development with .NET Aspire by Naga Santhosh Reddy Vootukuri and Tommaso Stocchi from my friends at BPB Publications.

Authors

Naga Santhosh Reddy Vootukuri works for Microsoft as a Principal Software Engineering Manager in the Azure SQL product. He has deep knowledge in cloud computing, distributed systems,AI, microservice-based architecture, and cloud-native apps. Santhosh has authored and published numerous research articles in peer-reviewed and indexed journals and in major trade publications. He is a core MVB blogger at DZone and an active senior IEEE member handling various conferences as technical chair in the Seattle IEEE region. Naga has been awarded the prestigious Docker Captain membership program for his outstanding contributions to the Docker and containers community.

2025-12-12

When you create a new query file in SSMS, it automatically becomes part of a solution. You can view it in Solution Explorer. In this example, I have created two query files, and renamed the tabs without saving them, as Query 1 and Query 2:

They are in the Miscellaneous Files section as they weren’t part of a script project.

SSMS can now compare multiple files. If I highlight both the files, and right-click, I get this option:

2025-12-11

One surprise in the release plans for SQL Server 2025 is that SQL Server Reporting Services (SSRS) is being discontinued as a brand. If you have a paid license for SQL Server, you are now able to install Power BI Report Server. Previously, that option required you to have an Enterprise Edition license for SQL Server or a premium level license for Power BI.

But Reporting Services was also previously available for SQL Server Express. That will no longer be supplied, and there’s no option to use Power BI Report Server.

2025-12-10