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,368 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,647 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,669 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,138 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,904 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
971 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
850 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
699 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,061 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,599 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers