This article is based on SQL Server backup & recovery interview questions and answers. You can access SQL Server Architecture based interview questions and General DBA related interview questions in attached links. Feel free to counter on any point that is...
We got this Microsoft SQL Server error 35250 while configuring Alwayson Availability Group on one of the SQL Server Instance. There could be multiple reasons behind this SQL error 35250. You can find multiple solutions to fix this issue based...
SQL Server 2017 is major release that are coming with lots of new features. The most debated new feature in SQL Server 2017 is its support for Linux based operating systems. Yes, now you can install and run SQL Server...
I have shown how to install SQL Server 2017 on Ubuntu server that have internet access in my last article. If your Ubuntu server doesn’t have internet access then you should read attached article to install SQL Server in offline...
We can easily install SQL Server 2017 on Ubuntu server if we have internet access to the online repositories but little painful if we don’t have internet access to the server. You can read attached article to learn how to...
This is second series of SQL Server DBA Interview questions & answers. I have published SQL Server Interview questions & answers on Database Basics and Architecture in attached article. Here, you will have another round of SQL Server DBA Interview...
I was configuring AlwaysOn Availability Group between two replicas. Everything was configured successfully but Listener was failed to create with an error 19471. I have already explained how to fix listener error 19471 in attached article but this has not...
SQL Server Auto Shrink is database property that allow database engine to automatically shrink database files if its value set to ON/True. Shrinking a database is not a good practice because it is very expensive operation in terms of I/O,...
We use SQL Server database Autogrowth setting to automate database file growth. This property is very helpful if you use it carefully with proper planning. But there can be a negative performance impact on your database if you don’t give attention...
This series of SQL Server Interview Questions & Answers are based on real interviews. I have collected all these questions from multiple senior DBAs who are involved in taking interviews. This set of questions is specially for junior or mid...
Migrating data from Oracle to SQL Server is very complex process. Although, it has become little easy using SQL Server Migration Assistant for Oracle. Last week, i was working on migration project where we were migrating Oracle databases to SQL...
We know SQL Server Backups are resource intensive operation that strain on I/O and CPU (with backup compression). AlwaysOn Availability Group has very good capability to offload SQL Server backups and read operations from primary replica to reduce such workloads...
I installed SQL Server 2017 on Ubuntu server and tried to connect to this server using PuTTY from my local host. I failed to connect and received PuTTY fatal error ubuntu ssh connection refused. Read this tip to fix this PuTTY...
Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability Group configuration. The details about error Microsoft SQL Server 976 that he was getting is given below. Cannot connect to...
Sometimes we need to check the IP, Subnet mask and default gateway of our Linux machine and sometimes we need to change them as per our requirement. Here i will explain how to check and change these properties. If you...
