Script for database snapshot
The idea for this script came at a time when I was having a project that needed to use snapshots...
2014-05-09
99 reads
Blog Posts
SQL Saturday #308 – Houston TX Presentation
Tabular Data Visualized by Power View
I am presenting this Saturday 5/10/2014 at 4PM at the Houston TX SQL Saturday Event. ...
2014-05-09
707 reads
SSRS #74 – 2008 Cascading bug when you have a middle parameter
Some SSRS reports have a large number of parameters
I recently had a chance to help a co-worker to modify...
2014-05-09
1,763 reads
The Scary DBA Comes to Columbia, SC
*sound of glass crashing* *cue theme music*
(in a wrestling announcer’s shocked voice) “It can’t be! He’s not supposed to be...
2014-05-09
691 reads
We’re All Mad Here!
The title says it all!
I just heard that I was selected to present at SQL Saturday in Columbus! I’m excited...
2014-05-09
718 reads
Artikel „SQL Server 2014 – Neues Fundament“ in iX Ausgabe 5/2014, Richtigstellungen zu In-Memory OLTP und ColumnStore Indexes und warum AlwaysOn nicht gleich Always On ist
Article “SQL Server 2014 – New Fundament” in iX Issue 5/2014, corrections in In-Memory OLTP and ColumnStore Indexes, and why AlwaysOn...
2014-05-08
1,228 reads
Cannot Failover Nodes Using TempDB on Local Storage
I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local...
2014-05-08
848 reads
Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,081 reads
Getting Local Books Online
One of the things that’s annoyed me in the last few versions is that Books Online isn’t smoothly installed for...
2014-05-08
885 reads
Recent Event Recap
These last few weeks have been quite a blur of projects, travel, and end-user training, and I’m enjoying every bit...
2014-05-08
726 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
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?