Log in

Previous Entry | Next Entry

An SQL Server interview questions asked in the interview. So do read the following answer before going for an interview.

Following are the essential components of SQL Server:-

  • End-Points

The endpoints can be two applications running on different servers or instances, or they can be two applications running on the same server.

  • Message

A message is an entity that is exchanged between Server Brokers. A message must have a name and data type. Optionally, a message can have a validation on that type of data. A message is part of a conversation and it has a unique identifier as well as a unique sequence number to enforce message ordering.

  • Dialog

Dialog ensure messages to be read in the same order as they where put in to queue between endpoints. In short, it ensures proper ordered sequence of events at both ends for a message.

  • Conversation Group

Conversation Group is a logical grouping of Dialog. To complete a task you can need one or more dialog. For instance an online payment gateway can have two Dialog’s first is the “Address Check” and second is the “Credit Card Number” validation, these both dialog form your complete “Payment process”. So you can group both the dialogs in one Conversation Group.

  • Message Transport

Message transport defines how the messages will be send across networks. Message transport is based on TCP/IP and FTP. There are two basic protocols “Binary Adjacent Broker Protocol” which is like TCP/IP and “Dialog Protocol” which like FTP.

See the following video on calling a stored procedure using LINQ: -

Click for more SQL Server interview questions


Visit for more author’s blog on SQL Server interview questions

Copy right www.questpond.com

Buy 600+ Real Time Interview Videos

Call +91-22-66752917 or mail us on questpond@questpond.com for more details on C#, .NET, ASP.NET, SQL Server interview question videos.

SQL Server interview question videos

Latest Month

August 2014


Powered by LiveJournal.com