Learning Tool – Deepstash
A few months ago I started using Deepstash. Deepstash breaks books into the key ideas, usually 10-12 per book. If I am thinking about reading a book, I check...
2026-08-27
44 reads
New article – migrating from a named instance
Do you have a case where you have a named instance you'd like to migrate to a default instance? Is there pushback on doing so? Are there concerns that...
2026-08-26
126 reads
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most blogs with real history, it’s accumulated some tech debt. Some of it is my own...
2026-08-26
28 reads
Using the SIGN() Function: #SQLNewBlogger
I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where...
2026-08-26
54 reads
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend or a foe, from full-throated defenses to a lab built to prove me wrong.
2026-09-04 (first published: 2026-08-25)
50 reads
Monday Monitor Tips: Configuring Access to the MCP Server
I have been experimenting with MCP servers in a few ways, including the Redgate Monitor MCP Server. It took me a few tries, and some help from engineers to...
2026-08-31 (first published: 2026-08-24)
309 reads
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small servers with zero activity showed no progress, and then all 30 finished at the same...
2026-09-02 (first published: 2026-08-23)
220 reads
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people who prefer a GUI over writing code to handle deployments, but the implementation has enough...
2026-09-02 (first published: 2026-08-21)
325 reads
The Book of Redgate: Evidence
We aren’t the only company that does this, but Redgate Software does try to be data driven. Across my 18 years, I’ve had plenty of people use evidence from...
2026-09-04 (first published: 2026-08-21)
192 reads
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform. Power BI, data engineering, warehousing, data science, real-time analytics, Copilot, and other experiences can all...
2026-08-28 (first published: 2026-08-20)
402 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers