SQL Server on AWS EC2

SQL Server on AWS EC2

SQL Server on AWS EC2 - 1

 Introduction:

Here we are going to discuss about SQL server on AWS EC2. First let me quickly explain what the difference between AWS offerings for SQL Server. There are two types of AWS services for database hosting

Continue reading

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , | 2 Comments

SQL DBA AlwaysOn scenario based interview questions – 3

SQL DBA AlwaysOn scenario based interview questions – 3

SQL DBA AlwaysOn scenario based interview questions – 3

One of the best known feature introduced in SQL Server 2012 is “AlwaysOn” which makes use of existing HA/DR features and provide additional features like Availability Groups. This article is for SQL Server DBA’s who are preparing for interviews, this include basic and advanced level SQL DBA AlwaysOn scenario based interview questions and answers One can easily expect scenario based questions in today’s technical interviews. Here are the scenario based questions.

SQL DBA AlwaysOn scenario based interview questions – 3:

Q. We have got an alert “WSFC cluster service is offline”. What is your action plan?

Ans:

Continue reading

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , | 4 Comments

sql dba alwayson interview questions – 2

SQL DBA AlwaysOn

Interview Questions and Answers – 2

sql dba alwayson interview questions - 2

One of the best known feature introduced in SQL Server 2012 is “AlwaysOn” which makes use of existing HA/DR features and provide additional features like Availability Groups. This article is for SQL Server DBA’s who are preparing for interviews, this include basic and advanced level SQL DBA AlwaysOn Interview questions part-2.

SQL DBA AlwaysOn Interview Questions  – 2

Q. What is availability group wizard?

Ans:

Continue reading

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , | 4 Comments