2025-12-22
9,485 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
2025-11-17
3,658 reads
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
This article looks at using the FP-Growth algorithm from Python to mine data in SQL Server.
2025-09-08
2,750 reads
How to create your custom GPT SQL Expert
Introduction ChatGPT includes custom GPTs. You can create your own custom GPT. In this article, we will demonstrate how to create a custom GPT expert in SQL Server. Requirements To create your own GPT, you need to use the paid version of ChatGPT. First, go to ChatGPT. Secondly, if you don’t have the paid version, […]
2025-09-02 (first published: 2025-08-11)
4,739 reads
2025-07-28
11,275 reads
How to Work with RStudio and SQL Server
Learn how to get started running R scripts in R/Studio for data analysis.
2025-06-30
1,993 reads
How to process images and analyze charts with AI
See how ChatGPT can get data from images and conduct analysis on the data.
2025-06-16
2,196 reads
How to Forecast Data in Power BI
Learn how you can use Power BI to forecase the future trends of data.
2025-05-26 (first published: 2023-02-27)
51,112 reads
Data Analyst AI tool
See how ChatGPT can be used to analyze a dataset, produce charts, and train a model.
2025-05-12
384 reads
2025-04-28
481 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers