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...
We get T-Shirt sizing task very often these days. It used to require lot of work in the past to design T-Shirt sizing but It is nice to see this coming as new feature with an easy way to setup...
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...
SQL Server Backups are the dump of its databases that can be used to recover them in case of any corruption, outage or emergency. Backups are essential for data protection. We run SQL Server backups to safeguard our databases from...
I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was configuring Always On Availability Group again on this database server. We followed all processes but Listener was failed to create...
A Recovery Model is a database property that designed to control transaction log maintenance. SQL Server Recovery Model does not define how transactions will be logged but they define how transaction logs will be managed in the transaction log file....
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a SQL Server database. Have you ever thought how SQL Server initialized its database files during space allocation? General way to...
I was working in a project where I came to know client was using MSDN licenses on production environment. Though they have MS SQL Server license available but those SQL Server licenses were not applied on this production server. This...
Last week, I had a requirement to check the row counts of all the tables present in a database. I used attached article to get the row counts of all tables. We get row counts of all tables using system...
SQL Server Agent is very useful in automating any database activities. By default, it is not installed along with SQL Server on Linux server. You need to manually install it after installing SQL Server. Here I will explain step by...
I have shown you how to install SQL Server on Redhat Linux Server in my last article. Here I will explain step by step process to install SQL Tools on RedHat Linux 7.3 server. Installing SQL Tools will install sqlcmd...
