“Applies To…” in the MSDN Documentation
Quick little post. I just wanted to share how happy I am with the new “THIS TOPIC APPLIES TO” infographic....
2016-01-12
445 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Benefits from Data Lifecycle Management
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,751 reads
Learning R: Hard Lessons
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
971 reads
One More PASS Board Update for 2015
Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?
Never mind.*
Instead, it seems I’ll be...
2015-12-18 (first published: 2015-12-14)
1,260 reads
Speaker of the Month: December 2015
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
457 reads
Promote Community
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
493 reads
PASS Board Update: First Year
This represents my 12th month on the board so I thought I would recap my time there so you know...
2015-12-09
484 reads
Learning R: Foundations
Learning a programming language is largely an act of using that language to do stuff. Done.
However, the big thing about...
2015-12-07
1,262 reads
Changing Course On Learning
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...
2015-12-03
504 reads
It’s Not Too Late
You know you want to go on the SQL Cruise. You can. You just have to convince the boss that...
2015-12-01
481 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