This is the fourth post in the series which captures my notes with various CXOs. Today we are going to discuss the various different types of Open Source.
Question: What does Verify Backup When Finished do in SQL Server? It looks like a very important step in the entire backup and restores.
While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.
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.
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.
They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.