2024-11-08
339 reads
Encryption
No Backdoors
Governments want backdoors built into encryption software, which Steve thinks is a bad idea.
2024-09-23
103 reads
Searching an Encrypted Column
This article examines the challenges with searches on encrypted data and presents a possible solution that you might use to speed up those queries.
2023-12-15
1,884 reads
2023-11-01
335 reads
2023-10-18
340 reads
2023-10-04
335 reads
2023-09-27
351 reads
2023-09-06
344 reads
2023-06-09
278 reads
2023-05-29
304 reads
Blogs
How-To Convert Excel Date & Time to SQL
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
SQL in 2025: Still the King of Data
Data's the new oil, and SQL is your refinery. It's still the go-to language...
Drop roles in Postgres
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Forums
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide
Comments posted to this topic are about the item Creating a Linked Server in...
Dates and Languages
Comments posted to this topic are about the item Dates and Languages
Question of the Day
Dates and Languages
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers