Some databases may show a NULL collation in the sys.databases DMV

While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the script on my SQL Server 2016 instance. Just before removing all the databases, I noticed something interesting when querying the sys.databases Dynamic Management View (DMV). Because the process I had come up with involved setting
-> Continue reading Some databases may show a NULL collation in the sys.databases DMV

Post image

So, like, what is a byte?

A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before, was reading through the first five posts of this Database Fundamentals series, and asked a great question: “I guess I’m not understanding what a byte is. I think I’m circling the drain in understanding it, but not
-> Continue reading So, like, what is a byte?

Post image

Data Types and Collation

Last week we started with a very simple definition of a database: a discrete set of information, with a specific structure and order to it. We briefly looked at normalization, which is a way to store as little of the information as possible, so that it stays unique. We will cover more normalization as we
-> Continue reading Data Types and Collation