T-SQL Tuesday #88: My Top WTF Moments
Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...
2017-03-14
587 reads
SQL Server Soldier :: News from the frontlines of the database wars
2016/2017 Whitepaper Updates
One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...
2017-03-13
519 reads
The Costs of Hiring Cheaper Consultants
From time to time, I see posts in forums from people complaining about how much some consultants charge. A really...
2017-02-17
590 reads
T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query
Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...
2017-02-14
673 reads
Warning: Not a valid checkpoint file name
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,860 reads
Finding Automatic Soft-NUMA
If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL...
2017-01-04 (first published: 2016-12-30)
2,230 reads
T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
713 reads
T-SQL Tuesday #85: Backup Log With NoRecovery
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
766 reads
T-SQL Tuesday #83: Resource Governor CAP_CPU_PERCENT: It just runs faster?
Welcome to T-SQL Tuesday #83 being hosted this month by Andy Mallon (blog|@AMTwo). This month’s topic is “We’re still dealing...
2016-10-11
702 reads
T-SQL Tuesday #81 – Migrating Databases with Dell LiteSpeed
It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall...
2016-08-09
652 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?