Protecting Yourself from Identity Theft
I don't have a lot of good news for you. The truth is there's nothing we can do to protect our data from being stolen by cybercriminals and others....
2019-05-06
Security
Docker Database Hacked, 190,000 Users Affected
The hackers collected usernames, hashed passwords and in some cases GitHub and Bitbucket access tokens used to access repositories on the popular Git platforms many developers use for version control.
2019-05-03
Data Breaches: All Your Fault
The more Grant Fritchey reads about data breaches, the more he realizes: It’s You. It’s your fault.
2019-05-02
2019-04-29
804 reads
Disabled Database User?
In my many years of working as a DBA, I have encountered many disabled logins. However, I have never really encountered what looks to be a disabled database user account. I didn’t even think it was possible to disable a user account in a SQL Server database.
2019-04-26
Password1, Password2, Password3 no more: Microsoft drops password expiration rec
For years, Microsoft's baseline security policy has expired passwords after 60 days.
2019-04-25
The top five vulnerabilities that could lead to a cyberattack
Have you ever wondered how devastating a cyberattack could be for your enterprise? A recent study by Poneman determined that the average cost of&
2019-04-24
Data Breaches: All Your Fault
One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws. I also have to...
2019-04-22
Security Scar Tissue Can Make Organizations Smarter and Stronger
IT pros slammed again and again by security breaches can become desensitized--or they can gain strength from the experiences.
2019-04-22
2019-04-22
1,141 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
Alamat BCA KCP Batu Ceper Telp:08218200203
Telp/Wa 628218200203 Jl. Batu Ceper No.18 A-B, RT.1/RW.2, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Kartini Telp:08218200233
Telp/Wa 628218200233 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2, Kartini,...
Alamat Bank BCA Wisma 46 Telp:08217555651
Telp/Wa 628217555651 Wisma 46 Lantai Dasar, Jln. Jend. Sudirman Kav. 1, RT.5/RW.3, Senayan, Kec....
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