Technical Interviews – How to Thrive
There’s a trick to technical interviews. Every question is looking for integrity first, and intelligence and energy second. This is...
2014-05-23 (first published: 2014-05-13)
2,772 reads
Blog Posts
Wishing For Error Messages That Are Good Search Terms
Here’s a SQL error you might get:
not able to access the database “SomeDB” under the current security context.
If you don’t...
2014-05-23
521 reads
Advanced Google Analytics for SSIS
Update: There is a new 1.7 Version of Google Analytics Source for SSIS
This post is a continuation of the SSIS...
2014-05-22
420 reads
An Sp_addrolemember Gotcha
Over the past few months there have been a handful of times when I had to fix a security problem...
2014-05-22
825 reads
Getting Started with the Modern.ie VMs on VirtualBox with IIS Express
Microsoft has made pre-packaged Virtual Machine images available for purposes of testing different versions of IE via the modern.ie web...
2014-05-22
2,374 reads
Missing Indexes Script v2
Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them...
2014-05-22 (first published: 2014-05-15)
4,225 reads
Speaking at SQLSaturday Rheinland, Germany 2014
It is with a great pleasure that I am happy to share that today I have received news of being...
2014-05-22
153 reads
Two things you probably shouldn’t say in an interview
If you look online you can find thousands of pages of advice on interviews as well as people asking for...
2014-05-22
885 reads
Writing A Question Of the Day–More Notes
One of the things I’m trying to do now is include a link to a blog(ger) in the explanation. That...
2014-05-22
489 reads
Building The SQLSaturday Orlando Marketing Plan–Part 9
I’ve heard more than once that Meetup.com is a good way to reach new people so we’re looking at how...
2014-05-21
699 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?