Canada Day 2020

• by Randolph West

• Born SQL with Randolph West

It’s Canada Day here, the commemoration of the country’s confederation in 1867. Given events over the last few months such as the worldwide pandemic, followed by a number of...

2020-07-01

3 reads

Unsupported but working versions of SQL Server on Windows Server 2019

• by Randolph West

• Born SQL with Randolph West

One of my hobbies is trying to break technology so that you don’t have to. I don’t consider myself a professional or hobbyist hacker, though if the shoe fits…...

2020-06-24

How SQL Server stores data types: UNIQUEIDENTIFIER

• by Randolph West

• Born SQL with Randolph West

This week we’re looking at how the database engine stores GUIDs (globally unique identifiers), specifically known as UNIQUEIDENTIFIER in SQL Server. If you would like to read about storage...

2020-06-17

How SQL Server stores data types: floating points

• by Randolph West

• Born SQL with Randolph West

In this post we are looking at how SQL Server stores floating point values (FLOAT and REAL). If you’d like to read the previous posts in this series of...

2020-06-10

133 reads

How should I store currency values in SQL Server?

• by Randolph West

• Born SQL with Randolph West

On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever...

2020-06-03

269 reads

How SQL Server stores data types: money

• by Randolph West

• Born SQL with Randolph West

In this post we look at how SQL Server stores currency values using the MONEY and SMALLMONEY data types. If you’d like to read the previous posts in this...

2020-05-27

8 reads

An insidious form of SQL injection

• by Randolph West

• Born SQL with Randolph West

As longtime readers know, I am also a software developer (we can’t call them engineers in Canada for legal reasons). I took over a complex codebase last year in...

2020-05-20

255 reads

How SQL Server stores data types: integers and decimals

• by Randolph West

• Born SQL with Randolph West

Last time we looked at the internals of how dates and times are stored in SQL Server. This week we’re going to look at how numbers are stored. This...

2020-05-13

12 reads

Negative identity values don’t suck

• by Randolph West

• Born SQL with Randolph West

A quick(er) post this week, in response to Greg Low’s blog post from a few weeks ago titled “Don’t start identity columns or sequences with large negative values.” Greg...

2020-05-06

170 reads

PASS Summit 2020 pre-con time

• by Randolph West

• Born SQL with Randolph West

In 2018, I entered Speaker Idol at the PASS Summit, and because I forgot to start my timer I was disqualified for running over the five-minute limit (say “five-minute...

2020-04-29

3 reads