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, and why it is important to… Using indexed views? What is an imprecise or non-deterministic convert?
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!), I kept running into the same… 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 in my day (what many people consider a well-guarded secret!),… 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 of August 2020, Grace Anderson — president and co-founder of I… 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).
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 2001, so if this comes as… 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 to use hashes (or even no passwords!) without annoying the… 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 data synchronized with blob storage. In a recent release of… 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 might be wrong about the beans), there is a good… 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. This post goes into a bit of an explanation of… 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 the first post I wrote that a number of words… 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 on Unsplash.
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 Linux Learning Path and being a part of that, so… 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 I be the last — to say that the terminology… 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, using an algorithm developed by Jonathan Kehayias. SQL Server 2019… Better SQL Server memory defaults in 2019