Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.
Snowflake JavaScript Procedure: A Stored Procedure Template
A Snowflake JavaScript procedure wraps SQL statements in JavaScript code. This post gives a clean template, shows how to call it, read a result, pass an argument and catch an error. The code follows Snowflake’s documented API and was not run on a Snowflake account.
SQL SERVER Agent Missing from SSMS
Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.
Shredding JSON Into Relational Tables in One Pass
Use shredding JSON to stage parent and child rows, validate their data, capture identity mappings, and load relational tables atomically.
SQL SERVER – Last 5 SQL in Sixty Seconds Video
Today I am going to share the last 5 SQL in Sixty Seconds videos with you all. Please let me know which of the last 5 you find the most interesting and why?
Current Timestamp in Python and SQL: One Format, Two Tools
To get the current timestamp in Python, import datetime, call now and format the result with strftime. This post prints the same date and time in Python and in T-SQL, compares the two clocks, and shows how to ask for UTC in both.
sp_execute_external_script: Run Python Inside SQL Server
Before you write any Python, check four switches. Here is how to read them, what error 39023 means, and what to test on your own server.