Blog

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…

Deep Dive: Snowflake to Azure Private Link Service Connection

Break down in plain language, building from basics to the complete picture. What is Azure Private Link Service? (The Analogy) Think of Azure Private Link Service like a private, secure doorway between two buildings: Azure Private Link Service creates a private tunnel through the ground (Azure’s backbone network) that only connects these two specific buildings,…

Private Link Service for Snowflake OpenFlow: Technical Overview

Understanding Private Link Service vs Private Endpoint Key Distinction The Challenge with VNet-Injected MySQL Flexible Server When MySQL Flexible Server is VNet-injected: How Private Link Service Solves This Architecture Flow Step-by-Step Process Traffic Direction Analysis Inbound Connection Requirement YES, the inbound connection shown in your diagram is necessary because: Traffic Flow Breakdown Phase Direction Description…

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