MS SQL Server is a client-server architecture. MS SQL Server process starts with the client application sending a request. The SQL Server...

Most of us often get confused around the terms SQL Server Buffer Cache and Buffer Cache Hit Ratio. In this post we will see and learn...

In this blogpost we will see and learn how to check and change SQL Server Authentication Mode. Before we get started, lets see the two...