In Memory of Andrew Clarke, AKA Phil Factor
One of the parts of getting older that really sucks is I seem to attend more funerals than weddings. It’s a sad fact of file, and this was one...
2025-09-15
567 reads
Blog Posts
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries. They are navigators of complexity, interpreters of signals, and stewards of trust. Technology has transformed...
2025-09-15
62 reads
SQL Server Log Shipping: The Tried and True of DR
It’s not glamorous, but it works In a world where shiny new HA/DR features get all the press, there’s one SQL Server technology that just keeps doing its job....
2025-09-15 (first published: 2025-08-27)
213 reads
A New Word: Anderance
anderance – n. the awareness that your partner perceives the relationship from a totally different angle than you – spending years looking at a different face across the table,...
2025-09-12
505 reads
AI and Cybersecurity: the Genie is Out of the Bottle
Today's reality is that cybercriminals are increasingly using AI to develop better attacks. This is just the latest reported technique, probably because it's starting to be used more often....
2025-09-12 (first published: 2025-08-21)
235 reads
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend. The first one is at Retro Data (20th of September), a new virtual conference focusing...
2025-09-12 (first published: 2025-09-11)
382 reads
The Strategic Imperative of SQL Performance Tuning in Azure
Aligning Technical Excellence with Organizational Agility Tuning SQL performance in Azure transcends routine database management and becomes a strategic imperative when viewed through an executive lens. Slow database operations...
2025-09-12 (first published: 2025-08-21)
337 reads
Adding SQL Server 2025 to my Laptop
I wanted to do some testing of SQL Server 2025 on my laptop. I have written before how I avoided installing SQL Server on the laptop and use containers...
2025-09-10 (first published: 2025-08-20)
673 reads
Scooby-Doo and the Mystery of Cloud Costs (Let’s have some fun!) – Scooby Dooing Episode 1
If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other database performance tuning isn’t just about faster queries—it’s directly tied to your bottom line in...
2025-09-10 (first published: 2025-08-25)
307 reads
SQL Server Availability Groups
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups (AGs), they changed the HA/DR game. Unlike Failover Cluster Instances (FCIs), which protect the whole...
2025-09-10
22 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
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?