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,822 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
2024-02-26
5,645 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,403 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,177 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,578 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,479 reads
2023-11-20 (first published: 2023-10-02)
2,986 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,572 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,217 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,113 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers