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
How to Create T-Shirt Size Blueprint in vRealize Automation 7.3
We get T-Shirt sizing task very often these days. It used to require lot of work in the past to…
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
Understanding SQL Server Backups
SQL Server Backups are the dump of its databases that can be used to recover them in case of any…
8 years ago
Fix SQL Server Error 19471: Listener issue that came during Configuring SQL Server AlwaysOn Availability Group
I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was…
8 years ago
What is Instant File Initialization and How to enable it on SQL Server Instance?
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a…
8 years ago