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 this feature.
Latest Articles
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. Let’s start with basics and all possible ways to protect your cloud environment. Cloud Security Streams / Features Today we...
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 facing “VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ . (Microsoft SQL Server, Error 300) ” error while...
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. He got error 5184 while attaching the database. The details about error 5184 is given below. Msg 5184, Level 16,...
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 straight forward method but if your databases participate in Always on Availability group then you need to take extra care...
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 client machine. The description for this error code was given as “A network error occurred while attempting to read from...
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 replica becomes inaccessible. Till SQL Server 2014, Alwayson Availability Group was not able to start failover operation if any individual...
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 and answers on other SQL Server features attached later in this article. SQL Server Replication Interview Questions & Answers Question –...
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 Group (AOAG) to latest version in attached article. Here, I will explain how to upgrade or patch SQL Server failover...
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 a specific value. I got SQL Server error 5009 while creating the log file and got same error code again...
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 at every level in a corporate workplace. At every level we deal with number of emails daily which have to...
How to Change Failover Mode of Availability Replica in Always On Availability Group?
Today, i will describe about the overview of failover modes in AOAG and how to Change failover mode of an availability replica in SQL Server Alwayson Availability Group. As we know SQL Server Always on availability group fails over to...
How to Enable Lock Pages in Memory for SQL Server?
Lock Pages in Memory is a Windows policy that assures the SQL Server or any other application to keep data in physical memory and not page out by windows if it is enabled for that application. This is very useful setting...
How to Install SSMA for Oracle to Migrate Oracle Database to SQL Server
Today, I am going to discuss about Oracle to SQL Server Database Migration. This article will give you step by step method to install Microsoft SQL Server Migration Assistant for Oracle. We also call it SSMA for Oracle. Microsoft has...
How to Change Database Default Locations in SQL Server?
Sometimes, we need to change default database File locations to some other path in SQL Server. If you have configured SQL Server default database file location as drive C then all SQL Server databases will be created in the path...