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… Read More »Using indexed views? Don’t forget this important tip.
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… Read More »How to read documentation
In my final post about gatekeeping in technology, I have to come clean about something. Let’s go through this journey together. [Edit: At the end… Read More »Gatekeeping and Accessibility
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 1 was released, when I performed my usual migration to get the latest version, I noticed that the command line for the SQL Server instance was different.
I used sudo docker ps -a --no-trunc to see the full command, which is emulated below (note: this output is heavily abbreviated).
Read More »SQL Server 2019 on Docker no longer runs as root by default
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… Read More »Gatekeeping and the lack of diversity in the workplace
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… Read More »Convert legacy password storage without aggravating your users
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… Read More »Using AzCopy with Batch Files and Task Scheduler
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting from a combination of magic beans and smart software developers (I… Read More »Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
Recently I wrote: Don’t store passwords in a database. I stand by this statement. I expected a lot of flak because I didn’t explain myself.… Read More »How to really store a password in a database
This is the second in a series of posts about gatekeeping in Information Technology and other fields. Negative terminology The language we use matters. In… Read More »Gatekeeping and why language matters
Hello, and welcome to today’s class on storing passwords in a database. Don’t store passwords in a database. Thanks for attending. Photo by James Sutton… Read More »How to store a password in a database
I have been selected to present a second session for the PASS Summit in November this year. I wrote a few weeks ago about the… Read More »The importance of backups
This is the first in a series of posts about gatekeeping in Information Technology and other fields. I am not the first — nor will… Read More »All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
In 2016 I created the Max Server Memory Matrix as a guide for configuring the maximum amount of memory that should be assigned to SQL Server,… Read More »Better SQL Server memory defaults in 2019
SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to… Read More »Better SQL Server CPU defaults in 2019