Perfil de ambatiProgramming Myself.. Amb...FotosBlogListasMás Herramientas Ayuda

Blog


30 septiembre

Topics covered in Bdotnet in brief

First Topic:

Visual Studio 2005 Team Edition for Database Professional

 

Reason behind Microsoft provided this plugin:

Usually in any project developers or db guys will work on sample data.

On when it comes to production db all the woes comes into picture.

And it is tedious at that point to change the sps and tables ,columns ,datatypes and the null values.

 

So db changes should be tracked like code in VSS (here it is VS Team Suite) using Team Foundation Server.

Creating tables and generating with some sample valid data. ( u can put some regular expression on the data, max and min values ,etc etc conditions)

All the views ,triggers ,etc etc can be done here.

It will help in Database refactoring

We can unit test cases also.

After doing all the changes we can checkin the code.

All the object (tables,triggers, etc) will be generated as sql files

Finally DB person will review and run that sql file in production server.

It will help in Build/Deploy

 

Summary:

Integrate db professional job into vss and tracking his changes to improve overall performance.

This is a plugin in visual studio.Afer installing this you will get 4 templates in vs devenv

  Sqlserver 2000,Sqlserver 2000 wizard, Sqlserver 2005,Sqlserver 2005 wizard

Finally the output is a sql file which contains the script.

 Note: It wont do any changes in the developer code.

 

Refer: http://msdn.microsoft.com/msdnmag/issues/07/02/TeamEdition/default.aspx

 

Second Topic:

Creating Simple Custom Activities in WF

 

Every application contains some sort of workflow.Earlier we are writing our custom logic to handle long running applications.Now Microsoft found this gap and came up with Workflows.

 

First point to understand workflows work in Asynchronous manner.

And it is nonpremptive (ie nobody can interrupt. When it completes then only others can take control).

 

Y we want custom activities?

If we want domain specific like graph like workflows (In WWF they provided sequential and State machine).

 

WF follows episodic execution means they are long standing processes.Thats why we cant block the other resources.We have to persist the state in a persisting store ( it may be db,filesystem or ur custom one)

 

The entire transaction will be performed in one thread.

There is no multithreading here.

 

 

Life Cycle:

                                       Method used

Initialize                             CreateWorkflow

Execute                              Start

Uninitialize

 

In Initialize state if you overrrided createworkflow method for a custom activity then it is called synchronously..

 

We can create  a.Custom properties

                           1.Dependent  (getting value for an activity from property of another activity)

                           2. Independent

            b. Custom Events

            c. Custom Methods

 

Use queueing services to understand the asynchronous behavior better.

 

Cancel State: It can done by parent activity and at that time child activity should be in execution state

Faulting state: Exception handling( unhandled errors) should be performed here.

 

Compensatable Activity:

When we have to think about compensation in workflows?

Parent is success in its work but down the line its subsequent child activities may fail.Then think for compensation.

Compensate method is there and it will be for only successful closed activities.

 

How to configure the UI of workflows?

We can customize the UI of workflow as per our requirements.

We can add an image etc etc.

Extend Activity Component Model

Note: Write separate classes for extending designer, validation, serialization, code generator (use codedom), toolbox items.

 

Summary:

 

First understand the workflow life cycle (they differ logically from asp.net life cycle)  

U can customize the look & feel of workflow UIs through Activity Component Model

 

We can expect creating composite activity in the next session.

 

Speaker id: meena@symindia.com

 

RoadMap: Microsoft will extend this workflow into biztalk.

Now if u want internet based applications go for biztalk and if it is intranet then WWF.

 

Preffered book is Essential Workflow foundation by Dharma Sukla. This is meant for advanced  concepts in workflows.People should have basic knowledge in the WWF.

Result of Constructive Feedback in Bdotnet session

Hi All

 

UG meeting on 29th Sept 2007 4PM

 

Session1: Overview of Visual Studio Team Edition for Database Professionals
Speaker: Chaitra N,Intel (Microsoft MVP).

 

Session2 : How to create custom activities in WF (Workflow Foundation).
Speaker: Meena K, SymIndia (Microsoft MVP)

 

