SQL Server interview questions: - Explain architecture of Notification Services?

This is the SQL Server interview questions which more of Database administrator (DBA) oriented. Have a look before going for interview. So one can start answering this question as follows.

Detail sections in SQL notification services:-

Notification Service application: - It’s a simple user application which will be used to add subscription to the subscription database.

Event providers: - All events reside in Event providers. There are two event providers which are provided by default “File System watcher” and “SQL Server event provider”. “File System watcher” detects changes in operating system files. “SQL Server event provider” watches for SQL Server or analysis service database for change. You can also plug in custom event providers. When event providers find any change in database, they send the event in “Event” table.

Generator: - Generator checks the event database, when it finds any event it tries to match with the subscription and sends it to the notification database. So generator in short is the decision maker between the subscribers and the events.

Distributor: - Distributor continuously pools the “Notification” database for any “Notification’s” to be processed. If the distributor finds any entry, it retrieves it and formats it so that it can be delivered to the end recipient. Formatting is normally done using “XML” and “XSLT” for rendering purpose.

After the formatting is done, it is then pushed to the “distribution providers”. They are nothing but medium of delivery. There are three built-in providers:-

• SMTP provider
• File provider
• HTTP provider

Figure: - Detail architecture of SQL notification services.

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



Click for more SQL Server interview questions

Regards,

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

13 important SQL Server interview questions on notification, integration, reporting services

This section will cover the most asked SQL Server interview questions by the interviewer so have a look on the following and do revise it when ever you go for the SQL Server interview

Normally SQL Server interview starts with.....

What are notification services?
What are basic components of Notification services?
Can you explain architecture of Notification Services?
Which are the two XML files needed for notification services?
What are ADF and ACF XML files for?
What is Nscontrols command?
What are the situations you will use “Notification” Services?
What is Integration Services import / export wizard?
What are prime components in Integration Services?
How can we develop a DTS project in Integration Services?
Can you explain how can we make a simple report in reporting services?
How do I specify stored procedures in Reporting Services?
What is the architecture for “Reporting Services “?

So friends answering to above question on notification, integration, reporting services of SQL Server interview questions helped me to clear in front of the interviewer.