Ransomware vs. AI
Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.
2024-02-07
158 reads
Artificial Intelligence (AI)
Python script to write SQL using Amazon Bedrock Generative AI
In this script we will leverage the capabilities of Amazon Bedrock's Generative AI service to author SQL statements.
2024-02-03
617 reads
Leveraging AI Tools for SQL Queries
This article covers the basics of how different AI tools can be used to write SQL.
2024-02-09 (first published: 2024-01-19)
8,438 reads
Has AI Changed Software Development?
Generative AI is everywhere, but especially in software development. Is it helping us? Steve has a few thoughts.
2024-01-06
109 reads
2023-12-29
439 reads
AI In the Nov 2023 Enterprise
An OReilly Radar report on AI has some interesting data to Steve. Read what he thinks about the state of this technology in 2023.
2023-12-20
178 reads
GitHub Copilot - Our Best Ally for T-SQL
This article examines how GitHub Copilot might be used when working with T-SQL Code.
2023-12-05
7,459 reads
The Fake Speakers
Someone generated a fake speaker profile for their conference, which Steve finds disturbing.
2023-12-02
529 reads
A Lack of Privacy in Smart Cars
With new vehicles becoming more and more computerized and controlled, is data privacy an issue?
2023-11-29
179 reads
Data Security and AI
Today Steve discusses an aspect of AI that many people are concerned about: data security. Read more and think about how this might affect your organization.
2023-11-27
249 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
Information about United Airlines SFO Terminal
United Airlines San Francisco Airport Terminal offers a seamless and efficient travel experience, combining...
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...
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