After a long time I went to a really useful BDotnet session

 

In one of the  BDotnet forum messages I gave the reasons for less  participation of audience.

It worked very fine.It made the BDotnet managers and the speakers awake.

They conducted a poll regarding the topics that audience requires.

Last week it was a useful  session( I missed this one). And this week too.

I felt very happy about my constructive feedback helped the audience.

 

I learned this skill from my PM 'Prakash J'

People will take the critics in positive manner if it is constructive feedback.

 

28 septiembre

Help differs from ladies to gents

If a girl (lady) posts any query in any of the forums then the response will be given spontaneously and it will be a massive response.Even nonactive members also responds.
It wont happen when a boy(gent) posts a query.
Why is it so?
Dont trust ladies that much...
27 septiembre

Conditional Attribute in C#

 
If we include Unit tests in our code and you dont want them anyway in production environment (means release ) then use conditional attributes
 
Unit tests makes assemblies larger and we dont them in production.
 
Simplest way provided in vs is this.
 
We define conditional attributes in debug (Project properties -> debug) and we wont define in release mode (select the same dropdown).

How to debug stored procedures in Visual Studio .NET?

Yesterday my PM asked about how to debug sps.

I know the traditional print stmt in sp and sqlprofiler .

Then Visual Studio.Net also supports debugging.

Learn from these links:

How to debug stored procedures in Visual Studio .NET?

http://support.microsoft.com/kb/316549

http://msdn2.microsoft.com/en-us/library/yet1b7by(VS.71).aspx

http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

Inspirational Quotes

Today just now in the morning I got a mail from http://himabinduvejella.blogspot.com/
 
She gave this link.
 
 
 
If you have knowledge, let others light their candles with it."
http://www.karlblog.com/blog/labels/inspiration.html
 
 

Steps to Happiness

Everybody Knows,
You can't be all things to all people.
You can't do all things at once.
You can't do all things equally well.
You can't do all things better than everyone else.
Your humanity is showing just like everyone else's.



So,
You have to find out who you are, and be that.
You have to decide what comes first, and do that.
You have to discover your strengths, and use them.
You have to learn not to compete with others, because no one else is in the contest of "being you".



Then,
You will have learned to accept your own uniqueness.
You will have learned to set priorities and make decisions.
You will have learned to live with your limitations.
You will have learned to give yourself the respect that is due.
And you'll be a most vital mortal.



Believe,
That you are a wonderful, unique person.
That you are a once-in all history event.
That it's more than a right, it's your duty, to be who you are.
That life is not a problem to solve, but a gift to cherish.
And you'll be able to stay one up on what used to get you down

 

A ship is safe in harbor... But that's not what ships were built for"
-- William Shed

"There is nothing either good or bad... But thinking makes it so"
-- William Shakespeare

"All that we are is the result of what we have thought. The mind is everything. What we think, we become"
--Buddha

"Life is not measured by its length... But by it's depth"
-- Anonymous
 
26 septiembre

Why gents bends towards ladies?

This is related to the software field.
 
In my experience in this field I found some tough and intelligent guys in the management.
 
But still they will show favour (weekness) in case of ladies.
 
Reasons are: 

Lessons learned from "Chak De India" movie

If we worked as a team there is nothing impossible in this world. 

When Indian will become superpower?

How to solve the problems of Indian society
People should be self disciplined.
They must feel the responsibility.

11 Visual Studio 2005 IDE Tips and Tricks to Make You a More Productive Developer

 

http://www.chinhdo.com/chinh/blog/20070920/top-11-visual-studio-2005-ide-tips-and-tricks-to-make-you-a-more-productive-developer/

 

especially the below:

 

Make New Shortcuts

Use Code Snippets

Stop Conditionally (Conditional Breakpoints)

Go Directly to Any File with the Find Combo Box 

25 septiembre

India won the final of T20 World Cup

