SQL Server on AWS EC2

Posted on March 21, 2016 by uday arumilli

SQL Server on AWS EC2

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 access sql server using putty, Amazon Web Services, AWS EC2, AWS RDS, connect sql server using putty, connecting from SSMS to SQL Server running on amazon AWS EC2, Creating an SSH port tunnel with PuTTY, How to access SQL Server on EC2 from local, how to connect to SQL Server on AWS, how to setup putty, Problem connecting to SQL Server on Amazon EC2 instance, running sql server on Amazon Cloud, SQL on AWS EC2, SQL Server Connectivity Issues, SQL Server connectivity issues on AWS EC2, SQL Server database access on EC2, SQL Server on Amazon Web Services, SQL Server on AWS EC2, SSMS not working on cloud, Unable to Connect to SQL Server cloud | 4 Comments

SQL DBA AlwaysOn scenario based interview questions – 3

Posted on February 14, 2016 by uday arumilli

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 AlwaysOn availability Groups, SQL DBA AlwaysOn scenario based interview questions – 3, sql dba alwayson scenario based interview questions and answers - 3, sql server dba interview questions and answers for 2 years experience, sql server dba interview questions and answers for 3 years experience, sql server dba interview questions and answers for 5 years experience, sql server dba interview questions and answers for experienced, sql server dba interview questions and answers pdf, sql server dba interview questions on alwayson, sql server dba interview questions pdf download | 14 Comments

sql dba alwayson interview questions – 2

Posted on February 14, 2016 by uday arumilli

SQL DBA AlwaysOn

Interview Questions and Answers – 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 AlwaysOn availability Groups, sql dba alwayson interview questions - 2, sql dba interview questions and answers for experienced, sql dba interview questions and answers for freshers, SQL DBA interview questions on sql server 2012, SQL DBA interview questions on sql server 2014, SQL Server 2012 interview questions and answers, sql server alwayson interview questions | 4 Comments