Last Restore of a Database – Back to Basics
In this article I explore the basics around how to determine when a database was last restored.
Related Posts:
Changing Default Logs Directory - Back to Basics January 4, 2018
SQL...
2016-12-20
51 reads
Jason Brimhall
Last Restore of a Database – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
678 reads
Login from an Untrusted Domain – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-11-08
521 reads
Login from an Untrusted Domain – Back to Basics
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Related Posts:
Summiting that Technical Challenge January 9, 2018
Connect To SQL Server - Back...
2016-11-08
15 reads
Finding Deprecated Uses in SQL Server
Do you know that your Server logs 300 million deprecation events a week? Do you know if code needs to be updated or how to find deprecated uses in...
2016-11-07
15 reads
Finding Deprecated Uses in SQL Server
How well do you know your environment? You probably know all of the jobs that are running, the frequency that...
2016-11-07
2,046 reads
Seattle SQL Pro Workshop 2016
Seattle SQL Pro Workshop 2016
You may be aware of an event that some friends and I are putting together during...
2016-10-24
555 reads
Seattle SQL Pro Workshop 2016
Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2016-10-24
10 reads
Database Dropped
What do you do when a developer comes to you and asks, “Where did the database go? The database was...
2016-09-19 (first published: 2016-09-09)
1,647 reads
Default Sessions – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-09-13 (first published: 2016-09-01)
2,455 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