What is ANSI_NULLS and why will I be glad when it finally goes away?
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...
2014-08-04 (first published: 2014-07-28)
22,362 reads
SQLStudies
Why am I getting a primary/unique key violation?
This may seem like a question with a simple answer but there is a bit more to it than you...
2014-07-23
1,571 reads
Add them to ALL the roles!
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...
2014-07-28 (first published: 2014-07-21)
8,660 reads
Yes, Virginia, you can have too much white space.
When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch...
2014-07-22 (first published: 2014-07-16)
9,128 reads
What does it mean that a value is NULL?
Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be...
2014-07-15 (first published: 2014-07-14)
10,900 reads
db_ddladmin and the SSMS table designer
If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you...
2014-07-10
969 reads
T-SQL Tuesday #56: Assumptions
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can...
2014-07-08
849 reads
Argenis and the unicorn hoodie
Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a...
2014-07-02
698 reads
Make BOL your friend
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,032 reads
Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,505 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers