“How do I contribute to dbatools?” with Drew Furgiuele
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...
2018-02-06
114 reads
"How do I contribute to dbatools?" with Drew Furgiuele
Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...
2018-02-06
12 reads
Bug in SSMS V17.4
If you are using SSMS V17.4 as I am
You may encounter a weird error. This can be repeated as follows:
Open...
2018-02-06
513 reads
Learning Goals–January Review
In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks...
2018-02-05
398 reads
Wait Statistics on a Query
Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...
2018-02-14 (first published: 2018-02-05)
2,738 reads
SQL Homework – February 2018 – Work with security
This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts
Create a SQL login and a Windows authenticated login....
2018-02-05
311 reads
Forensic Analysis of Log files in SQL Server
The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...
2018-02-05
3,464 reads
Giving back – Speaking Mentors
I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who...
2018-02-05
338 reads
PASS Summit 2017 Wrap-Up - The People!
I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...
2018-02-05
10 reads
Power BI with Azure Data Lake - where the water doesn't run dry
(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in...
2018-02-04
730 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