Yesterday I had a meeting with my client Performance Health Check, and they wanted to know how to store a non-English string in a table.
Heroku – How to Deploy Postgres Add-Ons?
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.