Will AI end with SQL, Is this the end of SQL?
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
2024-03-11
7,792 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
2024-02-26
5,621 reads
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL Server code (T-SQL) using Copilot. First, we will answer some FAQs about Copilot […]
2024-02-12
13,222 reads
Machine learning K-Means applied to SQL Server data
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
2024-01-08
3,144 reads
How to create a SQL Server presentation in 5 minutes using AI
Introduction This SQLServerCentral article shows how to create a SQL Server presentation in 5 minutes using AI. AI is revolutionizing the world as it continues to evolve. In this article, we aim to answer the question: Is it truly possible to create a high-quality presentation using AI in such a short amount of time? Is […]
2023-12-27 (first published: 2023-09-11)
4,476 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,469 reads
2023-11-20 (first published: 2023-10-02)
2,970 reads
SQL Server and Python Tutorial
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
2023-11-06
19,096 reads
How to export data to SQL Server using Bard (Google chatbot)
See how well the Bard AI does with moving data into SQL Server.
2023-08-28
2,212 reads
Bing vs Bard (Chatbot wars)
Introduction about Bing vs Bard You heard it well Chatbot wars, the war between Bing vs Bard. Ladies and gentlemen, in the Google corner we have the challenger, Bard! And in the Microsoft corner, we have a powerful AI-based in ChatGPT 4, the stupendous, the magnificent…Bing! (applause). These great chatbots will demonstrate their power in […]
2023-08-14
2,110 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers