Least Privilege
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
2024-07-15
183 reads
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
2024-07-15
183 reads
Schools often lack resources and struggle to protect themselves. An interview shows one district doing well, with some lessons for those of us in other organizations.
2024-07-06
65 reads
An alert from the US government says that SQL Injection isn't an acceptable problem.
2024-06-19
314 reads
2024-03-02
55 reads
Steve thinks AI might have a place in security, something Microsoft is investigating now.
2024-03-01
121 reads
Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.
2024-02-07
158 reads
2024-01-08
464 reads
Docker is an open-source platform that enables developers to automate the deployment and management of applications using containerization. It was created by Solomon Hykes and his team at Docker, Inc., and was first released in 2013.
2023-12-25
Steve has been doing a cybersecurity advent challenge and has found it to be interesting, fun, and career building.
2023-12-22
143 reads
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
2,141 reads
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Short version You want to get this running as fast as possible. Do these...
I changed my email address in Edit Profile page, but it has no effect...
Comments posted to this topic are about the item The case for "Understanding our...
Comments posted to this topic are about the item Specifying the Collation
I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'
SELECT p.PersonType,
p.Title,
p.LastName,
c.CustomerID,
c.AccountNumber
FROM Person.Person AS p
INNER JOIN Sales.Customer AS c
ON c.PersonID = p.BusinessEntityID
COLLATE @c
Will this solve my problem? See possible answers