Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out...
2018-02-04
528 reads
Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out of SQL Server. The development environment, BIDS...
2018-02-04
7 reads
Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into...
2018-02-04
91 reads
Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into...
2018-02-04
90 reads
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in...
2018-02-03
773 reads
Data Virtualization vs. Data Movement
I have blogged about Data Virtualization vs Data Warehouse and wanted to blog on a similar topic: Data Virtualization vs. Data Movement.
Data...
2018-02-02
73 reads
Data Virtualization vs. Data Movement
I have blogged about Data Virtualization vs Data Warehouse and wanted to blog on a similar topic: Data Virtualization vs. Data Movement.
Data...
2018-02-02
1,343 reads
Trello – Integrations
In December I wrote about working from home in which I talked about Trello. Trello is a virtual kanban board...
2018-02-02
102 reads
Trello – Integrations
In December I wrote about working from home in which I talked about Trello. Trello is a virtual kanban board...
2018-02-02
446 reads
Top Five Backup and Recovery Plans for SQL Database
Introduction
Creating a good backup and recovery plan for SQL database is a very important task of a database administrator. A...
2018-02-02
2,442 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