The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,302 reads
Adam Aspin
Adding Time Intelligence to a Power BI Data Model
In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data
2017-10-27 (first published: 2016-06-06)
7,142 reads
Adding Slicers to a Reporting Services Report
This article shows you how to create dynamic slicers from a data set in an SSRS report
2016-08-05 (first published: 2015-04-23)
16,939 reads
Third Party Visuals in Power BI Desktop
Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals
2016-05-31
11,137 reads
Sharing on-premises SQL Server Data Analyses in the Cloud with Power BI
In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data
2016-05-23
1,452 reads
Do It Yourself Load Balancing with SSIS
This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database
2015-08-03
7,124 reads
Data Load Optimisation using the SSIS Balanced Data Distributor
Optimize SSIS data loads using parallel processing and the Balanced Data Distributor
2015-07-02
7,606 reads
Interactive Parameter Selection with Reporting Services
Revamp the classic Reporting Services interface with a more modern look and feel adapted to mobile BI
2015-05-21
8,848 reads
Maps in SQL Server Reporting Services
Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.
2015-04-13
10,184 reads
Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
24,659 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
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