Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieves this is...
2025-11-17 (first published: 2025-10-31)
412 reads
When it comes to managing complex database environments, having the right monitoring solution is critical. That’s why I’ve relied on Redgate Monitor at different points in my career. It...
2025-11-17 (first published: 2025-11-02)
263 reads
Quite a long title for a short blog post ??While deploying a DACPAC (from a SQL Server Data Tools Database Project) through Azure Devops, I got the following error...
2025-11-16 (first published: 2025-11-14)
29 reads
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is a great feature that can help with writing SQL queries and scripts sql development. However,...
2025-11-15
84 reads
It can be tedious to check what visual interactions have been configured in a Power BI report. If you have a lot of bookmarks, this becomes even more important....
2025-11-14 (first published: 2025-10-31)
349 reads
Ollama SQL FastStart kit just works out of the box. It makes it easy to spin the whole Docker Compose stack not in minutes but seconds! Continue reading →
The...
2025-11-14 (first published: 2025-10-27)
435 reads
In my previous post, I showed you how to build a snapshot backup catalog using SQL Server 2025’s new native REST API integration. But what if you’re still running...
2025-11-12 (first published: 2025-10-25)
288 reads
Change is inevitable. What separates thriving organizations from those that falter is not the scale of disruption but how leaders respond to it. In times of shifting technologies, evolving...
2025-11-12 (first published: 2025-10-20)
307 reads
One of the language changes in SQL Server 2025 that I’ve seen a lot of people mention is the addition of RegEx functions to T-SQL. I decided to take...
2025-11-12
154 reads
I had a great question asked of me the other day and thought I would turn the answer into a blog post. The question is “I’m an experienced DBA...
2025-11-12
11 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?