Fetch the DB Object Backed by an External Database
SELECT OBJECT_SCHEMA_NAME(d.referencing_id) AS referencing_schema, OBJECT_NAME(d.referencing_id) AS referencing_object, o.type_desc AS referencing_type,
Apr 13, 20261 min read
Command Palette
Search for a command to run...
Latest articles
Reveal Your Wi-Fi Passwords on Windows 10/11 Through Command Prompt
View saved Wi-Fi passwords on Windows 10/11 using Command Prompt. Open Command Prompt as an administrator. To list saved Wi-Fi profiles netsh wlan show profiles To view the password of a profile netsh wlan show profile name="NETWORK NAME" key=clear ...
Nov 19, 20251 min read2Automate Relay Control with Tasmota's Timer Feature
//turn off Rule1 Rule1 0 //Clear Rule1 Rule1 "" //Rule to turn on relay on boot and then toggle the state every 1800 seconds Rule1 on System#Boot do backlog RuleTimer1 1800; Power1 ON endon on Rules#Timer=1 do backlog Power1 Toggle; RuleTimer1 1800...
Nov 4, 20251 min read10Dynamic API Routing with Azure APIM: Leveraging Query Strings for Enhanced Flexibility
Azure API Management (APIM) allows developers to manage and secure APIs effectively. One of its powerful features is the ability to switch APIs based on query string values. This capability enables dynamic routing and customization of API responses, ...
May 22, 20251 min read7
Azure API Management: A Guide to Load Balancing OpenAI Instances
Azure API Management policy for load balancing Azure OpenAI instances can be a powerful tool for optimizing performance and ensuring reliability. By distributing requests across multiple instances, you can enhance the scalability and availability of ...
Apr 17, 20252 min read7
Fast Method to Obtain All File Info from a Directory Tree
FileList \\Server\Documents > ListOfFiles.csv FileList is a command-line utility that generates a CSV file listing the contents of a given directory. By default, the list includes the file name, size, and path, as well as the last-access, last-modif...
Jul 17, 20241 min read36How to pass null values to stored procedures from PowerApps
Power apps uses Flow/Automate to call connect to sql and execute a stored procedure. But flow will not allow you to pass Blank/null value from power app. As a fallback what we can do is, pass a know default value to the flow and in flow check for the...
Jan 24, 20241 min read337unable to get local issuer certificate (node-gyp, Node, npm)
This should be used only as a temporary fix for development, it exposes you to man-in-the-middle attacks. The long-term solution should be to properly set up SSL certificates. Windows set NODE_TLS_REJECT_UNAUTHORIZED=0 Linux export NODE_TLS_REJEC...
Jan 4, 20241 min read124Use multiple node versions on a machine
Node Version Manager (NVM)
Jan 2, 20241 min read9