Cool AI sites
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI and LLMs, Introduction to OpenAI and LLMs – Part 2 and Introduction to OpenAI and...
2025-02-07 (first published: 2025-01-29)
694 reads
A Quick Test Data Manager Eval with My Database Backup
I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and it was a great post. In that one, the sample database Northwind was...
2025-03-06 (first published: 2025-01-29)
41 reads
Take over Ownership in Microsoft Fabric
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a pipeline …), you are also the owner of the item. There has been an...
2025-02-05 (first published: 2025-01-29)
605 reads
How-To Convert Excel Date & Time to SQL
Hey data friends! This one comes from my personal vault (aka backlog of drafts I’ve been needing to write up) and is a really simple code that I always...
2025-02-14 (first published: 2025-01-28)
1,397 reads
SQL in 2025: Still the King of Data
Data's the new oil, and SQL is your refinery. It's still the go-to language for shaping, analyzing, and making sense of the data that fuels our businesses. In 2025,...
2025-01-28
236 reads
Drop roles in Postgres
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles are granted to it. I had to go fishing to find all the grants to...
2025-02-12 (first published: 2025-01-27)
255 reads
Get a PAT in Azure DevOps
I have a presentation recently on Continuous Integration Using Local Agents in Azure DevOps and one of the things I do in there is get a PAT for Azure...
2025-02-05 (first published: 2025-01-27)
406 reads
The Local OLLAMA Gui
I ran a small ollama model in a container and have been doing some experiments. One of the things I wanted to do was get a GUI so I...
2025-01-27
182 reads
A New Word: Amoransia
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for someone you can never have, wallowing in devotion to some impossible person who could give...
2025-01-24
62 reads
The Data API Builder Start and Add Extensions in VS Code
One of the things that I like about the Data API Builder (DAB) is that there is a lot of CLI work that can be done. However, lots of...
2025-01-22
142 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers