Use sp_invoke_external_rest_endpoint in SQL Server 2025 with controlled permissions, JSON responses, protected credentials, and retries.
Out-of-Row Storage for varchar(max): Keeping Data Pages Small
Turn on the out-of-row option and nothing happens until you rewrite the data. I measure pages and reads at each step so you can see the real trade.
PowerShell – Create a User with Read Rights on a Database
A DBA kept creating database users by hand. Here is a simple PowerShell and SMO script to create a user with read rights on a database.
SQL SERVER – Simple Example of BCP Command Line Utility
Need to export table data fast? A step by step, simple example of the BCP Command Line Utility, from finding bcp.exe to running the export.
SQL SERVER – SSMS Trick – Switching Columns in Grid Output
Can you reorder columns in SSMS grid output without rewriting the query? A trick from Vinod Kumar’s user group session that surprised me.
SQL SERVER – Hidden SSMS Gem: Find Dialog’s Unknown Functionality
At a Bangalore user group meet, Vinod Kumar showed a Hidden SSMS Gem: something the Find dialog can do that I never knew in years of using it.
SQL SERVER – Patch Installation Error: The version of SQL Server instance does not match the version
Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error.