Guru's info collection: April 2010

Thursday, April 29, 2010

Data Structure in C#

There is six part a MSDN article which discussed C# Data Structure in details.

An Extensive Examination of Data Structures Using C# 2.0

Part 1: An Introduction to Data Structures
Part 2: The Queue, Stack, and Hashtable
Part 3: Binary Trees and BSTs
Part 4: Building a Better Binary Search Tree
Part 5: From Trees to Graphs
Part 6: Efficiently Representing Sets

SSIS FAQ

The blog list the basic questions on SSIS

Control Flow:

Process Oriented
Doesn’t manage or pass data between components.
It functions as a task coordinator
In control flow tasks requires completion (Success., failure or completion)
Synchronous in nature, this means, task requires completion before moving to next task. If the tasks are not connected with each other but still they are synchronous in nature.
Tasks can be executed both parallel and serially
Three types of control flow elements in SSIS 2005
Containers - Provides structures in the packages
Tasks - Provides functionality in the packages
Precedence Constraints - Connects containers, executable and tasks into an ordered control flow.
We can control the sequence execution for tasks and also specify the conditions that tasks and containers run.
It is possible to include nested containers as SSIS Architecture supports nesting of the containers. Control flow can include multiple levels of nested containers.

Data Flow

Streaming in nature
Information oriented
Passes data between other components
Transformations work together to manage and process data. This means first set of data from the source may be in the final destination step while at the same time other set of data is still flowing. All the transformations are doing work at the same time.
Three types of Data Flow components
Sources - Extracts data from the various sources (Database, Text Files etc)
Transformations - Cleans, modify, merge and summarizes the data
Destination - Loads data into destinations like database, files or in memory datasets

How do you do

Error handling
Logging
Deployment & different strategies
Schedule SSIS packages to run on the fly?
How do you run stored procedure and get data in SSIS?
Debugging (Break Point, Data Viewer, SQL Profiler)
Configuration using XML, DB
Handle Transactions

Give a scenario: Want to insert a text file into database table, but during the upload want to change a column called as months - January, Feb, etc to a code, - 1,2,3.. .This code can be read from another database table called months. After the conversion of the data, upload the file. If there are any errors, write to error table. Then for all errors, read errors from database, create a file, and mail it to the supervisor. How would you accomplish this task in SSIS?

Tuesday, April 27, 2010

Do you have a minute?

Microsoft has collection of 60 second videos demonstrating its product and it is business value. Good to watch to get a quick idea on what is the technology all about.

Sketch Flow

When you want to sketch the Application Navigation, you can use SketchFlow, a new rapid prototyping tool from Microsoft which is available as part of Expression Studio 3. For a more structured look at SketchFlow please take a look at the SketchFlow starter kit. This series of videos walks you through the major features of SketchFlow and helps you understand how to use them.

Public Awareness Collection

Recently came to know the site which list links to

The Advertisng Standards Council of India
Cyberabad Police - Traffic
Consumer Court
Online RTI Application
Petitioning President

http://www.ccccore.co.in/

Will add more links to this post later.

Monday, April 26, 2010

Cloud Computing

Web Sites

· Cloud Services: Locate information and resources for the IT Pro, Developer, Business Leader, Technical Leader, Partner, and Government and Education at http://www.microsoft.com/cloud

· Windows Azure Platform: For whitepapers, videos, resources, evidence , pricing, and developer and partner information, see http://www.microsoft.com/windowsazure/ (external audience) //windowsazure (internal field portal)

· Microsoft Online Services: Find information on solutions, products, and how to buy at http://www.microsoft.com/online/default.mspx

· Microsoft Partner Network: Quickstart Online Services: Resources for partners to evaluate business and technical opportunities for BPOS and other Microsoft Online Services at http://www.quickstartonlineservices.com/Pages/Default.aspx.

· Gear Up Compete Special Edition

Case Studies

· Learn how others are using the Windows Azure platform to cut costs and increase agility at http://www.microsoft.com/windowsazure/evidence.

· See how Software + Services solutions combine the power of software with the benefits of the Internet at http://www.microsoft.com/success/

· 3M: Learn how 3M used the Windows Azure platform to deliver an innovative Web-based visual attention service to a global audience.

· Crisis Call Center: Learn how the crisis-hotline non-profit cut IT costs by $20,000 annually with Microsoft Online Services.

· RiskMetrics: Learn how the financial risk-analysis firm used Windows Azure to provide on- demand computing capacity for its analytics applications.

· Origin Digital: Learn how the video service provider reduced costs with an innovative transcoding application built with Windows Azure and SQL Azure.

Starter Kits & Code Samples

Starter Kits

Code Samples

Visual Studio 2008 Code Samples
ASP.NET and Silverlight - Projects created by members of the ASP.NET and Silverlight community, which you can use in your own web applications.
Language-Integrated Query (LINQ) - Start querying your data today by exploring the latest LINQ samples and resources.
Office Development - Sample applications and topics that give step-by-step instructions for performing common tasks.
Visual Studio Extensibility - Sample projects and code examples for extending Visual Studio.
Windows Forms - Task-based samples that help you learn about various features of Windows Forms.
Windows Mobile - Summaries and links for over 100 code samples installed by the Windows Mobile 6 Standard SDK and Windows Mobile 6 Professional SDK, including samples written using managed and native code.
Windows Communication Foundation (WCF) - A collection of samples that demonstrate using features of Windows Communication Foundation.
Windows Workflow Foundation (WF) - Includes a variety of code samples and starter kits available for Windows Workflow Foundation.
Windows Presentation Foundation (WPF) - Task-based samples that help you learn about various features of WPF
SQL Server Sample Database
SQL Server Community Samples