SQL Server Installation Checklist
Many people have published SQL Server installation checklists before. Here is one I have been using for several installations without...
2014-04-01
20,540 reads
JR
Replication Agent Failure
I recently spent several days investigating a replication failure. Finding the answer specific to my problem was difficult, so I...
2011-08-08
7,893 reads
Poor man’s SQL monitor
Here is quick tip that can help you track SQL Job and Alert notifications in Microsoft Outlook. Many of you...
2011-06-20
919 reads
Managing Data Change
Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...
2011-05-20
1,875 reads
The First Post
I have been a SQL Server DBA and Developer for nearly ten years. In that time I have amassed a...
2011-05-05
441 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?