Skip to content
A Windows error message

Read the error message

  • by

This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had to walk away from to restore… 

messy paint cans and colours

How SQL Server stores data types: sql_variant

  • by

This post looks at a curious data type that isn’t really a data type. Instead, sql_variant tries to be all things to all people. As with most things in life, it has a few shortcomings… 

chain and padlock

A new malware attack on SQL Server

  • by

Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can be brute-forced. According to the report… 

Hooded snake with tongue out

If not me, then who?

  • by

[Content Warning: this post contains references to subjects that may trigger a trauma response. Read with caution.]

This is not a technical post. I was going to write about how SQL Server stores the sql_variant data type this week, but something more important came up which involves almost 50% of the adult population worldwide, including me1As some of my readers know — especially if you read my article on SQL Server Central at the end of July 2020 — I am nonbinary, and it would be super convenient to hide behind that label when we have to talk about the behaviour of men. But I look like a man, I sound like a man, and I dress like a man. Unless I tell someone otherwise, the general perception is that I’m a man. For all intents and purposes in this discussion I’m including myself, and I’m calling out other men for their behaviour towards women..

Men, it’s 2020. We have to do better.

It’s hard enough to be a woman online, to exist in the public eye as a woman, to be constantly judged — even rated — according to a manufactured ideal of sex appeal that has no basis in biology or science. Add into that mix a woman who is in a technical field, science, biology, or chemistry, heck, even the arts, and the judgement is increased exponentially. How do I know? Women tell me. Believe women.

A half-closed MacBook

How SQL Server stores data types: XML

  • by

This week we’re looking at how the database engine stores the XML data type in SQL Server and Azure SQL Database. If you would like to read about storage of other data types, here are the… 

A wall of scattered pages from a book

The final word on storage for DATETIME2

  • by

Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the commenters noted that the official SQL… 

PASS logo

Finally, PASS is a proper association now

  • by

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, the PASS Summit. If you’ve ever attended a SQLSaturday, you’re… 

UKRAINE. Kiev. 2019. Kiev Children's Railway. Museum

Fun and profit with UTF-8

  • by

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 legacy database and application that needs to support Unicode strings… 

A blue desktop vice

Managing virtual machine drives on ESXi

  • by

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 which were allocated 127 GB of thin-provisioned storage, and one… 

I am speaking at the PASS Virtual Summit 2020

  • by

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 my Database Administration Through the Ages talk that originated at… 

Juggler on a beach

MAXDOP: not quite what you think

  • by

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 SQL Server team at Microsoft. First though, some background on…