2025-07-23
6,802 reads
2025-07-23
6,802 reads
This article shows the final step of an availability group creation, specifically for a distributed clusterless one.
2025-07-14
5,338 reads
Learn how you can integrate the SQL Server error logs into Crowdstrike for better analysis.
2025-03-17
1,386 reads
Keeping track of all the security related logs can be hard. Using your security team to shoulder some of the load can help. Learn how in this article.
2024-12-16
4,141 reads
create a sql server polybase scale out group in azure for free
2021-06-23 (first published: 2021-04-12)
2,159 reads
2021-05-26 (first published: 2021-04-30)
9,011 reads
Learn how to perform data filtering in Oracle Linux using a database link to SQL Server
2020-04-13
2,467 reads
As a database administrator, it's your responsibility to ensure the customer data won't get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two options, you have full control over your environment so you can know exactly […]
2020-04-02
1,338 reads
Learn how to restore sql server database using data management provider Rubrik REST API
2020-03-19
2,960 reads
Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
2020-02-24
5,685 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Telp/Wa 628218200203 Gedung Sutrado, Jl. Kenari 2 No.5 Lt. 1, RT.2/RW.3, Kenari, Kec. Senen,...
Telp/Wa 628218200203 Jl. Biak No.44 AB, RT.8/RW.11, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Telp/Wa 628217555651 Gedung Plaza Bank Index Ground, Jl. M.H. Thamrin No.57 Floor Suite GF-21,...
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