Born SQL with Randolph West

A new malware attack on SQL Server

• by Randolph West

• Born SQL with Randolph West

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...

2020-09-23

31 reads

If not me, then who?

• by Randolph West

• Born SQL with Randolph West

[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...

2020-09-16

8 reads

How SQL Server stores data types: XML

• by Randolph West

• Born SQL with Randolph West

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...

2020-09-09

134 reads

The final word on storage for DATETIME2

• by Randolph West

• Born SQL with Randolph West

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...

2020-09-02

7 reads

Using the Xero OAuth 2.0 API from a .NET Core console application

• by Randolph West

• Born SQL with Randolph West

This is not a post about SQL Server, but I need to write about something that I’ve been struggling with for a number of weeks so that other people...

2020-08-26

12 reads

Finally, PASS is a proper association now

• by Randolph West

• Born SQL with Randolph West

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...

2020-08-19

13 reads

Fun and profit with UTF-8

• by Randolph West

• Born SQL with Randolph West

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...

2020-08-12

19 reads

Managing virtual machine drives on ESXi

• by Randolph West

• Born SQL with Randolph West

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...

2020-08-05

8 reads

I am speaking at the PASS Virtual Summit 2020

• by Randolph West

• Born SQL with Randolph West

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...

2020-07-29

8 reads

These are the extensions I have installed on Azure Data Studio

• by Randolph West

• Born SQL with Randolph West

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 Studio, and was asked...

2020-07-22

39 reads