A New Word: Candling
candling – v. intr. the habit of taking stock of your life on the occasion of your birthday, letting it serve as a kind of internal referendum on all...
2024-01-12
28 reads
Blog Posts
Baby Steps and Continuous Improvement
It’s the last Friday of the year and I’ve been struggling to think of a good way to close things ... Continue reading
2024-01-12 (first published: 2023-12-29)
322 reads
Why you should consider Power BI Cleaner
Introduction
You have probably created various auxiliary tables, columns or metrics during report development. Before the final deployment of the report into production, it is necessary to delete these auxiliary...
2024-01-12 (first published: 2024-01-02)
812 reads
Build a Terraform Module for Azure SQL
Building a Terraform module for Azure SQL DB is like packaging your infrastructure magic into a reusable box. It’s the kind of thing that makes your IT life smoother....
2024-01-10 (first published: 2023-12-29)
360 reads
Update Azure SQL database and storage account public endpoint firewalls with Data Factory IP ranges
While a private endpoint and vNets are preferred, sometimes we need to configure Azure SQL Database or Azure Storage to allow use of public endpoints. In that case, an...
2024-01-10 (first published: 2024-01-02)
446 reads
Using the Pure Storage PowerShellSDK2 - Part 4 - Classifying Workloads With FlashArray Tags
Welcome back to the fourth installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, you’ll learn how to use Purity Tags to classify...
2024-01-10
40 reads
2024- Of ‘quiet quitting’ and ‘life in the hallway’
My good friend Gina Menorek shared this article from NY Post on the overwhelming exhaustion among tech workers. The article talks of ‘quiet quitting’ – not quitting our jobs...
2024-01-08 (first published: 2023-12-31)
697 reads
Backing up the Teslamate Database
I was worried about some of my data, so I wanted to be sure I had a backup of my Teslamate system. This post covers the config I’d added...
2024-01-08
110 reads
Careful When Changing SQL Server Database File Extensions
I recently had a friend reach out to me about database performance dropping drastically. I asked if anything had changed recently on the server, and they told me that all...
2024-01-08
28 reads
SQL Server Blog quarterly review
This SQL Server blog roll talks about the few blog articles I have published in last couple of months. I am certain you would like reading
The post SQL...
2024-01-08 (first published: 2024-01-01)
230 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers