AI Can Improve Healthcare
One area where AI has found some traction is in the healthcare industry, where is seems to be helping improve care.
2021-02-08
259 reads
Artificial Intelligence (AI)
The Degradation of the Turing Test
Are computers getting smart enough to pass the Turing test or are humans getting worse at representing themselves as intelligent?
2020-10-15
261 reads
AI Data
Data is important for AI projects, but the ethics and privacy implications are complex. A new project from Microsoft aims to help users control their data and make it available for use.
2020-10-07
124 reads
The Computing Revolution
Steve reflects on some of the ideas of how Microsoft imagines the future of computing.
2020-07-27
133 reads
Smarter Design
Many of us have used PowerPoint, which has grown smarter through the use of Machine Learning.
2020-05-13
193 reads
Where AI Shines
Artificial Intelligence hasn't always worked well, but there is one place that is seems to have lots of potential.
2020-04-29
124 reads
How Much AI Do We Need?
AI seems to be invading many different parts of our life. Today Steve wonders how much we really need.
2024-12-30 (first published: 2020-04-20)
536 reads
The Evolution of AI
Artificial Intelligence systems might dramatically change our world, but they need lots of help and work to get better.
2020-03-03
136 reads
A Dearth of Data
A new technique developed by Microsoft is designed to help AI/ML models get trained with minimal data.
2019-12-26
168 reads
The AI Manager
AI software is being used to manage the daily work of some employees. Is this a trend that is good or bad?
2019-07-18
196 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