Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
176 reads
SQL RNNR
Message in a Bottle of XE
Considering this "feature" for everything that is SQL Server related, does this mean that all Extended Events related messages are accessible in sys.messages?
Related Posts:
Implicit Conversion Fail May 31, 2019...
2017-12-27
5 reads
12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
446 reads
12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
178 reads
12 Days Of Christmas and SQL
In the spirit of the 12 Days of Christmas and Giving, I have a 12 Day series that I generally try to do each Holiday Season. The series will...
2017-12-26
3 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
1,263 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
141 reads
Best New(ish) SSMS Feature
Enabling the scrollbar map has saved me oodles of time - even without the preview option enabled. I can much more quickly hop to different segments of code with...
2017-12-26
3 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
17,046 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
153 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?