Scenario

ABC, Inc. wants to ensure that addressing and pricing information is synchronized between the central office and the branch offices. At present ABC Inc. requires a Service Broker solution, which will implement a process to address or handle the following events:

• Customer address information changes at the branch office. A stored procedure in the branch office database should write the changes to that database and then send a message (with the updated address information) to the central office database. A stored procedure in the central office database should receive the message, update that database, and then send a message (with the updated address information) to the other branch office databases.
• Item pricing information changes at the central office. A stored procedure in the central office database should write changes to that database and then send a message (with the updated item pricing information) to the branch office databases.

This solution can be designed by using the following steps:

Step-1: Designing a Service Broker Solution Architecture

Firstly, you need to design the architecture for a Service Broker solution for ABC Inc., and while designing the architecture you need to identify the Service Broker instances and conversations or dialogs to support your Service Broker solution.

Moving further, you must have identified the Service Broker instances, a service instance identifies helps to group of related conversations with a unique identifier and helps
to enable changes to customer information to be propagated between branch offices and the ABC, Inc. central office, and to enable changes to item prices to be propagated from the central office to the branch offices.

Then you would require to identify the conversations or dialogs, which provides two-way messaging to propagate changes between the databases at the central office and the branch office. The main purpose of having conversation or dialog is to provide an ordered sequence of events.

Step-2: Designing a Service Broker Solution

While designing Service Broker solution that meets the business requirements of ABC Inc.. You need to identify the services, queues, stored procedures, and data flow necessary to support your solution.

Identify the Service Broker services and queues needed to send data between the branch offices. Service Broker creates an identifier when it creates the service instance and then adds this identifier to subsequent messages that the client application identifies as a related conversation.

Service Broker sends messages to services; services store messages in queues. The service consumer can hold the message in a local queue if the service provider server is currently unavailable. Another solution to address ABC Inc’s problem is to have one dedicated queue for each branch office database, but this approach will only complicate the application. You would have to create a stored procedure that can distinguish between the types of messages and take the necessary action as appropriate. This approach will require extra processing and more complicated coding, both of which are unnecessary as the solution to the ABC Inc’s problem can be resolved by using one local queue.

Once data will be sent to the queue in the form of a message, Stored procedures will be required to update the customer and item information in each database, and keep the databases synchronized.

Step-3: Executing Service Broker Solution

Once solution has been created, you can execute the Script, once application starts running you can test it to check that it is working fine.

Here are over 400 differences which offer awesome features to increase your productivity during the development.

http://www.400plusdifferences.com/

Below mentioned is the 15 years old script, which was said by Microsoft officials.

Microsoft Announces Visual Basic at Windows World ’91 General-Purpose, High-Productivity Programming System for Microsoft Windows

ATLANTA — May 20, 1991 — Microsoft today announced Microsoft Visual Basic programming system at the Windows World ’91 industry trade show. Visual Basic is a graphical application development system for Microsoft Windows graphical environment version 3.0 that combines visual design tools with a powerful, general-purpose programming language and Windows .EXE compiler. It provides a simple solution to the complex task of creating real Windows-based software applications.

“We set out to create the fastest, easiest way to program for the Windows environment,” said Bill Gates, Microsoft founder and CEO. “My goal from the start was to make developing Windows applications as easy and natural as possible. We also wanted this tool to appeal to a broad spectrum of people interested in programming for Windows — from professional corporate programmers and consultants solving business problems to independent software vendors and casual programmers.”

Visual Basic programming system combines a rich, event-driven programming model with the world’s most widely used programming language in a tightly integrated package. General development for the Windows environment is faster than ever. The Visual Basic programming system provides visual user-interface design capabilities with powerful general-purpose programming tools, making it easy for any programmer to create compiled Windows .EXE files that can be freely distributed without run-time fees or royalties of any kind.

“This is the most important software product of the year, if not the decade,” said Steve Gibson, president of Gibson Research Inc. “It’s the ultimate intellectual tool. Thanks to Visual Basic, both casual and professional programmers can produce compelling and beautiful results. Now it’s easy to put together real Windows version 3.0 applications.”

“We needed to create an application that incorporated Microsoft Word for Windows and Microsoft Excel,” said Craig Ellis, senior programmer analyst, Reuters Information Systems. “Visual Basic was the tool to do this. It filled our needs, allowed us to develop a fast and effective application and cut our development time by more than half. It’s a fantastic product that allowed us to incorporate a family of Microsoft products into one application.”

The Visual Basic programming system can be used to develop any Windows-based application, including corporate business systems, tools and utilities, front ends to data (mainframe, server and local) or commercial Windows software products. It is also useful for integrating multiple Windows-based applications and for automating software testing through dynamic data exchange (DDE).

