Who is Using Standard Edition?
Today Steve is asking if any of you use Standard Edition with the coming of a developer edition that matches it.
Common SQL Server Problems: Network Related or Instance Specific Error Occurred
This is the first in a series of articles meant to provide practical solutions to common issues. In this post, we’ll talk about one of the most pervasive error messages out there:
Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth
This level will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log.
Enable TDE for Databases in a SQL Server AlwaysOn Availability Group
A customer has a database that is already set up in a SQL Server Availability Group. Since this database hosts sensitive data, there is a need to encrypt the primary and all secondary replicas of the data. In this article, we will walk through how this can be done.
Everyone Wants a Piece of the AI Pie
Swiping through LinkedIn feels like watching a campsite suddenly flooded with s’mores. Every other ad, i.e. post, promises the next miracle AI service, platform, or “AI-powered” widget. It’s a frenzy that says: “If buzzwords paid the bills, we’d all be billionaires already.” I can’t fault the reasoning, there’s a lot of buzz out there telling […]
Critical Data and Insomnia
Most evenings I spend some time soaking in the tub and reading articles/watching videos on InfoSec, Data Protection and AI. It may sound like a terrible way to spend some time, but I always find it educational and I’m in shock by the lack of concern around data security, and yet….I’m not. For decades, the […]
The Double-Edged Sword of AI and Data Democratization
Agentic AI is often hailed as a game-changer by organizations, bringing autonomous decision-making, intelligent automation, and powerful predictive capabilities. However, as organizations rush to leverage these technologies, those dealing with critical data in relational databases, documents and datasets, especially personally identifiable information (PII) face a harsh reality: moving AI projects from proof-of-concept to production is […]
The Problem with AI Job Loss Headlines?
Every few weeks, headlines scream about how artificial intelligence is coming for our jobs. The narrative is often the same: white-collar professions are at risk, automation is taking over, and we’re all doomed to obsolescence.
Hack Your Brain
Now, let's be really clear up front, I don't mean getting a surgically implanted chip in your head, done on your kitchen table. Brain hacks are generally either, forming habits that are good for learning and concentration, changing how you do things to help enhance your brains function, eating differently in support of brain health, […]
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
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
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
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?