Category Archives: SQL Server DBA

MSSQL Security – Interview Questions and Answers

Posted on October 11, 2014 by uday arumilli

sql server security interview questions   1. What is the Guest user account in SQL Server?  What login is it mapped to it?   Ans: The Guest user account is created by default in all databases and is used when explicit … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , | 5 Comments

Interview Questions

Posted on October 4, 2014 by uday arumilli

sql server experienced interview questions Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 ​ Organization … Continue reading →

Posted in High Availability, Interview Q&A, MSBI, Performance Tuning, SQL Development, SQL Server DBA, SSIS, SSRS | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 68 Comments

Upgrading SQL Server Questions and Answers

Posted on October 3, 2014 by uday arumilli

Q&A Upgrading SQL Server Questions and Answers         1. Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition? Ans: You can’t change the version of the installed instance as far as I … Continue reading →

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , | 16 Comments