Why even the best teams struggle with cloud migrations
Grant Fritchey explains the concept of ‘unknown unknowns’, points out what to watch out for in a cloud migration, and offers proven strategies to help your migration go as smooth as possible.
Midjourney, Healthcare?
Certain announcements in AI tell you more about where an industry is heading than any earnings call or research paper ever could, and Midjourney just made one. The company that spent the last few years as the most recognizable name in image generation, the one whose pictures flooded everyone's feeds and defined what people saw […]
Changes, Happiness, and a Few Tears
Change is unavoidable and always affects us. We can be both happy and sad about it as we move forward. A tribute today to Annabel, who retired from Redgate Software this week.
You Probably Don't Need a Vector Database
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
The LLM layer you’re probably missing (LLM gateway pattern explained)
The LLM gateway pattern is a thin service layer that sits between your app and large language model (LLM) providers, centralizing every AI call through a single entry point. It gives you immediate control over routing, logging, retries, fallbacks, and cost tracking – preventing the chaos of scattered integrations, unclear billing, and provider lock-in as your system scales. Learn all you need to know about the LLM gateway pattern in this article.
Follow Your Hunch
One of the positives of AI is that you can try things on which you might not otherwise have time to experiment.
What Happens When You Ask a Local AI to Query Your Database?
Learn how you can run a simple LLM on your own machine with Python.
Your Database Just Hit One Terabyte: Now What?
You were minding your own business, and all of a sudden it happened.
Calculating the Harmonic Mean in Power BI
Learn how you can add a harmonic mean calculation in Power BI.
The Slow Growing Problems
Not every problem is going to fire off an alert, but it still might be something that you want to track.
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers