Database, Software, and System Engineering


To VARCHAR or NVARCHAR? (and how it bit me using HASHBYTES)

The Difference The key difference between the two data types is how they’re stored. VARCHAR is stored as regular 8-bit data, NVARCHAR strings are stored in the database as UTF-16. UTF-8 (UCS Transformation Format—8-bit) is a variable-width encoding that can represent every character in the Unicode character set. It was designed for backward compatibility with […]

Grant Execute Permission on All Stored Procedures in a SQL Database

First blog post.  I’ll make it short, simple, and [hopefully] sweet. I like it when bloggers have the solution easy to find at the top and then explain in a little more detail below.  I’ll try following that as much as possible. Recently, I was asked to blanket all user stored procedures.  The practicality of this […]