Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel […]
Today Steve wonders if official solutions from a vendor are that important.
Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...
In part three of this series, Boris Novikov looks at how data is saved and modified in a temporal database and what kind of integrity constraints are needed for temporal tables. If you haven’t seen parts one and two, don’t worry! Links are provided in the article, and we recommend checking them out first.
In this article on Fabric we will examine how to get data from a REST API.
Today Steve wonders how many software developers use separate connections for reads and writes in their application.
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
Many of you can't choose your team, or even change teams if you want, but from an organizational perspective, it might be the right thing to do. Whether you like it or not.
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
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...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
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