PASS Summit 2024 – A new experience
I attended the PASS Data Community Summit held in Seattle in person this year after a long gap of 4 years and after RedGate software took over running the...
2025-01-22 (first published: 2025-01-13)
306 reads
Blog Posts
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
123 reads
Implement a RAG Solution Using Azure SQL Database
AI and ChatGPT are all the rage these days. Seems like around every corner is another break-through in how we interact with data, regardless of if that data is...
2025-01-20 (first published: 2024-11-01)
855 reads
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should know appeared first on Joyful Craftsmen.
2025-01-20 (first published: 2024-11-04)
700 reads
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-01-19
245 reads
SQL Server 2025
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release /revolution from Microsoft SQL Server prospect, including – AI Buildin’, as AI plays an important...
2025-01-19
126 reads
Advice I Like: Apologies
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse – from Excellent Advice for Living This is great advice. I remember myself often saying “I’m...
2025-01-17
14 reads
Build a Serverless Todo App With AWS, Pulumi, and Python
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible through a RESTful API.Developers charged with building modern, scalable applications often face the burden of having...
2025-01-17
36 reads
Friday Flyway Tips: Chaining Commands for State-based Deployments
One of the cool things I’ve seen with the new Flyway CLI is that I can combine multiple actions together in one call, which can make the process of...
2025-01-17 (first published: 2025-01-10)
416 reads
Have a Plan for Your Personal Downtime
Most of us know that spending a lot of time on social media and surfing the web isn't good for us, but we still do it. Why? Because it...
2025-01-17 (first published: 2025-01-07)
497 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers