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.
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.
SQL SERVER – Get Last Restore Date
Let us learn how to get the last restore date for the backup in SQL Server. Here is a very simple script for the same. Let me know your feedback.
SQL SERVER – When to Use DBCC CLEANTABLE?
Recently a client of mine asked me – When to Use DBCC CLEANTABLE? A question to be discussed in Comprehensive Database Performance Health Check.
SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions
What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.