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

sketchflow 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

C# Tools

Sunday, April 11, 2010

Saturday, April 10, 2010

WCF

There is a excellent 15 part web cast on MSDN on WCF.

http://www.dasblonde.net/2007/06/24/WCFWebcastSeries.aspx

If you are new to WCF this is the place to start.  Though the voice is not interesting to listen.  The content is really good.

Monday, April 5, 2010

I enjoyed reading it…

Some Important Laws Which Newton Forgot to State

LAW OF QUEUE: If you change queues, the one you have left will start to move faster than the one you are in now.

LAW OF TELEPHONE: When you dial a wrong number, you never get an engaged one.

LAW OF MECHANICAL REPAIR : After your hands become coated with grease, your nose will begin to itch.

LAW OF THE WORKSHOP: Any tool, when dropped, will roll to the least accessible corner.

LAW OF THE ALIBI: If you tell the boss you were late for work because you had a flat tire, the next morning you will have a flat tire.

BATH THEOREM: When the body is immersed in water, the telephone rings.

LAW OF ENCOUNTERS: The probability of meeting someone you know increases when you are with someone you don't want to be seen with.

LAW OF THE RESULT: When you try to prove to someone that a machine won't work, it will!

LAW OF BIOMECHANICS: The severity of the itch is inversely proportional to the reach.

THEATRE RULE: People with the seats at the furthest from the aisle arrive last.

LAW OF COFFEE: As soon as you sit down for a cup of hot coffee, your boss will ask you to do something which will last until the coffee is cold...

Teams PowerShell

 The PowerShell helps to get quick meta data around Teams. Install-Module -Name MicrosoftTeams Connect-MicrosoftTeams Get-TeamAllChannel...