Many SQL developers do not know it well. For everyone to use, I am going to share the Stored Procedure Template in JavaScript for Snowflake.
SQL SERVER Agent Missing from SSMS
Comprehensive Database Performance Health Check. Recently I had a very interesting experience where SQL SERVER Agent was Missing from SSMS.
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.
PostgreSQL – Definition of a Materialized View
Recently, during a consultation, I had to work with PostgreSQL and we needed to find the Definition of a Materialized View.
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 Date Time in Python and SQL
After installing and getting started with Python, the very first exercise I did was to print the current date time in Python. Let us learn about it today.
Getting Started with Python
Well, I know the basics of Python Honestly, it is never late to learn a new language so I decided to get started with Python.