SQL Prompt – Killing the Detail Box
I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts...
2015-04-15
752 reads
Have you tried DLM Dashboard?
DLM Dashboard is a new product from Redgate Software that’s free. Free as in beer, which should be attractive to...
2015-04-15
935 reads
Types of NoSQL databases
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the...
2015-04-15
1,779 reads
Quickly Check If SSL For SQL Is Enabled - WaterOx Consulting
Reading Time: 2 minutesTo quickly check SSL is configured on your SQL Server you can...
The post Quickly Check If SSL...
2015-04-15
706 reads
Deleting Files Older than X Hours with PowerShell
(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").
--
I currently have a situation at a...
2015-04-15
33,709 reads
How Do You Visualize Abstractions?
#SQLNewBlogger
Some time ago, my kids asked me what I do for a living. I told them I work with databases.
“What’s...
2015-04-15
616 reads
SQL New Blogger Digest - Week 2
I didn’t intend for last week’s digest to also be my post for week two of the challenge, but life got in the way and I wasn’t able to...
2015-04-15
23 reads
Extended Events and Data Types
Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY). This month we have an open invitation from Mike Donnelly (blog | twitter), asking...
2015-04-14
8 reads
Extended Events and Data Types
Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY).
This month we have an open...
2015-04-14
907 reads
T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode
It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you...
2015-04-14
703 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
Alamat BCA KCP Pasar Kenari Telp:08218200203
Telp/Wa 628218200203 Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, RT.2/RW.3, Kenari, Kec. Senen,...
Alamat BCA KCP Biak Telp:08217555651
Telp/Wa 628218200203 Jl. Biak No.44 AB, RT.8/RW.11, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Plaza Index Telp:08217555651
Telp/Wa 628217555651 Gedung Plaza Bank Index Ground, Jl. M.H. Thamrin No.57 Floor Suite GF-21,...
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