Breaking Biometrics
Fingerprint readers on laptops are shown not to be as secure as they could be, and primarily because the manufacturers haven't done a good job implementing the secure protocols.
2023-12-11
170 reads
Security
Data Security and AI
Today Steve discusses an aspect of AI that many people are concerned about: data security. Read more and think about how this might affect your organization.
2023-11-27
294 reads
How to get your security team on board with your cloud migration
In this second part of the Q&A with Dustin Dorsey, we asked him about how to get buy-in from security teams who are cautious by nature, how to encourage the wider IT team to accept their recommendations, and what additional challenges highly regulated sectors like healthcare and finance face.
2023-11-17
Security in the cloud: Whose responsibility is it?
While the cloud is recognized as more secure than on-premises servers and infrastructures, it does come with the often talked about shared responsibility model. Cloud providers are responsible for security ‘of’ the cloud, while their clients are responsible for security ‘in’ the cloud. Find out more in this Q&A with Dustin Dorsey
2023-11-13
Bad Culture Bad Security
Another company has hard-coded credentials, which Steve feels are a sign of bad culture.
2023-10-23
181 reads
Practicing (Annoying) Better Security
Steve has had to change his security, which is good, but annoying.
2023-10-18
172 reads
2023-10-14
119 reads
Power BI Workspace Permissions and Roles
What are the Power BI workspace permissions and roles and how are they used?
2023-10-06
The Need for DevSecOps
DevOps is great, but Steve thinks we need to ensure we include security is a part of what we do when building and deploying software.
2023-10-02
157 reads
Rogue Colleagues
Can you trust your colleagues? We all want to, but there are always temptations, especially when life gets hard. Steve wonders today how we look at the issues of security inside of our organizations.
2023-09-06
139 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