Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but you have no idea what it would actually cost? ?? That’s the scariest thing, and...
2026-06-25
169 reads
There are some telltale signs that your growing business has outgrown Excel for your reporting needs. Excel is probably the most adopted piece of software out there, and I...
2026-06-08 (first published: 2026-05-20)
408 reads
Are you currently using Microsoft Fabric or considering migrating to it? If so, there are a couple of options to significantly reduce your monthly running costs. Firstly, there’s the...
2026-06-01 (first published: 2026-05-14)
374 reads
You could be tolerating limited reporting because there isn’t an off the shelf solution that meets your needs and you’re scared about the costs of a fully bespoke reporting...
2026-03-04 (first published: 2026-02-22)
401 reads
Do you spend so long manipulating your data into something vaguely useful that you don’t have the time to focus on analysing the what the data is telling you?...
2026-02-25 (first published: 2026-02-14)
240 reads
There are some fundamental boxes that your reporting system must tick. ✅ The figures must be accurate A good reporting solution can be trusted. A bad one causes confusion...
2025-11-21 (first published: 2025-11-02)
452 reads
The issue When migrating the solution I’m currently working on to Azure eight months ago I was initially looking at transferring the SSIS packages that performed the ETL. We...
2020-05-07 (first published: 2020-04-27)
348 reads
My next tip is to test your BI solution with the volume of data that you are expecting. This is...
2019-03-13 (first published: 2019-02-25)
1,992 reads
In this article I’m going to show you how I build my time dimensions. There are lots of different ways...
2019-02-26 (first published: 2019-02-04)
3,927 reads
In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse. And...
2019-02-18 (first published: 2019-01-28)
4,031 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers