-
March towards SQL Server : Day 26 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 4
Here I am posting final post on SQL Server Performance Tuning concepts. I hope you must have read our previous posts on Performance Tuning. If not, have a quick look Part1 , Part 2 and Part 3. 1. What are the lockable resources in SQL Server? The following table shows the resources that the Database…
-
March towards SQL Server : Day 25 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 3
Here goes another post on Performance Tuning concepts. You may want to take a quick look at previous post on this topic. Performance Tuning Part 1 Performance Tuning Part 2 1. What is Isolation level in SQL Server? Isolation level defines the degree to which one transaction must be isolated from resource or data…
-
March towards SQL Server : Day 24 – SQL DBA Interview Questions Answers – SQL Server performance Tuning – 2
Dear Readers, In this blog, I am taking a different approach. It’s very common that interviewer promptly asks another question from your answers only. Performance Tuning is the area where this can be done easily during any interview. Interviewer may just try to see if you really know about practical implementation of performance tuning…
-
March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning
Dear Reader, Today, I thought of writing interview questions on SQL Server Performance Tuning. I tried my best to touch upon many areas however Performance Tuning is something that can’t be covered end to end – you know that. Let me try starting from basic concepts to some scenarios type question. What is the use…
-
March towards SQL Server : Day 22 – SQL DBA Interview Questions Answers – REPLICATION Part II
Readers, Replication is a vast topic and there are many questions and scenario based issues which a DBA can face. So, today’s series of Interview Questions on Replication presents 31 more questions to make you a highly knowledgeable professional on replication. You can refer to Part I of Interview Questions series on Replication here. Happy learning! 1) Is it…
-
March towards SQL Server : Day 21 – SQL DBA Interview Questions Answers – REPLICATION
Dear Readers, Now as we have already crossed two third of the month and covered a lot of topics till date, Now lets get a deep insight about another very interesting feature of SQL Server, The Replication. It is simple, It is bit tough and It is complex at the same time depending on the…
-
March towards SQL Server : Day 19 – SQL DBA Interview Questions Answers – Always ON
After completing successful 18 Day – here comes the most awaiting and demanding series of interview questions and answers on Always On Feature. 1. What is Always on in SQL Server 2012? AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012,…
-
March towards SQL Server : Day 15 – SQL DBA Interview Questions Answers – Database Mirroring – 1
Next topic to High availability Questions Answers series is about Database Mirroring. This is very interesting topic and consists of very wide range of terminologies and scope. I will cover this topic in two blogs so that I can touch base all the possible Questions from Database Mirroring. 1. What is Database Mirroring? Database mirroring was…
-
March towards SQL Server : Day 14 – SQL DBA Interview Questions Answers – Log Shipping
This blog is about one of the High Availability feature supported by Microsoft SQL Server- Log Shipping. What is High Availability in SQL Server? A high availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.SQL Server high-availability solutions…
-
March towards SQL Server : Day 13 – SQL DBA Interview Questions Answers – Database Backups and Restore-4
Here I am posting fourth and last series of Backup/Restore interview questions. I am trying to cover most of the known errors and some concepts too. You may take a look at the other posts on Backup/Restore here. Day 10, Day 11 & Day 13 1) What are Partial Backups in SQL Server? Partial backups…
-
March towards SQL Server : Day 12 – SQL DBA Interview Questions Answers – Database Backups and Restore-3
Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Day 10 and Day 11 1) What is the Backup strategy in your environment? It’s very open ended Question: As per my understanding, normally Organizations follow below standards Prod/QA Environment: For Small size databases (<200…
-
March towards SQL Server : Day 11 – SQL DBA Interview Questions Answers – Database Backups and Restore-2
Continuing my Blog series on the Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to understand the SQL Server Database backups topic in more depth. 1) What are the Best Practices recommendations related to SQL Server Database backups? Backup is an important component of a…
-
March towards SQL Server : Day 10 – SQL DBA Interview Questions Answers – Database Backups and Restore-1
This blog contains series of most commonly asked Interview Questions regarding one of the important DBA tasks- Database Backups and Restore. Since this is very wide topic, I will try to cover all the sub topics in 2-3 blogs. 1) What are database backups? A Database backup is a copy of SQL Server data that can…