Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{
"comments":...
2018-04-05
334 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location":...
2018-04-05
13 reads
What is a Foreign Key & How many foreign keys can you have on a single table?
Yesterday, I was attending a database design meeting. In the meeting, I was asked one of the questions – “How many...
2018-04-12 (first published: 2018-04-05)
12,138 reads
Extending built-in data types
add generic user defined table data types as extension to built-in ones
2018-04-05
164 reads
Farewell, Robert Davis
Robert Davis (@SQLSoldier) died on Monday. A great technical guy, he did a lot of writing and presenting and answering...
2018-04-13 (first published: 2018-04-04)
3,140 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-04
129 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-04
140 reads
Why didn't my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-09 (first published: 2018-04-04)
1,662 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn't have any debugging information enabled...
2018-04-04
19 reads
Encrypting SQL Server Database Backups
We all go to great lengths to make sure that our databases are secure (or at least I really hope...
2018-04-09 (first published: 2018-04-04)
2,497 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