Self-confidence is the most important competency to deliver any work at your workplace. You work as front-end representative, as a boss or you are a point of contact for your clients, If you don’t have enough self-confidence then it will...
There are many good distributions in the GNU/LINUX world, but if we want a “universal” one, I think we should talk about Debian. Debian is a distribution with a phenomenal track record with stability as its main focus but also...
I have published SQL Server Interview Questions and Answers on many topics. Visit attached link to get All SQL Server Interview Question and Answers published on this website on different topics. Here, I am going to publish SQL Server Alwayson...
SQL Server 2017 is feature rich product that has been launched with multiple new features. You can read attached article where I have explained Top 10 new features added in SQL Server 2017 database engine. I have also explained about...
SQL Server Performance Tuning is an important subject and it is essential to implement various measures at regular intervals of time to optimize the scalability and performance of the Server. There are multiple areas which we analyze to understand a...
This article is very useful if you want to learn Cloud Computing. Here, I have explained all concerns that comes in a beginner’s mind along with required training courses. Cloud Computing is growing faster than ever and creating lot of high...
If you are planning to upgrade your SQL Server instance that hosts an Always on Availability Group (AOAG) to a latest version SQL Server 2017 or you are planning to patch Alwayson Availability Group instances, then you should plan it...
Last week, I was installing SQL Server 2012 on one of the database server. Unfortunately, the installation was failed with the error 1639. I have given below the details of this error code. Product: Microsoft SQL Server Browser – Update...
I have written how to install PostgreSQL 10.1 on debian 9 stretch in my last article. Read the attached link if you want to learn its step by step process. Here, I am going to install pgAdmin 4 on debian...
Sometimes, we need to restore a database that is part of always on availability group to fulfill our business needs. There might be several reasons behind doing this. Restore a database in availability group is different than restoring a normal...
I will show you how to install PostgreSQL latest version on debian operating system in this article. PostgreSQL is one of the popular database management system, distinguished by its speed and reliability to maintain the data of our applications. As...
Whenever you extend the size of your data or log file with a larger value or your database perform autogrow operation to extend its database files with bigger value then SQL Server takes longer time to perform such activities. SQL...
Adding or Removing databases from availability group is not day to day task but we need to perform such activities whenever it required. You can read attached article to learn how to remove database from availability group. Here, I will...
This article describes how to remove availability database(s) from an Always on Availability Group by using SQL Server Management Studio and Transact-SQL. Here, we will be removing primary database from availability group that will remove corresponding secondary database from AOAG...
Today, I will explain how to fix SQL Server error 53 (The network path was not found). The details about SQL error 53 are given as “A network-related or instance specific error occurred while establishing a connection to SQL Server....
