Cloud Security – How to Secure Cloud Environment?

Today, I am going to discuss about securing cloud environment. Cloud security is popular word in IT industries these days.…

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…

SQL Server Replication Interview Questions & Answers

Today i am going to write about SQL Server Replication Interview questions and answers. Read another set of interview questions…

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…

SQL Server Error 5009: One or more files listed in the statement could not be found or could not be initialized

I had to add a log file to a database and then extend the size of this log file to…

13 Email Management Best Practices to Manage Inbox Effectively

Email is a very good communication tool used across organizations. Email Inbox Management is a talent and it is required…