Visual Basic programming system provides visual design tools for creating the user interface components — windows and dialogs — of an application. A full set of Windows interface components (including command buttons, text fields, list boxes, pictures, drop-down menus and file system controls) are created visually, without writing any code. The forms engine for building the interface incorporates technology acquired from Cooper Software. A powerful, structured programming language is then used to add functionality to these interface components, responding to events that are automatically trapped by the system.

The Visual Basic language is a derivative of the Microsoft QuickBasicTM modern programming system, modified for the graphical environment and the event-driven programming language. It uses a threaded p-code incremental compiler and source-level debugging tools, including an interactive immediate window, in a tightly integrated system.

Extensibility

Support is provided for DDE, the mechanism for exchanging data with other Windows-based applications. The Visual Basic system also supports dynamic link libraries (DLLs), which allow the user to establish links with other Windows systems facilities and call the Windows API or routines written in other languages and compiled into DLLs. The control set itself can be extended by developers using C and the Windows SDK and the Microsoft Visual Basic Control Development Kit, available separately. This extensibility will provide the ability to fully integrate new user interface components into the graphical design and code development environment. Examples could include multimedia, pen controls and data access.

Printed documentation and online Help provide step-by-step instructions for writing programs. The online Help system provides context-sensitive reference information and sample code that can be copied and pasted into a Visual Basic program. An icon library of approximately 400 designs and an icon editor written in Visual Basic language are also included. “The built-in help is excellent,” said Lee Perryman, deputy director of Associated Press Broadcast Services in Washington, D.C. “The debugging features are superb, and the controls are rich and feature-packed. Because there is almost no learning curve for users familiar with the Basic language, Visual Basic makes Windows programming a snap.”

Visual Basic programming system for Windows will be available in June 1991 for a suggested retail price* of $199. German and French versions are expected to ship in August, with other foreign language versions to follow.

The Visual Basic programming system runs in either the standard or enhanced mode of Microsoft Windows graphical environment version 3.0 or higher. The system requirements include a personal computer using 80286 processor or higher; hard disk; mouse; CGA, EGA, VGA, 8514, HerculesR or compatible display; MS-DOSR operating system version 3.1 or later and one or more megabyte of memory.

Timely delivery of key information is crucial in many business solutions. Notification Services is a Microsoft® SQL Server based notification platform. This platform allows developers to quickly create notification service applications and allow users to use these applications to receive personalized information in a timely fashion. It enables automated notification to subscribers by using multiple communication protocols and devices.

Note: Notification Services 2.0 was a downloadable component of SQL Server 2000, and was released in 2002. In SQL Server 2005, Notification Services is integrated into SQL Server.

Notification Services can be used for a wide variety of applications. Even for a consumerapplication which can be used by a brokerage firm to send stock and fund prices based on customer-defined criteria for example let the customer know when his/her stock reaches a certain price.

A Notification Service application is a software layer that sits between an information source (stock server) and the intended recipient (clients of brokerage firm) of that information.Notification Service applications consist of three basic components: events, subscriptions and notification. In a notification service application, events are things happening that customers want to be informed about. Subscriptions are how the users of a Notification Service application tell the system about the type of events that they are interested in. for example, in the stock prices of brokerage firm, a customer might create a subscription to be notified when the price of Microsoft stock climbs over a $150 per share. A Notification is essentially a message that will be sent to the end user that contains the information regarding the event that the user subscribed to. Notifications can be delivered in various formats to a variety of different target devices.

Notification Services supports high-volume applications with thousands of incoming events per minute, millions of subscriptions matched, and thousands of notifications delivered per minute and so the databases server where data is stored and processed, has to be a reliable database server.

SQL Server 2005 Database Engine stores data and processes subscriptions very reliably, with a variety of high-availability technologies, including failover clustering, log shipping, and transactional replication. The database server can be configured to automatically handle hardware failures.

Meet my daughter Vamika (nick named- Pearly). She is busy and concentrating while developing a .NET 2.0 application which will be sending notifications to her mom that she needs to feed her and to me that I should reach home early as she wants to play.

Vamika is building this application by using Visual Studio 2005 and SQL Server 2005.

Once you start coding you will see it immediately. The new Visual Studio 2005 has over 400 new features that reduce tedious tasks and repetition so you can focus on creating great code.

With new web, windows controls, automated debugging, and a new Visual Basic that makes .NET and ASP .NET Framework development a breeze, it’s a whole new way to work.

So check out what’s new, play the game, and see why the difference in your day will be obvious.

Spot the Difference – Game Click here to Play

Microsoft has introduced a new Certification track for the lovers of .NET 2.0, Visual Studio 2005 and SQL Server 2005. These certifications will be available in 2006.

If you are the one; who can’t live without thinking of .NET; then visit the below given link to get all your questions answered.

Microsoft’s New Certifications for .NET 2.0, VS 2005 and SQL Server 2005

Microsoft’s Paul Flessner Senior Vice President Server Applications, talks about Release date of SQL Server 2005 along wuth Visual Studio 2005 and Biz Talk Server 2006.