Blog

Kafka Fundamentals

Apache Kafka is a powerhouse for real-time data streaming, acting like a superhighway for data that never sleeps. For database engineers dipping their toes into streaming, it’s your bridge from batch processing to instant insights. Kafka Basics Picture Kafka as a distributed post office for massive data volumes. Producers (apps sending data) drop messages into…

Azure PostgreSQL Flexible Server: Inactive Replication Slots Eating Your Storage (And How to Fix It)

Inactive replication slots in Azure Database for PostgreSQL Flexible Server can silently fill your disk with WAL files. Here’s how to spot, drop, and prevent them. The Problem: WAL Explosion from Orphaned Slots Replication slots ensure WAL retention so consumers (CDC tools, read replicas) don’t miss changes. Inactive slots—created by stopped CDC jobs, deleted replicas,…

Automating SQL Server User Removal with PowerShell and dbatools

Introduction When an employee leaves or a service account is retired, it’s essential to remove their access cleanly and consistently from SQL Server.Manually revoking access across multiple databases can be error-prone and time-consuming — especially in large environments. In this post, we’ll look at how to use the dbatools PowerShell module to automatically remove a…

Automate SQL Server Database Role Assignment with PowerShell and dbatools

Introduction As a SQL Server DBA, one of the most repetitive administrative tasks is granting user access to multiple databases — especially in environments with dozens or even hundreds of databases.Instead of manually connecting to each database and assigning roles, you can automate the process with the dbatools PowerShell module. In this post, we’ll walk…

Something went wrong. Please refresh the page and/or try again.

About Me

Hi, I’m Vinay Are. Principal Database Engineer at Teladoc Health Inc. I spend my time with my daughter and wife when I am not working. In my spare time, I do landscape and macro photography as a hobby. This blog is for my love of databases, a place to store important things I want to remember about databases

Subscribe to My Blog

Get new content delivered directly to your inbox.

Leave a comment