Digging into an AI Algorithm
One place where Artificial Intelligence systems might shine is the medical field.
2022-08-03
175 reads
Artificial Intelligence (AI)
AI Ethics
I found this article to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many […]
2022-07-25
123 reads
2021-11-24
259 reads
2021-09-17
167 reads
Where We Need Better AI Disclosure and Responsibility
The way that AI is used in the world can make it better, but not always. In either case, we ought to have some accountability for the models.
2021-09-01
214 reads
How Often Do You Patch?
Patching is a chore that any system administrator needs to deal with. As SQL Server 2016 moves out of mainstream support, Steve asks if you have a plan and how often you ensure systems are patched.
2021-07-23
268 reads
Seriously Real Time Data Processing
Autonomous cars provide a great environment for large scale, real-time data processing.
2021-07-19
418 reads
Lots of Data and AI Helping Firefighters
Using AI/ML to help process large amounts of data allows us to tackle problems that we might not otherwise be able to work on.
2021-06-21
160 reads
Finding Legal Data
Using data scraped from the web might be convenient, but is it legal. Perhaps more importantly, is it moral? Steve has a few thoughts.
2021-04-19
172 reads
Disclosing the How
As we use more Artificial Intelligence and Machine Learning tools in our applications, we need to understand how they work.
2021-03-08
72 reads
Blogs
Finding the Last Last Name in SQL: #SQLNewBlogger
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
SQL Server 2025 GAs Today
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
Forums
Email change does not work
I changed my email address in Edit Profile page, but it has no effect...
The case for "Understanding our business" training
Comments posted to this topic are about the item The case for "Understanding our...
Specifying the Collation
Comments posted to this topic are about the item Specifying the Collation
Question of the Day
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