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...
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...
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...
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...
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...
Performance Tuning / SQL Server / SQL Server Administration / Troubleshooting
by Manvendra Deo Singh · Published May 1, 2018
We should always monitor system resource utilization of our database servers and make sure that these utilizations should not exceed the benchmark ranges of our environment. Today, I will explain about monitoring top perfmon counters for CPU usage. If your...
Performance Tuning / SQL Server / SQL Server Administration / Troubleshooting / Wait Types
by Manvendra Deo Singh · Published April 30, 2018 · Last modified May 1, 2018
Memory is one of the important system resource that SQL Server uses to process their transactions. Sometimes, your server might face memory bottleneck that reduces the performance of running transactions. Here, I will explain top 10 performance counters to identify...
Today I am going to discuss SQL Server memory issues that your database Instance might face during bulk data load or during any memory intensive operations. You may also face insufficient memory issue when you try to execute numerous queries...
This time we continue with the explanation of simple Linux command to learn basics. The command chosen today is the cat command. Cat comes from the word “concatenate“. In short the main utility is to display the contents of one or...
SQL Server / SQL Server Administration / T-SQL / Troubleshooting
by Manvendra Deo Singh · Published April 23, 2018
Changing SQL Server Instance name is not a routine task. Although, sometimes we get requirements to change SQL Instance name. There are multiple scenarios in which we need to rename SQL Server Instance like: If you have changed database server...
SQL Server / SQL Server Administration / SSRS / Troubleshooting
by Manvendra Deo Singh · Published April 19, 2018 · Last modified April 23, 2018
Sometimes we need to change the name of the server or computer on which SQL Server instance is running. Once we make changes in server name we need to change the name of installed SQL Server instance name as well...
Linked_server / SQL Server / SQL Server Administration / T-SQL / Troubleshooting
by Manvendra Deo Singh · Published April 18, 2018 · Last modified April 23, 2018
I got this error 15190 while renaming SQL Server Instance name. I was not able to drop the existing SQL Server instance name using sp_dropserver stored procedure and was getting error 15190. Full description of this error is given below....
Interview Questions / Presales / Presales Interview Questions
by Shatakshi Singh · Published April 17, 2018
I have already published Presales Interview Questions & Answers Part 1 in attached link . I would recommend you to visit attached link to read it. Here, i am going to write second part of pre sales interview questions. If you...
Today, I got error 1105 on one of the database server. We were processing some bulk transactions on a database but failed because of space issue. Full description of error 1105 is given below. Error 1105, Severity 17, State 2...
SQL Server / SQL Server Administration / Troubleshooting
by Manvendra Deo Singh · Published April 10, 2018 · Last modified April 16, 2018
Yesterday, one of my teammate was facing an issue while enabling a server level parameter using T-SQL command sp_configure. He was trying to enable extended procedure xp_cmdshell using sp_configure command but he received error 15123. Full description of error is given below....
