What I actually do at Microsoft
I started working at Microsoft in January 2022. I enjoy it. I even wrote a stream-of-consciousness post about it last year. A significant part of our job in the...
2024-06-28 (first published: 2024-06-10)
355 reads
Blog Posts
How to use a Script Activity in ADF as a Lookup
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a typical scenario where you retrieve some metadata from a database and then loop over...
2024-06-27
148 reads
6 Surprising Things You Can Do on WordPress.com Without a Plugin
Newsletters? Spam protection? Image galleries? We have you covered, no plugin needed.
2024-06-26
18 reads
How I Effortlessly Dockerize Python-Based AWS Lambda Functions
As a Software Engineer, i would like to learn how to dockerize my Python Fast API Framework and use this dockerize application in my lambda function. This will allow...
2024-06-26 (first published: 2024-06-07)
183 reads
Talkie - a simple, private, responsive interface for LLMs
Watch this video on YouTube
I like using ChatGPT. But I don't like the $20/month price tag for using OpenAI's app, especially given the API costs fractions of a cent.
So...
2024-06-26 (first published: 2024-06-10)
309 reads
Book Review – Fundamentals of Data Engineering
This book was recommended by some of my colleagues, so I decided to give it a try. After finishing the book, I was pleased that I did. As the...
2024-06-24 (first published: 2024-06-05)
480 reads
Exploring Window Functions Execution Plans
There are quite a few different ways that you’re likely to see window functions evidence themselves within your execution plan. Let’s take a look at one example. Window Functions...
2024-06-24
46 reads
2024-06-24
22 reads
How to give developers access to Query Store
Let’s have devs look at their own query performance. Yes, please, sign me up for that! Sometimes, it’s hard for me to know the best course of action, especially...
2024-06-24 (first published: 2024-06-03)
629 reads
Resetting Git and Abandoning Changes–#SQLNewBlogger
I recently had an issue in one of my Git repos, and decided to drop all my local changes and just pull down from the remote. This post looks...
2024-06-24
103 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