I have recently built the course on Snowflake at Pluralsight where I get you going with the SQL Extensibility Features with Snowflake.
Snowflake – Analysis Query Performance
I am doing consulting Snowflake Comprehensive Database Performance Health Check, who recently asked me if I know any way to Analysis Query Performance.
SQL SERVER – Table Partitioning for Slow Performance
Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.
Snowflake – Query Result from Cache or Disk
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 – Stored Procedure Template in JavaScript
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.
Learning MongoDB is Easy
Python Getting Started with Python, lots of people wrote to me that I should learn about MongoDB. Yes, I agree. Learning MongoDB is Easy.
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.