Basic Checks on a New AWS RDS SQL Server
When you first become responsible for a new RDS instance, what do you do? Kenneth Igiri gives you a few queries to get you started.
2022-12-14 (first published: 2022-11-30)
946 reads
Cloud Computing
Basic Checks on a New AWS RDS SQL Server
When you first become responsible for a new RDS instance, what do you do? Kenneth Igiri gives you a few queries to get you started.
2022-11-30
3,323 reads
Cloud First Software
Many software packages are moving to the cloud, but Steve doesn't like to see this without some ability to extract data.
2022-12-23 (first published: 2022-11-30)
144 reads
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-23 (first published: 2022-11-21)
560 reads
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-21
3,215 reads
2022-10-28
365 reads
Things I've Learned About the Cloud
Steve shares a few things he's learned from customers trying to migrate their systems to cloud computing platforms.
2022-10-10
251 reads
Cloud Databases
There are advantages of cloud databases when your workload requirements grow. Steve thinks it's useful to learn a bit about the options out there.
2022-09-30
570 reads
Custom SQL Server on RDS
SQL Server on RDS has a more configurable option that allows you to meet the specific requirements of your application in a similar was as you would on-premises, while still being a managed service.
2022-09-21
227 reads
New Cloud Licensing Limits
New licensing rules are coming for using your SQL Server licenses in the cloud.
2022-09-03
236 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