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?
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.