Recently I was helping one of my clients on Performance Health Check, they asked me if I know how to Deploy Postgres Add-Ons on Heroku.
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.
SQL SERVER – Simple Recovery Model and Restrictions
I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?
SQL SERVER – Running Log Backup While Taking Full Backup
They found out that they have a full backup running for one of the largest servers and at the same time they are running a log backup on the same server.
SQL SERVER – What is Spinlock?
After reading both the blog post, I got another question from my client on What is Spinlock? Let us discuss today What is Spinlock.Â
SQL SERVER – NULL Values and CONCAT Function
A lot of SQL in the Sixty Seconds video recently, we will be looking at a very interesting T-SQL CONCAT function and how it works with the NULL Values.
Pinned Tab – SSMS Efficiency Tip – SQL in Sixty Seconds #121
Lots of people asked me to share the SSMS efficiency tip so I have shared the same in this blog post. Today’s topic is the pinned tab in SSMS for efficiency.