SQL Server instance metadata inventory with PowerShell and SMO

SQL Server instance metadata inventory with PowerShell and SMO

The purpose of this article is to introduce a PowerShell script that I wrote and published on...

5 SQL Tricks Worth Remembering Before You Close the Laptop

Disclosure: this post may contain links to books as an affiliate link. If you purchase through it, this site may earn a small commission at no extra cost to...

Creating a Pulsing Conducting Baton - Part 1

Train Wreck
The last time I watched a high school band nearly fall apart mid-performance was when the relatively new, certainly nervous band director started the piece off much faster...

Track SQL Server Configuration Changes Using the Error Log

Track SQL Server Configuration Changes Using the Error Log

If you work with SQL Server long enough, you or someone will eventually want to know, “Did...

Distance Metrics for Semantic Similarity Searches in SQL Server 2025

Next up in my series talking about The Burrito Bot is diving into the different distance metrics used to calculate how a vector generated from a query compares to...

Google – NotebookLM on ThakurVinay blog

Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer a search engine. it is a Major IT company in the industry. having strong base...

PowerShell Newbie – Variables

This is Week 2 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled in PowerShell but never stopped to nail down the...

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Over the past few weeks, I’ve been contacted by multiple customers experiencing the same frustrating issue. Applications and SSMS sessions that had been rock-solid for years suddenly started throwing...

Claude Desktop

Claude is more than a chat window. The desktop experience includes structured workspaces, generated outputs, integrations, execution capabilities, memory and reusable workflows. This is a quick introduction to some...

PowerShell Strikes Back: A New Script

This is it. The final chapter of PowerShell Strikes Back. Over the past four weeks, you’ve built a real foundation. You know that single quotes are literal and double...