SQL Server Backup & Recovery Interview Questions & Answers
This article is based on SQL Server backup & recovery interview questions and answers. You can access SQL Server Architecture…
8 years ago
Manvendra Deo Singh
SQL Server Alwayson Error 35250: Joining database on Secondary Replica resulted in an error
We got this Microsoft SQL Server error 35250 while configuring Alwayson Availability Group on one of the SQL Server Instance.…
8 years ago
10 New Features in SQL Server 2017 Database Engine
SQL Server 2017 is major release that are coming with lots of new features. The most debated new feature in…
8 years ago
Install SQL Server Agent on Ubuntu Server
I have shown how to install SQL Server 2017 on Ubuntu server that have internet access in my last article.…
8 years ago
Install SQL Server 2017 on Ubuntu with Internet Access
We can easily install SQL Server 2017 on Ubuntu server if we have internet access to the online repositories but…
8 years ago
SQL Server DBA Interview Questions & Answers
This is second series of SQL Server DBA Interview questions & answers. I have published SQL Server Interview questions &…
8 years ago
Fix AOAG Listener Error 19471: Kerberos Status is Showing The handle is Invalid
I was configuring AlwaysOn Availability Group between two replicas. Everything was configured successfully but Listener was failed to create with…
8 years ago
Why Should You Always Turn Off Database Auto Shrink Property?
SQL Server Auto Shrink is database property that allow database engine to automatically shrink database files if its value set…
8 years ago
Understanding Database Autogrowth in SQL Server
We use SQL Server database Autogrowth setting to automate database file growth. This property is very helpful if you use it…
8 years ago
SQL Server Interview Questions & Answers – Architecture
This series of SQL Server Interview Questions & Answers are based on real interviews. I have collected all these questions…
8 years ago
How to Change Batch Size for Oracle to SQL Server Migration using SSMA
Migrating data from Oracle to SQL Server is very complex process. Although, it has become little easy using SQL Server…
8 years ago
Understanding Backup Preferences for AlwaysOn Availability Group Databases
We know SQL Server Backups are resource intensive operation that strain on I/O and CPU (with backup compression). AlwaysOn Availability…
8 years ago
Fix PuTTY Network Error: Connection Refused while Connecting to Ubuntu Server
I installed SQL Server 2017 on Ubuntu server and tried to connect to this server using PuTTY from my local…
8 years ago
Fix SQL Server Error 976: Cannot connect to Secondary Replica of AlwaysON Availability Group
Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability…
8 years ago
How to Find and Change IP Address, Subnet Mask & Default Gateway of Linux Server
Sometimes we need to check the IP, Subnet mask and default gateway of our Linux machine and sometimes we need…
8 years ago