If not me, then who?
[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
53 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
How SQL Server stores data types: XML
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
155 reads
The final word on storage for DATETIME2
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
21 reads
Using the Xero OAuth 2.0 API from a .NET Core console application
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
243 reads
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, the PASS Summit. If...
2020-08-19
40 reads
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 legacy database and application...
2020-08-12
59 reads
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 which were allocated 127...
2020-08-05
15 reads
Honorifics in the 21st century
As data professionals, we should understand how language and forms of address can impact our data model. In the 21st century, we should also learn how to communicate with colleagues in a respectful and professional manner.
2020-07-30
2,414 reads
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 my Database Administration Through...
2020-07-29
28 reads
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 Studio, and was asked...
2020-07-22
59 reads
Blogs
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers