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.
SQL SERVER – CPU Scheduler Waiting On Disk
Comprehensive Database Performance Health Check. Let us figure out today a very simple and effective script for CPU Scheduler Waiting On Disk.
SQL SERVER – Troubleshooting High CPU
We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.
SQL SERVER – Upcoming Speaking Engagements 2021
Here are details of my Upcoming Speaking Engagements 2021. I will be mostly presenting on SQL Server Performance Tuning. Let us see today.
Generate Script of SQL Server Objects – SQL in Sixty Seconds #184
Today we will see the same concept translating in the video. Let us learn about Generate Script of SQL Server Objects in video format.
Quest EMPOWER Virtual Conference 2021
I am extremely excited to share the news that I will be speaking at Quest EMPOWER Virtual Conference 2021 held on date November 10–11, 2021.Â
SQL SERVER – NOLOCK with DMVs
Is it alright to use NOLOCK with DMVs? I was recently asked about this by a client during the Comprehensive Database Performance Health Check.