We had a long conversation about the strategy and direction of the organization and how the organizations can go to the next level by leveraging Cloud Computing.
What is the Cloud?
We had a long conversation about the strategy and direction of the organization and how the organizations can go to the next level by leveraging the Cloud.
What does Verify Backup When Finished do in SQL Server? – Interview Question of the Week #283
Question: What does Verify Backup When Finished do in SQL Server? It looks like a very important step in the entire backup and restores.
SQL SERVER – Adding Default Value to Existing Table
While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.Â
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.Â
SQL SERVER – Disable Statistics Update on a Specific Table
Just earlier today when we were fixing the performance of a database during, we found a unique requirement to disable statistics update on a table.
SQL SERVER – Reduce Deadlock for Important Transactions With Minimum Code Change
They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.
SQL SERVER – Network Protocol and IP Address
The question was if there is a way to know how many sessions are connected to current SQL Server instance with their network protocol as well as IP address.
SQL SERVER – Wait Statistics from Query Execution Plan
Recently one of my clients asked if I know a way to find the Wait Statistics from the Query Execution Plan. Yes, there is a way to do it.
Does BIT Datatype Equal to 1 or TRUE in SQL Server? – Interview Question of the Week #282
Question: Does BIT Datatype Equal to 1 or TRUE in SQL Server?
Answer: Very interesting question. Let us learn about it today.