India won the world cup yesterday in T20 Cricket World Cup.
What a marvellous victory!!!
Even my neighbour (she is at age 55) watched the cricket match for the first time in his life.
She also enjoyed very much.May be she will become one of the big fan of Indian Cricket Team.
Tendulkar commented that we always considered seniors and juniors in the team.
But I think they should be some change in the Indian team.We are giving more importance to Seniors.
Just make a young team.
But its a lesson to the Indian Team as they exited from the World Cup( in early 2007) in the first round itself.
At that time lot of expectations are there.
Now with no expectations they went and got the cup.
They have to play at any place at any moment to their expectations.
 
For the first time in Bangalore after 1.8 yrs I found no traffic even at the peak time ie 8:30 PM
All roads are traffic free.
No vehicles and all shops are closed .
Crackers burned.
22 septiembre

Visual Studio 2008 Code Metrics

The new Visual Studio 2008 has Code Metrics feature available in Visual Studio Team Developer and Team Suite. This new feature allows users to generate code metrics for projects and solutions and displays the results in the Code Metrics Results tool window. It currently calculates five different metrics; Maintainability Index, Cyclomatic Complexity, Depth of Inheritance, Class Coupling, and Lines of Code.

 

Tirupati Donation

 
My sister has donated her 6 months salary for AnnaPrasadam scheme in Tirupati Venkateswara temple on 8th Sep 2007(Saturday).
 
We went to Tirupati on Friday and reach Tirupati on Saturday.
 
She donated 1 lakh for a scheme (serving the devotees with food) who visit Tirupati temple.
 
It will actually serve the poor people also.
 
May be that one lakh is very precious for my family at this moment.
 
But by seeing the poor and my sister (younger) beliefs we finally decided to donate money.
 
I like my sister very much becoz of this kind behaviour towards poor.
 
God please do all the favours for this world including my sister too.
20 septiembre

List of Stock Exchanges

 
I am very much interested in Business News.Daily I use to read also.
Today I read about the Sensex touching 16k mark.
I want to know about the different stock exchanges and the result is below.
 
 
 
List of stock exchanges

This is a list of stock exchanges. Those futures exchanges that also offer trading in securities besides trading in futures contracts are listed both here and the List of futures exchanges.



Ten Largest Stock Exchanges by Market Capitalization (in trillions of US dollars)

  1. New York Stock Exchange (merged with Euronext) - $15.87
  2. Tokyo Stock Exchange - $4.74
  3. NASDAQ - $4.01
  4. London Stock Exchange - $3.94
  5. Euronext (merged with NYSE) - $3.86
  6. Toronto Stock Exchange - $1.92
  7. Hong Kong Stock Exchange - $1.87
  8. Frankfurt Stock Exchange (Deutsche Börse) - $1.78
  9. Shanghai Stock Exchange - $1.70
  10. Madrid Stock Exchange (BME Spanish Exchanges) - $1.26


Other Large Regional Stock Exchanges by Market Capitalization (in trillions of US dollars) 11. SWX Swiss Exchange - $1.26 12. Australian Stock Exchange - $1.20 13. Milan Stock Exchange (Borsa Italiana) - $1.07 14. Moscow Interbank Currency Exchange - $0.86 (January 2007) 15. Korea Exchange - $0.84 16. Bombay Stock Exchange - $0.82 17. Bovespa - $0.81 18. Johannesburg Securities Exchange - $0.79 19. National Stock Exchange of India - $0.77
Sources: World Federation of Exchanges (March 2007); MICEX Group (February 2007)

 

Happy News for me

From the last one and  half year I am suffering from severe headache.
Met so many doctors and taken so many medicines.
One doctor told me to take brain scan.Told me high bp.
Finally I was vexed with English medicines.
Went to Homeopathy doctor in Jayanagar.
Now I am cured.
Doctor told me to stop using medicines.
I felt very happy.
I am thankful to my team and the cab driver Jalal for supporting me in recovering my health.
 
 

Project Management Methodologies:

 

http://www.objectmentor.com/omSolutions/agile_xp_differences.html

 

XP is a set of practices that conform to the values and principles of Agile.

XP is a discrete method, whereas Agile is a classification. There are many Agile methods(SCRUM, DSDM, Crystal, FDD, etc.), XP is just one of them.

