Tag Archives: sql server 2012

New Features Added in SQL Server

New Features Added in SQL Server This post helps you in quickly reviewing the “New Features Added in SQL Server” from 2008 to 2016. The most common interview question is “What are the new features added in SQL Server XXXX?” … Continue reading

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

MSSQL Security – Interview Questions and Answers

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

How to generate script for multiple objects in a database – SQL Server

Generating script for Stored procedures and views in SQL Server 2012 Today I have got a question from one of the beginner DBA. He was actually asked to get “CREATE SCRIPT” for 35 stored procedures and 15 views from one … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , | Leave a comment