2025-12-22
9,533 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
2025-11-17
3,667 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,756 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,748 reads
2025-07-28
11,283 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,994 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,203 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,114 reads
Data Analyst AI tool
See how ChatGPT can be used to analyze a dataset, produce charts, and train a model.
2025-05-12
386 reads
2025-04-28
482 reads
Blogs
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers