Use sp_invoke_external_rest_endpoint in SQL Server 2025 with controlled permissions, JSON responses, protected credentials, and retries.
How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091
How do you introduce a Time Delay between two T-SQL commands? An interview question developers ask often, answered with WAITFOR DELAY.
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 – How to Find Out When Your SQL Login Will Expire?
A client wanted a script to show when each SQL login will expire. LOGINPROPERTY makes it easy on SQL 2008 onwards. Here is the query I used.
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.