Did you know we have another SQL Server book coming out?

• by Randolph West

• Born SQL with Randolph West

SQL Server 2017 Administration Inside Out was the first technical book I contributed to, and all its authors were very happy with how it turned out. All the content...

2019-11-13

19 reads

Speaking at SQL Saturday Oregon

• by Randolph West

• Born SQL with Randolph West

SQL Saturday Oregon — in the city of Portland — is taking place next weekend on Saturday November 2nd, 2019, and I’ll be presenting a revised edition of my...

2019-10-23

1 reads

Using indexed views? What is an imprecise or non-deterministic convert?

• by Randolph West

• Born SQL with Randolph West

After last week’s post about using WITH (NOEXPAND) to query indexed views even on SQL Server Enterprise Edition, this week is a short but interesting side-road into deterministic values,...

2019-10-16

10 reads

Using indexed views? Don’t forget this important tip.

• by Randolph West

• Born SQL with Randolph West

Today after fighting with designing a view that let me create a clustered index on it (indexed views — also known as materialized views — are awesome in the right context!),...

2019-10-09

22 reads

How to read documentation

• by Randolph West

• Born SQL with Randolph West

I was thinking about a comment I made to my intern last week. She has been studiously attending to all the different things I do in my day (what...

2019-10-02

13 reads

Gatekeeping and Accessibility

• by Randolph West

• Born SQL with Randolph West

In my final post about gatekeeping in technology, I have to come clean about something. Let’s go through this journey together. In the first post we spoke about what...

2019-09-25

10 reads

SQL Server 2019 on Docker no longer runs as root by default

• by Randolph West

• Born SQL with Randolph West

In my home lab I have an Ubuntu virtual machine that runs both SQL Server 2017 and SQL Server 2019 in Docker containers. After SQL Server 2019 Release Candidate...

2019-09-18

19 reads

Gatekeeping and the lack of diversity in the workplace

• by Randolph West

• Born SQL with Randolph West

Recently I have become more vocal on Twitter and on my personal blog about my social activism. For the record, I have been an activist for LGBTQIA+ rights since...

2019-09-11

107 reads

Convert legacy password storage without aggravating your users

• by Randolph West

• Born SQL with Randolph West

In a previous post I wrote about storing password hashes in a database, which raises the question of how to convert an existing legacy password storage system to use hashes (or...

2019-09-04

17 reads

Using AzCopy with Batch Files and Task Scheduler

• by Randolph West

• Born SQL with Randolph West

As regular readers of this blog will know, I’m a big fan of AzCopy, especially now that it has a sync option to keep local data synchronized with blob...

2019-08-28

113 reads