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…
Yesterday, one of the app user was complaining that he is not able to execute some of the queries and…
Today, one of my team mate was trying to attach a database on one of the clustered SQL Server instance.…
Sometimes, we need to add data file to availability database in Always on Availability Group. Adding database file is a…
Yesterday i have received SQL Server Native Client Error 5000 while installing SQL Server Management Studio on one of the…
As we know Always on Availability Group is the set of user databases that are combined to failover if primary…
I have explained step by step process to upgrade or patch SQL Server instance that hosts an Always on Availability…
I had to add a log file to a database and then extend the size of this log file to…
Today, i will describe about the overview of failover modes in AOAG and how to Change failover mode of an…
Lock Pages in Memory is a Windows policy that assures the SQL Server or any other application to keep data in…
Today, I am going to discuss about Oracle to SQL Server Database Migration. This article will give you step by…