Finally, PASS is a proper association now
For the longest time PASS was known as the Professional Association for SQL Server, and made all of its money from a single event each year,… Read More »Finally, PASS is a proper association now
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available in Azure SQL Database, UTF-8 is exciting if you have a… Read More »Fun and profit with UTF-8
Managing virtual machine drives on ESXi
Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little beefier. There were ten virtual machines on the SuperMicro server, nine… Read More »Managing virtual machine drives on ESXi
I am speaking at the PASS Virtual Summit 2020
After being selected to present my full day pre-conference session at the Summit, I am very pleased to announce that I will also be presenting… Read More »I am speaking at the PASS Virtual Summit 2020
These are the extensions I have installed on Azure Data Studio
At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data… Read More »These are the extensions I have installed on Azure Data Studio
MAXDOP: not quite what you think
An important change to the MAXDOP documentation was made last week, with a good write up by Pedro Lopes (Twitter), a Program Manager on the… Read More »MAXDOP: not quite what you think
Speaking at the Edmonton PASS user group on 16 July 2020
A short post this week, to let you know that I’ll be presenting a brand new session to the Edmonton PASS user group (EDMPASS) next… Read More »Speaking at the Edmonton PASS user group on 16 July 2020
Canada Day 2020
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… Read More »Canada Day 2020
Unsupported but working versions of SQL Server on Windows Server 2019
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… Read More »Unsupported but working versions of SQL Server on Windows Server 2019
How SQL Server stores data types: UNIQUEIDENTIFIER
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… Read More »How SQL Server stores data types: UNIQUEIDENTIFIER
How SQL Server stores data types: floating points
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… Read More »How SQL Server stores data types: floating points
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ⚠️ Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever… Read More »How should I store currency values in SQL Server?
How SQL Server stores data types: money
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… Read More »How SQL Server stores data types: money
An insidious form of SQL injection
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… Read More »An insidious form of SQL injection
How SQL Server stores data types: integers and decimals
This week we’re going to look at how numbers are stored. This post will cover integers (TINYINT, SMALLINT, INT, BIGINT), and decimals (DECIMAL, which is… Read More »How SQL Server stores data types: integers and decimals