Power BI Custom Visuals Class (Module 38 – Mekko Chart)
In this module you will learn how to use the Mekko Chart Power BI Custom Visual. The Mekko Chart visual...
2017-02-14
885 reads
Blog Posts
Server level database permissions
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...
2017-02-14
735 reads
T-SQL Tuesday #87 – Beware the Shiny New Toys
Today is yet another T-SQL Tuesday – the monthly blogging party started by Adam Machanic (b|t) to get everyone in the...
2017-02-14
449 reads
T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT
Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.
Splitting Strings in SQL
A problem that has plagued SQL developers through...
2017-02-14
445 reads
T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query
Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...
2017-02-14
697 reads
Valentine's day love from Learning Tree...
The latest course offer is in from Learning Tree!! And It's Valentine's Day!
Learning Tree are showing you the love with...
2017-02-14
341 reads
Altering a Job Step on Hundreds of SQL Servers with PowerShell
I flew to Utrecht last week to present with Chrissy LeMaire and Sander Stad to present to the joint Dutch...
2017-02-13
430 reads
Dynamically Changing Shapes in Power BI
UPDATE: I also published a blog post using a DAX only approach. Check it out here.
Recently someone had a question...
2017-02-13 (first published: 2017-02-07)
3,000 reads
Export All Plans From Cache to a .SQLPLAN File
I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file....
2017-02-13
868 reads
Implementing Fuzzy Sets in SQL Server, Part 8: Possibility Theory and Alpha Cuts
By Steve Bolton
…………To get the point across that fuzzy sets require membership grades of some sort, throughout this series I’ve...
2017-02-13
943 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
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Alamat BCA KCP Cideng Timur Telp:0821-8200-203
Telp/Wa 628218200203 Jl. Cideng Timur No.11 F, RT.5/RW.4, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP KEM Tower Telp:0821-8200-233
Telp/Wa 628218200233 Kem Tower, Jl. Landas Pacu Barat No.Kav 2 Blok B, RW.10, Gn....
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