None of the other Agile methods are as well defined, or as broad in scope as XP. Scrum, for example, is roughly equivalent to XP’s Planning game practice, with elements of Whole Team. While there are differences in the details, it is fair to say that Scrum is a subset of XP. Indeed, many Scrum teams augment their process by adding in many of the XP practices such as Acceptance Testing, Pair Programming, Continuous Integration, and especially Test Driven Development.

 

XP was based on a more prescriptive set of practices (Test First, Planning Games, Paired Programming etc) whereas Agile Development was more a philosophy (based on focussing on the people issues of software development and doing things that worked)

 

Lean Development

http://www.projectperfect.com.au/info_lean_development.php

 

Project Management Methodologies:

Adaptive Project Framework

·         Agile Software Development

·         Crystal Methods (CMM)

·         His focus is on the people, interaction, community, skills, talents, and communications with the belief that these are what have the first-order effect on performance

·         Dynamic Systems Development Model (DSDM)

·         DSDM favors the philosophy that nothing is built perfectly the first time and looks to software development as an exploratory endeavor.

·         Extreme Programming (XP)

·         The main goal of XP is to lower the cost of change in software requirements

·         Feature Driven Development (FDD)

·         A system for building systems is necessary in order to scale to larger projects

·         Information Technology Infrastructure Library (ITIL)

·         The Information Technology Infrastructure Library (ITIL) is a collection of best practices that aim to improve and then maintain a certain level of computing services quality in the information technology sector

·         Joint Application Development (JAD)

·         The Joint Application Development (JAD) methodology aims to involve the client in the design and development of an application.

·         Lean Development (LD)

·         Lean Development focuses on the creation of change-tolerant software.

·         PRINCE2

·         PRINCE2 is project management methodology that takes a process-based approach

·         Rapid Application Development (RAD)

·         Rational Unified Process (RUP)

·         Scrum

·         Spiral

·         Systems Development Life Cycle (SDLC)

·         TenStep Project Management Process

·         Waterfall (a.k.a. Traditional)

 

Singularity new Microsoft OS (based on managed code ie c#)

Singularity is a research project in Microsoft Research that started with the question: what

would a software platform look like if it was designed from scratch with the primary goal of

answer this question by building on advances in programming languages and programming tools

to develop and build a new system architecture and operating system (named Singularity), with

the aim of producing a more robust and dependable software platform. Although dependability is

 

Singularity is a new operating system being developed as a basis for more dependable

system and application software [28]. Singularity exploits advances in programming languages

and tools to create an environment in which software is more likely to be built correctly, program

behavior is easier to verify, and run-time failures can be contained. 

Obfuscator

Obfuscators

Obfuscators work by transforming a .NET assembly into an equivalent .NET assembly that is more difficult to understand when disassembled or decompiled. Some obfuscators use ILDASM to disassmble the assembly and operate on the disassembled MSIL, and then use ILASM to reassemble the result. Others operate directly on the assembly without any ILDASM/ILASM round trip. Obfuscators apply a variety of different techniques to make the disassembled source code more difficult to understand. Obfuscation in Visual Studio .NET

http://www.howtoselectguides.com/dotnet/obfuscators/#section-sub-cats

If your obfuscation needs are minimal, and you're a Visual Studio .NET user you may not need to purchase a product at all. That's because Visual Studio .NET includes a copy of the Community Edition of Dotfuscator for .NET, an obfuscator from PreEmptive Solutions. This obfuscator is targeted at students and freeware authors, and supports basic entity renaming and removal of unused metadata, but no advanced obfuscation features. You'll find a review of the Professional Edition of Dotfuscator later in this Guide, and PreEmptive has a comparison chart online showing what's in their various editions.

1.      Download from Dotfuscator for .NET  at : http://www.preemptive.com/products/dotfuscator/index.html

2.      Downloading Freeware .NET Obfuscator Skater Light 1.00.0  at http://pcwin.com/Software_Development/Freeware__NET_Obfuscator_Skater_Light/download.htm