SQL Server

Fix SQL Error 18456: failed to open the explicitly specified database

This article will help you fixing SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly…

Fix Always ON Connection Timeout Error 35206 in SQL Server

Recently, my company has migrated all critical SAP systems from on prem Linux based Oracle databases to Azure Cloud windows…

How to Change Session Timeout for Availability Group Replica

Sometimes we get alwayson connection timeout errors on availability group replicas. Always on Connection timeout or alwayson session timeout is…

Learn How to use SQL Server BETWEEN Operator

SQL BETWEEN operator is used to get values between a range of data inputs. We can use SQL BETWEEN operator…

Fix SQL Server Error 121 – The Semaphore Timeout Period Has Expired

Yesterday one of my teammate got a weird error while executing a T-SQL script. We are talking about SQL Server…

How to Change Authentication Mode in SQL Server?

Authentication is a process to establish a successful connection. SQL Server provides two types of authentication modes to connect to…

Fix SQL Server Error 802: There is insufficient memory available in the buffer pool.

We receive SQL Server error 802 when buffer pool of SQL Server instance is full and cannot grow further. Here,…

SQL Server Update Statistics Best Practices

Update Statistics in SQL Server is very important maintenance activity to keep database's statistics up to date. This helps SQL…

Understanding Hybrid Buffer Pool in SQL Server

Microsoft introduces a new feature called Hybrid Buffer Pool in SQL Server 2019 CTP 2.1. Read this article to understand…

Fix:VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’

Yesterday, one of the app user was complaining that he is not able to execute some of the queries and…

SQL Server Error 5184: Cannot use file ‘I:\Path\Techyaz.mdf’ for clustered server

Today, one of my team mate was trying to attach a database on one of the clustered SQL Server instance.…

How to Add Data File to Availability Database?

Sometimes, we need to add data file to availability database in Always on Availability Group. Adding database file is a…

SQL Server Native Client Error 50000: A network error occurred while attempting to read from the file

Yesterday i have received SQL Server Native Client Error 5000 while installing SQL Server Management Studio on one of the…

What is Enhanced Database Failover and How to Enable it for Availability Group?

As we know Always on Availability Group is the set of user databases that are combined to failover if primary…

Upgrade or Patch SQL Server Failover Cluster Instance Running with Availability Group

I have explained step by step process to upgrade or patch SQL Server instance that hosts an Always on Availability…