To become an engineer was never my dream and that too an electronics engineer was all a chance. I was adventurous since my childhood and I always considered myself as a tough guy. I always wanted to join Indian Army not because it would be the best way to serve the nation but also I could serve my inner soul. I appeared twice for the NDA exams but couldn’t make it and had to go by my dad’s wish to join an engineering college.
And as there was no self will, it got reflected into the first semester results. Nikhil, the guy who topped the charts was a son of an Army officer. I always tried to make friendship with him but myself being a defaulter and Nikhil little arrogant, it took some time. As some time passed I told him about my past dreams of joining Army. He jeered “How people who cannot even clear their papers can have so high dreams”. I was hurt and that even to the core. I didn’t say a word but moved from there.
Again by chance I got a point to prove myself. From second year of engineering we both were in different branches he in civil and me in Electronics. So there was no direct competition. Moreover I couldn’t ever overtake Nikhil as far as academics were concerned. Also in sports, Nikhil was always one step ahead.
But I never lost hope and kept myself going. In third year of engineering Indian Army came to college for placements under university entry scheme. Both of us appeared for it and got short listed for SSB. The date and venue was to be sent to us in due course by mail. I had to leave for my home town due to some critical problem in my house. I requested Nikhil to call me up soon he gets the SSB dates. On Sunday when I was returning for the college, I received the call from Nikhil. He said that he has reached Bangalore for the SSB which will start today. I got wrenched and couldn’t speak after that. All the hopes and desire to join Indian army went into trash.
In a week time, even Nikhil came back with empty hands. Days passed on and next year again Indian army came for the placements. Nikhil again appeared for it and this time he made it. I was too placed into DRDO. College got over and we moved on in our respective lives. In six months time my college mates decided for a get together. After such a long time we saw each other. I was feeling bit inferior since every one was giving all attention to him. At last the function got ever and I moved to the Railway station with my luggage. I saw him coming from the front smiling at me. Two Jawans were holding his luggage. For the first time I realized the royalty of an Army Officer. We departed for our respective destinations but the pain was there in my heart.
In DRDO I was involved in making an apparatus capable of sensing activities even happening at 5 Km range. And in the mean time War broke up with neighboring country. I was asked to visit the war place and demonstrate this to our army men. I was more than delighted to get this opportunity. When I reached there I found Nikhil in the troops who were to be trained. My demonstration gave them faith that they can win. In the battle field we showed lot of grit and resilience and finally we won. But we lost several of our Jawans including Nikhil. I saw 4 Jawans carrying his dead body. My eyes filled with the tears and my heart with respect for him. For the first time I realized the glory of an Army personnel. I felt proud to call myself his friend.
When I returned back, I had to fill the details of the work I carried out. I got stuck with a column “source of inspiration in the Warfield”. I wrote “Late Capt Nikhil”.
Friday, July 31, 2009
Wednesday, July 29, 2009
SSIS Funda’s ……………………
Objective : Extraction of data, Transformation and insertion.
Control Flow: Roughly we can call it as a work flow.
Data Flows are the modules which does a series of operation to achieve a desired result.
SSIS 2005 provides three different types of control flow elements
1. Containers: Provide structures in packages.
2. Tasks: provides functionality.
3. Precedence constraint: it connects the executables, containers and tasks into an ordered flow.
First of all the package control flow must include a data flow task then only we can add a data flow to a package. For each Data flow task in package a separate instance of the data flow engine is invoked.
ERROR Handling in SSIS:
Typically three sort of errors can happen in SSIS viz. Data conversion errors, Expression evaluation errors or Look up Errors.
In the transformation editor, we can click configure Error Output to get the configure error o/p wizard.
There are three options:
1) Ignore Failure
2) Redirect Row
3) Fail Component
Other than these we have event handlers where we can execute some task or run scripts or do anything we want in case of error occurred or after execution of some block.
LOGGING in SSIS:
We can write log entries to text files, SQL Server profiler, Windows event log or xml files. Logs are associated with the packages and are configured at the package level. Each task or container in a package can log information into any package log. To enable logging in a package:
1. Open the integration services in BIDS.
2. On the SSIS menu click logging.
3. Select a log provider in the provider type list and then click ADD.
Deployment of SSIS packages:
SSIS supports the deployment of packages through the use of the package configurations and the ability to easily deploy packages using the package deployment utility.
1. Build the integration services project to create a package deployment utility.
2. Now run the package installer wizard to install the package.
VARIABLES: variables store values that a SSIS package and its contains, tasks and event handlers can use at run time.
SSIS provides a checkpoint facility which allows a package to restart at the point of failure.
SSIS connection managers:
1. OLE DB Connection.
2. Flat file connection.
3. ADO.Net connection
4. Analysis service connection.
Difference between DTS and SSIS:
1. No Deployment wizard in DTS.
2. Limited set of transformations in DTS.
3. No BI functionality in DTS.
4. Dynamic properties + ActiveX scripts in DTS, Configuration + Property Expression in SSIS
5. Message Boxes in active scripts, Message Boxes in script tasks.
Merge transformation can accept only two inputs where as Union ALL can take more than two inputs.
Data has to be sorted before merge transformation where as UNION ALL doesn’t have any such condition.
Control Flow: Roughly we can call it as a work flow.
Data Flows are the modules which does a series of operation to achieve a desired result.
SSIS 2005 provides three different types of control flow elements
1. Containers: Provide structures in packages.
2. Tasks: provides functionality.
3. Precedence constraint: it connects the executables, containers and tasks into an ordered flow.
First of all the package control flow must include a data flow task then only we can add a data flow to a package. For each Data flow task in package a separate instance of the data flow engine is invoked.
ERROR Handling in SSIS:
Typically three sort of errors can happen in SSIS viz. Data conversion errors, Expression evaluation errors or Look up Errors.
In the transformation editor, we can click configure Error Output to get the configure error o/p wizard.
There are three options:
1) Ignore Failure
2) Redirect Row
3) Fail Component
Other than these we have event handlers where we can execute some task or run scripts or do anything we want in case of error occurred or after execution of some block.
LOGGING in SSIS:
We can write log entries to text files, SQL Server profiler, Windows event log or xml files. Logs are associated with the packages and are configured at the package level. Each task or container in a package can log information into any package log. To enable logging in a package:
1. Open the integration services in BIDS.
2. On the SSIS menu click logging.
3. Select a log provider in the provider type list and then click ADD.
Deployment of SSIS packages:
SSIS supports the deployment of packages through the use of the package configurations and the ability to easily deploy packages using the package deployment utility.
1. Build the integration services project to create a package deployment utility.
2. Now run the package installer wizard to install the package.
VARIABLES: variables store values that a SSIS package and its contains, tasks and event handlers can use at run time.
SSIS provides a checkpoint facility which allows a package to restart at the point of failure.
SSIS connection managers:
1. OLE DB Connection.
2. Flat file connection.
3. ADO.Net connection
4. Analysis service connection.
Difference between DTS and SSIS:
1. No Deployment wizard in DTS.
2. Limited set of transformations in DTS.
3. No BI functionality in DTS.
4. Dynamic properties + ActiveX scripts in DTS, Configuration + Property Expression in SSIS
5. Message Boxes in active scripts, Message Boxes in script tasks.
Merge transformation can accept only two inputs where as Union ALL can take more than two inputs.
Data has to be sorted before merge transformation where as UNION ALL doesn’t have any such condition.
Monday, July 27, 2009
SQL Server Fundas…………….by Vikash kumar
1. Database Management System: Store --> Manage --> Retrieve (to persist information)
2. Difference between DBMS and RDBMS: RDBMS = DBMS + Referential integrity.
3. Difference between SQl Server 2000 and SQL Server 2005:
a. User defined functions or triggers can be written using any .Net language. (TSQL in 2000)
b. Reporting Services.
c. New data types.
d. Stored Procedure invocation is enabled using the SOAP protocol.
e. Data partitioning feature
f. SQL Server 2000 can have maximum of 16 instances where as SQL 2005 can have up to 50 instances.
g. SQL query analyzer has been integrated.
4. Entity Diagrams shows the relationship between the tables.
5. SQL Server stores data in
a. .MDF file (physical database file where data is finally stored.)
b. .LDF file (Log files are actually data which is recorded from the last time data was committed in DB)
6. ON DELETE Restrict: Should not allow to drop tables if dependency is there. ON DELETE Cascade: should delete the dependency first and then delete the table.
7. Types of Joins:
a. Inner Join: only matches present in both tables. Most commonly used.
b. Left outer join: All records of Left table
c. Right outer Join: All records of right table
d. Cross Join : Cartesian product
e. Self join : Join between two instances of same table.
8. Difference between DELETE and TRUNCATE
a. Truncate is faster.
b. Truncate table cannot trigger.
c. DELETE table can have criteria while TRUNCATE cannot.
d. DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table so TRUNCATE table is faster as compared to delete table.
9. Difference between UNION and UNION ALL
a. Union gives distinct records from both the tables but UNION ALL gives all the records.
10. Significance of SET ROW COUNT is that it limits the number of rows returned.
11. Exception Handling in SQL:
a. Use TRY Catch block.
b. Can designate ERROR_NUMBER, ERROR_Severity, ERROR_State, ERROR_MESSAGE, SET ERROR.
c. The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement custom error messages in your applications.
12. Types of Triggers:
a. Instead of
b. After trigger
Differences between the two:
INSTEAD OF triggers gets executed automatically before the Primary Key and the Foreign Key constraints are checked, whereas the traditional AFTER triggers gets executed after these constraints are checked. Unlike AFTER triggers, INSTEAD OF triggers can be created on views.
13. To define the sequence of the triggers on a table if more than one trigger exist on that table then use the system stored procedure sp_settriggerorder.
14. Difference between Data Set and Data Reader:
a. Data reader provides forward only and ready only access to data while dataset can hold more than a table.
b. Dataset persists the content but Data reader not.
15. Methods provided by the dataset for XML:
a. Read XML
b. Get XML
c. Write XML
16. For XML clause in SQL server returns data in XML rather than simple rows and columns.
17. To generate schema of a table: Select * from mytable For XML AUTO, XMLSCHEMA
18. OPEN XML is vice versa of FOR XML AUTO. When XML is passed it returns rows and column.
19. XMLA: XML for analysis is fundamentally based on web services and SOAP. MS SQL 2005 analysis services use XMLA to handle all client application communication for analysis services. XMLA is a SOAP based XML protocol designed specifically for universal data access to any standard multi dimensional data source residing on the web.
20. Normalization: Suppose there are few tables having relationships between them. So while designing these tables we need to follow some set of rules to connect these tables. These set of rules are called normalization.
Advantages of Normalization:
a. Avoid redundancy i.e. repetitive entries.
b. Reducing required storage space.
c. Preventing the need to restructure existing tables to accommodate new data.
d. Increased speed and flexibility of queries, sorts, and summaries.
First Normal Form For a table to be in first normal form, data must be broken up into the smallest units possible. In addition to breaking data up into the smallest meaningful values, tables in first normal form should not contain repetitions groups of fields. In a table if there are two columns city1,city2 and customer name. To make it in first normal form we should break the Customer name into two columns First Name and Last Name. Moreover the repetitive columns like city1, city2 should be merged as City.
Second Normal form The second normal form states that each field in a multiple field primary key table must be directly related to the entire primary key. So If we will shift City to a different master table then our database is said to be in Second Normal Form.
Third normal form A non-key field should not depend on other Non-key field. The field "Total" is dependent on "Unit price" and "qty". Suppose our table contains three fields Unit price, Qty and Total. Total can be calculated by multiplication of Unit price * Qty. So we can remove the Total field from the table. This will bring our table in Third normal form.
21. Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance. The sacrifice to performance is that you increase redundancy in database.
22. Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quickly. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way in which records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
23. How can we increase SQL performance
Following are tips which will increase your SQl performance :-
a. Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-only table, then the number of indexes may be increased.
b. Keep your indexes as narrow as possible. This reduces the size of the index and reduces the number of reads required to read the index.
c. Try to create indexes on columns that have integer values rather than character values.
d. If you create a composite (multi-column) index, the order of the columns in the key are very important. Try to order the columns in the key as to enhance selectivity, with the most selective columns to the left most of the key.
e. If you want to join several tables, try to create surrogate integer keys for this purpose and create indexes on their columns.
f. Create surrogate integer primary key (identity for example) if your table will not have many insert operations.
g. Clustered indexes are more preferable than nonclustered, if you need to select by a range of values or you need to sort results set with GROUP BY or ORDER BY.
h. If your application will be performing the same query over and over on the same table, consider creating a covering index on the table.
i. You can use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables" trace to determine which tables in your database may need indexes. This trace will show which tables are being scanned by queries instead of using an index.
24. Following are the problems that occur if we do not implement locking properly in SQL SERVER.
a. Lost Updates: This happens due to most likely to occur with the READ UNCOMMITTED isolation level. Due to this we lose the first transaction if two transaction happens over the same data simultaneously.
b. Non-Repeatable Read: Non-repeatable reads occur if a transaction is able to read the same row multiple times and gets a different value each time.
c. Dirty Reads: Dirty reads are a special case of non-repeatable read. This happens if we run a report while transactions are modifying the data that we're reporting on.
d. Phantom Reads: Phantom reads occur due to a transaction being able to read a row on the first read, but not being able to modify the same row due to another transaction deleting rows from the same table.
25. Transaction Isolation level decides how is one process isolated from other process. Using transaction levels we can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER :
a. READ COMMITTED: The shared lock is held for the duration of the transaction, meaning that no other transactions can change the data at the same time.
b. READ UNCOMMITTED: No shared locks and no exclusive locks are honored. This is the least restrictive isolation level resulting in the best concurrency but the least data integrity.
c. REPEATABLE READ: This setting disallows dirty and non-repeatable reads. However, even though the locks are held on read data, new rows can still be inserted in the table, and will subsequently be interpreted by the transaction.
d. SERIALIZABLE: This is the most restrictive setting holding shared locks on the range of data. This setting does not allow the insertion of new rows in the range that is locked; therefore, no phantoms are allowed. Following is the syntax for setting transaction level in SQL SERVER. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
26. Depending on the transaction level six types of lock can be acquired on data :
a. Intent: Intent locks come in three flavors: intent shared (IS), intent exclusive (IX), and shared with intent exclusive (SIX). IS locks indicate that the transaction will read some (but not all) resources in the table or page by placing shared locks. IX locks indicate that the transaction will modify some (but not all) resources in the table or page by placing exclusive locks. SIX locks indicates that the transaction will read all resources, and modify some(but not all) of them. This will be accomplished by placing the shared locks on the resources read and exclusive locks on the rows modified. Only one SIX lock is allowed per resource at one time; therefore, SIX locks prevent other connections from modifying any data in the resource (page or table), although they do allow reading the data in the same resource.
b. Shared locks (S) allow transactions to read data with SELECT statements. Other connections are allowed to read the data at the same time; however, no transactions are allowed to modify data until the shared locks are released.
c. Update locks (U) are acquired just prior to modifying the data. If a transaction modifies a row, then the update lock is escalated to an exclusive lock; otherwise, it is converted to a shared lock. Only one transaction can acquire update locks to a resource at one time. Using update locks prevents multiple connections from having a shared lock that want to eventually modify a resource using an exclusive lock. Shared locks are compatible with other shared locks, but are not compatible with Update locks.
d. Exclusive locks (X) completely lock the resource from any type of access including reads. They are issued when data is being modified through INSERT, UPDATE and DELETE statements.
e. Schema modification locks (Sch-M) are acquired when data definition language statements, such as CREATE TABLE, CREATE INDEX, ALTER TABLE, and so on are being executed. Schema stability locks (Sch-S) are acquired when store procedures are being compiled.
f. Bulk update locks (BU) are used when performing a bulk-copy of data into a table with TABLOCK hint. These locks improve performance while bulk copying data into a table; however, they reduce concurrency by effectively disabling any other connections to read or modify data in the table.
27. Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Server escalates the many fine-grain locks to fewer coarse-grain locks.
28. Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber.
a. Publisher: Database server that makes data available for replication is called as Publisher.
b. Subscriber: Database Servers that get data from the publishers is called as Subscribers.
There are three types of replication supported by SQL SERVER.
a. Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The only disadvantage of this type of replication is that all data has to be copied each time the table is refreshed.
b. Transactional Replication In transactional replication data is copied first time as in snapshot replication, but later only the transactions are synchronized rather than replicating the whole database. We can either specify to run continuously or on periodic basis.
c. Merge Replication. Merge replication combines data from multiple sources into a single central database. Again as usual the initial load is like snapshot but later it allows change of data both on subscriber and publisher, later when they come on-line it detects and combines them and updates accordingly.
29. User defined Functions:
User defined functions are TSQL routines used to encapsulate the programming logic.
Types of UDF:
1. Scalar: Returns a single value of a scalar data type. Cannot return text, timestamp or image.
Things we cannot do:
a. Insert/Update/Delete
b. Execute SP’s
c. Error Handling
d. Print
2. Inline: Return tables equivalent to views with parameters.
Insert\update \Delete are possible.
3. Multi statement: Tables can be returned.
Following are some major differences between a stored procedure and user defined functions:
a. Stored procedures are called independently, using the EXEC command, while functions need to be called from within another SQL statement.
b. Stored procedure allow you to enhance application security by granting users and applications permission to use stored procedures, rather than permission to access the underlying tables. Stored procedures provide the ability to restrict user actions at a much more granular level than standard SQL Server permissions.
c. UDF cannot be used in XML FOR clause but SP’s can be used.
d. Functions must always return a value (either a scalar value or a table). Stored procedures may return a scalar value, a table value or nothing at all.
e. If there is an error in UDF its stops executing. But in SP’s it just ignores the error and moves to the next statement.
f. UDF cannot make permanent changes to server environments while SP’s can change some of the server environment.
g. UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be.
30. Performance Tuning SQL Server Cursors:
If possible, we should avoid using SQL Server cursors. They generally use a lot of SQL Server resources and reduce the performance and scalability of our applications. If we need to perform row-by-row operations here are some alternatives:
• Use WHILE LOOPS
• Use temp tables
• Use derived tables
• Use correlated sub-queries
• Use the CASE statement
• Perform multiple queries
1. If we have to use a cursor, we should try to reduce the number of records to process by using temp table. The lower the number of records to process, the faster the cursor will finish.
2. If the number of rows you need to return from a query is small, and we need to perform row-by-row operations on them, don't use a server-side cursor. Instead, consider returning the entire rowset to the client and have the client perform the necessary action on each row, then return any updated rows to the server
3. If we have no choice but to use a server-side cursor in our application, we should try to use a FORWARD-ONLY or FAST-FORWARD, READ-ONLY cursor. Also we should try to locate the SQL Server tempdb database on its own physical device for best performance. This is because cursors use the tempdb for temporary storage of cursor data. The faster your disk array running tempdb, the faster our cursor will be.
4. If we need to perform a JOIN as part of our cursor, keyset and static cursors are generally faster than dynamic cursors, and should be used when possible.
31. To get all the row values concatenated.
Declare @colors varchar(250)
Select @colors = COALESCE(@colors + '/','') + CompanyName from dbo.Company
print @colors
2. Difference between DBMS and RDBMS: RDBMS = DBMS + Referential integrity.
3. Difference between SQl Server 2000 and SQL Server 2005:
a. User defined functions or triggers can be written using any .Net language. (TSQL in 2000)
b. Reporting Services.
c. New data types.
d. Stored Procedure invocation is enabled using the SOAP protocol.
e. Data partitioning feature
f. SQL Server 2000 can have maximum of 16 instances where as SQL 2005 can have up to 50 instances.
g. SQL query analyzer has been integrated.
4. Entity Diagrams shows the relationship between the tables.
5. SQL Server stores data in
a. .MDF file (physical database file where data is finally stored.)
b. .LDF file (Log files are actually data which is recorded from the last time data was committed in DB)
6. ON DELETE Restrict: Should not allow to drop tables if dependency is there. ON DELETE Cascade: should delete the dependency first and then delete the table.
7. Types of Joins:
a. Inner Join: only matches present in both tables. Most commonly used.
b. Left outer join: All records of Left table
c. Right outer Join: All records of right table
d. Cross Join : Cartesian product
e. Self join : Join between two instances of same table.
8. Difference between DELETE and TRUNCATE
a. Truncate is faster.
b. Truncate table cannot trigger.
c. DELETE table can have criteria while TRUNCATE cannot.
d. DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table so TRUNCATE table is faster as compared to delete table.
9. Difference between UNION and UNION ALL
a. Union gives distinct records from both the tables but UNION ALL gives all the records.
10. Significance of SET ROW COUNT is that it limits the number of rows returned.
11. Exception Handling in SQL:
a. Use TRY Catch block.
b. Can designate ERROR_NUMBER, ERROR_Severity, ERROR_State, ERROR_MESSAGE, SET ERROR.
c. The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement custom error messages in your applications.
12. Types of Triggers:
a. Instead of
b. After trigger
Differences between the two:
INSTEAD OF triggers gets executed automatically before the Primary Key and the Foreign Key constraints are checked, whereas the traditional AFTER triggers gets executed after these constraints are checked. Unlike AFTER triggers, INSTEAD OF triggers can be created on views.
13. To define the sequence of the triggers on a table if more than one trigger exist on that table then use the system stored procedure sp_settriggerorder.
14. Difference between Data Set and Data Reader:
a. Data reader provides forward only and ready only access to data while dataset can hold more than a table.
b. Dataset persists the content but Data reader not.
15. Methods provided by the dataset for XML:
a. Read XML
b. Get XML
c. Write XML
16. For XML clause in SQL server returns data in XML rather than simple rows and columns.
17. To generate schema of a table: Select * from mytable For XML AUTO, XMLSCHEMA
18. OPEN XML is vice versa of FOR XML AUTO. When XML is passed it returns rows and column.
19. XMLA: XML for analysis is fundamentally based on web services and SOAP. MS SQL 2005 analysis services use XMLA to handle all client application communication for analysis services. XMLA is a SOAP based XML protocol designed specifically for universal data access to any standard multi dimensional data source residing on the web.
20. Normalization: Suppose there are few tables having relationships between them. So while designing these tables we need to follow some set of rules to connect these tables. These set of rules are called normalization.
Advantages of Normalization:
a. Avoid redundancy i.e. repetitive entries.
b. Reducing required storage space.
c. Preventing the need to restructure existing tables to accommodate new data.
d. Increased speed and flexibility of queries, sorts, and summaries.
First Normal Form For a table to be in first normal form, data must be broken up into the smallest units possible. In addition to breaking data up into the smallest meaningful values, tables in first normal form should not contain repetitions groups of fields. In a table if there are two columns city1,city2 and customer name. To make it in first normal form we should break the Customer name into two columns First Name and Last Name. Moreover the repetitive columns like city1, city2 should be merged as City.
Second Normal form The second normal form states that each field in a multiple field primary key table must be directly related to the entire primary key. So If we will shift City to a different master table then our database is said to be in Second Normal Form.
Third normal form A non-key field should not depend on other Non-key field. The field "Total" is dependent on "Unit price" and "qty". Suppose our table contains three fields Unit price, Qty and Total. Total can be calculated by multiplication of Unit price * Qty. So we can remove the Total field from the table. This will bring our table in Third normal form.
21. Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance. The sacrifice to performance is that you increase redundancy in database.
22. Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quickly. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way in which records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
23. How can we increase SQL performance
Following are tips which will increase your SQl performance :-
a. Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-only table, then the number of indexes may be increased.
b. Keep your indexes as narrow as possible. This reduces the size of the index and reduces the number of reads required to read the index.
c. Try to create indexes on columns that have integer values rather than character values.
d. If you create a composite (multi-column) index, the order of the columns in the key are very important. Try to order the columns in the key as to enhance selectivity, with the most selective columns to the left most of the key.
e. If you want to join several tables, try to create surrogate integer keys for this purpose and create indexes on their columns.
f. Create surrogate integer primary key (identity for example) if your table will not have many insert operations.
g. Clustered indexes are more preferable than nonclustered, if you need to select by a range of values or you need to sort results set with GROUP BY or ORDER BY.
h. If your application will be performing the same query over and over on the same table, consider creating a covering index on the table.
i. You can use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables" trace to determine which tables in your database may need indexes. This trace will show which tables are being scanned by queries instead of using an index.
24. Following are the problems that occur if we do not implement locking properly in SQL SERVER.
a. Lost Updates: This happens due to most likely to occur with the READ UNCOMMITTED isolation level. Due to this we lose the first transaction if two transaction happens over the same data simultaneously.
b. Non-Repeatable Read: Non-repeatable reads occur if a transaction is able to read the same row multiple times and gets a different value each time.
c. Dirty Reads: Dirty reads are a special case of non-repeatable read. This happens if we run a report while transactions are modifying the data that we're reporting on.
d. Phantom Reads: Phantom reads occur due to a transaction being able to read a row on the first read, but not being able to modify the same row due to another transaction deleting rows from the same table.
25. Transaction Isolation level decides how is one process isolated from other process. Using transaction levels we can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER :
a. READ COMMITTED: The shared lock is held for the duration of the transaction, meaning that no other transactions can change the data at the same time.
b. READ UNCOMMITTED: No shared locks and no exclusive locks are honored. This is the least restrictive isolation level resulting in the best concurrency but the least data integrity.
c. REPEATABLE READ: This setting disallows dirty and non-repeatable reads. However, even though the locks are held on read data, new rows can still be inserted in the table, and will subsequently be interpreted by the transaction.
d. SERIALIZABLE: This is the most restrictive setting holding shared locks on the range of data. This setting does not allow the insertion of new rows in the range that is locked; therefore, no phantoms are allowed. Following is the syntax for setting transaction level in SQL SERVER. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
26. Depending on the transaction level six types of lock can be acquired on data :
a. Intent: Intent locks come in three flavors: intent shared (IS), intent exclusive (IX), and shared with intent exclusive (SIX). IS locks indicate that the transaction will read some (but not all) resources in the table or page by placing shared locks. IX locks indicate that the transaction will modify some (but not all) resources in the table or page by placing exclusive locks. SIX locks indicates that the transaction will read all resources, and modify some(but not all) of them. This will be accomplished by placing the shared locks on the resources read and exclusive locks on the rows modified. Only one SIX lock is allowed per resource at one time; therefore, SIX locks prevent other connections from modifying any data in the resource (page or table), although they do allow reading the data in the same resource.
b. Shared locks (S) allow transactions to read data with SELECT statements. Other connections are allowed to read the data at the same time; however, no transactions are allowed to modify data until the shared locks are released.
c. Update locks (U) are acquired just prior to modifying the data. If a transaction modifies a row, then the update lock is escalated to an exclusive lock; otherwise, it is converted to a shared lock. Only one transaction can acquire update locks to a resource at one time. Using update locks prevents multiple connections from having a shared lock that want to eventually modify a resource using an exclusive lock. Shared locks are compatible with other shared locks, but are not compatible with Update locks.
d. Exclusive locks (X) completely lock the resource from any type of access including reads. They are issued when data is being modified through INSERT, UPDATE and DELETE statements.
e. Schema modification locks (Sch-M) are acquired when data definition language statements, such as CREATE TABLE, CREATE INDEX, ALTER TABLE, and so on are being executed. Schema stability locks (Sch-S) are acquired when store procedures are being compiled.
f. Bulk update locks (BU) are used when performing a bulk-copy of data into a table with TABLOCK hint. These locks improve performance while bulk copying data into a table; however, they reduce concurrency by effectively disabling any other connections to read or modify data in the table.
27. Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Server escalates the many fine-grain locks to fewer coarse-grain locks.
28. Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber.
a. Publisher: Database server that makes data available for replication is called as Publisher.
b. Subscriber: Database Servers that get data from the publishers is called as Subscribers.
There are three types of replication supported by SQL SERVER.
a. Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The only disadvantage of this type of replication is that all data has to be copied each time the table is refreshed.
b. Transactional Replication In transactional replication data is copied first time as in snapshot replication, but later only the transactions are synchronized rather than replicating the whole database. We can either specify to run continuously or on periodic basis.
c. Merge Replication. Merge replication combines data from multiple sources into a single central database. Again as usual the initial load is like snapshot but later it allows change of data both on subscriber and publisher, later when they come on-line it detects and combines them and updates accordingly.
29. User defined Functions:
User defined functions are TSQL routines used to encapsulate the programming logic.
Types of UDF:
1. Scalar: Returns a single value of a scalar data type. Cannot return text, timestamp or image.
Things we cannot do:
a. Insert/Update/Delete
b. Execute SP’s
c. Error Handling
d. Print
2. Inline: Return tables equivalent to views with parameters.
Insert\update \Delete are possible.
3. Multi statement: Tables can be returned.
Following are some major differences between a stored procedure and user defined functions:
a. Stored procedures are called independently, using the EXEC command, while functions need to be called from within another SQL statement.
b. Stored procedure allow you to enhance application security by granting users and applications permission to use stored procedures, rather than permission to access the underlying tables. Stored procedures provide the ability to restrict user actions at a much more granular level than standard SQL Server permissions.
c. UDF cannot be used in XML FOR clause but SP’s can be used.
d. Functions must always return a value (either a scalar value or a table). Stored procedures may return a scalar value, a table value or nothing at all.
e. If there is an error in UDF its stops executing. But in SP’s it just ignores the error and moves to the next statement.
f. UDF cannot make permanent changes to server environments while SP’s can change some of the server environment.
g. UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be.
30. Performance Tuning SQL Server Cursors:
If possible, we should avoid using SQL Server cursors. They generally use a lot of SQL Server resources and reduce the performance and scalability of our applications. If we need to perform row-by-row operations here are some alternatives:
• Use WHILE LOOPS
• Use temp tables
• Use derived tables
• Use correlated sub-queries
• Use the CASE statement
• Perform multiple queries
1. If we have to use a cursor, we should try to reduce the number of records to process by using temp table. The lower the number of records to process, the faster the cursor will finish.
2. If the number of rows you need to return from a query is small, and we need to perform row-by-row operations on them, don't use a server-side cursor. Instead, consider returning the entire rowset to the client and have the client perform the necessary action on each row, then return any updated rows to the server
3. If we have no choice but to use a server-side cursor in our application, we should try to use a FORWARD-ONLY or FAST-FORWARD, READ-ONLY cursor. Also we should try to locate the SQL Server tempdb database on its own physical device for best performance. This is because cursors use the tempdb for temporary storage of cursor data. The faster your disk array running tempdb, the faster our cursor will be.
4. If we need to perform a JOIN as part of our cursor, keyset and static cursors are generally faster than dynamic cursors, and should be used when possible.
31. To get all the row values concatenated.
Declare @colors varchar(250)
Select @colors = COALESCE(@colors + '/','') + CompanyName from dbo.Company
print @colors
BizTalk Bizzare
BizTalk Bizarre………………………………….by Vikash Kumar…………………….
1. Active property made true invokes a new instance of an orchestration. Only a nested Orchestration can be started without an active receive. BizTalk Server has no built in mechanism for controlling the number of instances of a given orchestration. If we have to control the number of instances of Orch A then we have to create some rule or Orch which will allow/restrict it to activate one more instance.
2. Static Global variables can be stored in Configuration files or SQL tables in order to share them across all the instances of the Orchestration.
3. Zombie is a message which is discarded when the instance of the Orchestration ends with “Completed with Discarded Message”. It typically occurs when an extra message is routed after control flow in the executing orchestration has passed the receive shape with the matching subscription or due to a time out on a LR transaction or a time out of a delay branch on a listen shape or in a loop that consists a receive shape that exits before consuming all the routed messages.
4. “Delivered Not Consumed” this is the status of the message when it is in the BTS internal work queue. It might be in this state because the engine is busy with other messages or because the destination is processing more slow than expected.
5. Curious case of Serialization in orchestration:
The XLANG compiler requires all its variables in an orchestration to be serializable since when the orchestration dehydrates and rehydrates then it serializes and deserializes those variables.
A non serializable object can only be declared and used in an atomic scope.
An interface cannot be marked as a serializable because we are never sure about their implementation. So Non Serializable objects must run inside atomic scopes.
6. For an Atomic Scope, if Retry is set to true only two exceptions “Persistence Exception” and “RetryTransactionExcepion” will make the atomic transaction retry work.
7. Orchestration supports parallel activation only in following conditions:
a. If one of the tasks of a parallel activation has an active Receive as the first shape, all of the tasks of that parallel activation must have an active Receive as the first shape, and all of those Receive shapes must initialize at least one correlation.
b. If a particular correlation is initialized on more than one task of a parallel activation by a Receive shape, each of the concerned activating Receive shapes must initialize exactly the same correlation.
8. Difference between Start Orchestration and Call Orchestration:
a. Call Orchestration is a synchronous call and it returns the control back to the caller.
b. Start orchestration is an Asynchronous call and hence it starts the orchestration in a non deterministic way. In this case some time what we expect that the new orchestration will start in time to create the necessary subscriptions to receive the messages that will be sent to it but quite often it doesn’t happen so. In this case it gives” could not find subscription error".
9. Persistence points in Orchestration:
The orchestration engine saves the entire state of an orchestration instance at various persistence points to allow rehydration of the orchestration instance. The engine stores state at the following persistence points:
• End of a transactional scope (atomic or long running)
• At debugging breakpoints
• At the execution of other orchestrations through the Start Orchestration shape
• At the Send shape (except in an atomic transaction)
• When an Orchestration Instance is suspended
• When the system shutdowns in a controlled manner
• When the engine determines it wants to dehydrate
• When an orchestration instance is finished
10. BizTalk Server upgrade: BizTalk 2004 and BizTalk 2006 cannot reside on the same machine and so as SQL Server 2000 and 2005. So while upgrading BTS2004 to 2006 database also needs to upgraded from 2000 to 2005.
Note: Within a single group in case of multiple BizTalk servers if one server is upgrade then all the servers need to be upgraded because interoperability between BTS2004 and BTS 2006 is not supported due because of DB changes.
11. Business Rule Engine:
a. Rule: A single executable statement which is made up of a condition and an action.
b. Policies: Logical group of rules.
c. Vocabulary: Friendly name given to a field.
How does rule engine works:
Business Rule Composer is used for developing business policies, vocabulary definitions, publish the policies. Inside the BRC when we want to test the policy for a .Net component we need to create a Fact creator wrapper around the .Net Component implementing the interface IFactCreator. Create Facts is the method called by the rule engine. Rule engine deployment wizard deploy/export/import the policies and vocabularies. Rule engine evaluates the condition based on fact. When a policy is executed, the facts are brought into memory. After execution all the facts submitted to the rule engine are retracted from the working memory of the rule engine.
Important: When we test a policy that uses database facts with the DataConnection binding in the Business Rule Composer, a DataConnection object is automatically built. However, when we call the same policy from an orchestration by using the Call Rules shape, no DataConnection object is passed to the policy automatically. We should create a DataConnection object in the orchestration and pass it as a parameter or create a fact retriever component that asserts the DataConnection object, and configure the policy to use the fact retriever component.
How to call Rules from:
a. Orchestration: We can call rules from orchestration using Call Rule shape. Also we can use .Net API inside the expression shape to call the policies.
i. Create the object of the samplepolicy we created in BRC.
Policy = new Microsoft.RuleEngine.Policy(“SamplePolicy”,1,0);
ii. Create the input parameter for the policy
typedXmlDoc = new MS.RE.TypedXmlDocument(“inputXML”,inmputmessgae);
iii. Execute the policy and then dispose.
Policy.Execute(typedXmlDoc);
Policy.dispose();
b. C# code:
Same as above. Only difference is that we need to create the facts object array to hold the input params for the policy as objects[] facts = new object[1];
Facts[0] = typedXmlDoc;
Policy.Execute(facts);
Advanced Concepts:
a. Forward chaining: One rule invokes the other rule.
b. Short term vs. long term fact:
i. Short-term facts are facts loaded into memory by rule engine and are available for only one execution cycle of the rule engine, after the execution facts are retracted back from memory. Long term facts are available for multiple execution cycles of rule engine.
ii. Short term facts are passed to rule engine as array of objects, whereas long term facts are passed as typed Data Table which has typed Data Rows to rule engine.
12. Transactions in Orchestration:
a. Atomic Transaction: Either completely successful or completely rollbacked.
i. Cannot contain nested Atomic transaction or LR transaction or a exception handler however can contain a compensation block.
ii. We cannot construct an atomic transaction with a request response pair of actions, nor we can have send and receive shape that uses the same correlation set.
iii. When a message is received in an atomic transaction, it is delivered to the orchestration but not removed from the message box until the transaction commits.
b. LR Transaction: A transaction which executes for several hours, days or even weeks and contains several atomic transactions. These smaller atomic transactions which are completed/committed, cannot be rolled back and hence need to be compensated.
COMPENSATION: Undo operation
Exception block does not roll back the transaction but just throws the error.
13. When many long-running business processes are running at the same time, memory and performance are potential issues. The orchestration engine addresses these issues by "dehydrating" and "rehydrating" orchestration instances.
Dehydration is the process of serializing the state of an orchestration into a SQL Server database. Rehydration is the reverse of this process: deserializing the last running state of an orchestration from the database. Dehydration is used to minimize the use of system resources by reducing the number of orchestrations that have to be instantiated in memory at one time.
14. Correlation is used to map a message to its corresponding Orchestration instance A correlation set is a collection of promoted message property values that we use to route an incoming message to an executing instance. The message is evaluated for the message type and every property in the set in order to correctly route it to the instance. Correlation is achieved with the help of "Initialize Correlation Set" and "Follow up Correlation Set" properties in the Send and Receive shapes.
15. Deployment: After build phase of the BizTalk project when we need to migrate the work from our work environment to test environment first we need to export the .msi files. Remenber that configuration values what we have made in BTSNTSvc.exe.config file are not exported. Patches(only added\modified file) can also be exported. Export bindings and plocies.
After exporting import the .msi and binding files in the test environment.
16. Binding Model in BizTalk:
a. Direct Binding(Most Flexible): In this Model, orchestration ports do not automatically use BTS.SPID or BTS.RecievePortId. Rather filter expressions or self correlating or message context property can be used. Can be used to send message to other orchestration. Drawback is that we cannot configure our orchestration port using binding files. We need to do more programming in order to fully exploit the flexibility.
b. Specify later: Less flexible but most common. BTS.SPID, BTS.RecieverId
c. Specify now: BizTalk collects transport and pipeline info at design time.
d. Dynamic Binding: In expressions we have to give URLs that can be picked from config file.
17. Delivery Notification in BizTalk: If an Orchestration port is marked with Delivery Notification = Transmitted, and the Send shape in the Orchestration is in a synchronized scope, the Orchestration will wait until it either receives an ACK or a NACK for the message that was transmitted. In the case that the message was successfully transmitted, the engine will publish an ACK ensuring that it is routed back to that Orchestration instance, once the Orchestration receives the ACK it will leave the scope and continue processing. If however the transmission failed and the message was suspended, the engine will publish a NACK which again will be routed back to the Orchestration instance, the Orchestration will throw a DeliveryFailureException which can of course be caught and handled as appropriate in the Orchestration.
18. Dynamic Mapping: Dynamic mapping is the concept of specifying the map to be used for a transform at runtime inside the orchestration. That means no Transform Shape is used to specify the map or input and output schemas.
Example: We are receiving a standard invoice from multiple locations for the same vendor. The schema is exactly the same but the mapping of the vendor data to the base schema (date formats, currency conversion, etc.) is slightly different based on the vendor location.
Why not map on the Receive Port? This is the most common solution to this type of scenario. This uses document normalization to transform all your messages into the same type before it hits our business process. This is a great solution but what about exceptions?
Exceptions in maps on the Receive Port can be hard to react to and even harder to orchestrate a retry or recovery process. That is when mapping inside an Orchestration and Dynamic Maps come into play.
With dynamic maps, the map name can be stored inside an attribute in the message, read from the SSO, or read from some other custom component. Then, it is as simple as creating a System.Type with the strong fully qualified map name.
This would look something like this:
Suppose SubscriberInformation is the node in input xml which contains the recipients info then we will take it in a variable.
SubscriberInformation = Generic_In(DynamicMaps.PropertySchema.SubscriberInfo );
then we will take the maptype in another variable of System.Type like this
tMap = System.Type.GetType("DynamicMaps.Map_ABC,DynamicMaps, Version=1.0.0.0, Culture=neutral,PublicKeyToken=f85be9e4dd36fb1d");
then in a message assignment shape we can construct the out message as follows:
transform (Message_Out) = tMap(Generic_In);
Alternatively we can do it in an expression shape using the construct keyword as below:
construct Message_Out
{
transform (Message_Out) = tMap(Generic_In);
}
19. BizTalk Server can accommodate two or more schema with the same root node as long as the schemas have unique namespace designations.
20. Message context includes all the instance specific and exchange specific data fields, and essentially is the metadata that the messaging engine of BizTalk Server uses to process messages. While duplicating a message it should be noted that Only MessageDataPropertyBase gets copied not the MessageContextProperty Base. So to copy the message context property of message 2 into the message context of message 1
Message1(*) = Message2(*);
21. Distinguish fields are used opposed to promoted fields to enhance the performance.
a) Distinguish fields are available only within a single orchestration and they are not available to other BizTalk Server objects such as receive locations, send ports, send port groups and tracking utilities.
b) Distinguish fields can be of any length; promoted properties have a maximum length of 255 characters.
c) Distinguished fields have less of a performance impact than promoted properties as they are not persisted to the Message Box database. Instead they are XPath aliases which simply point to the appropriate XML data field.
d) Distinguish fields are accessed in following fashion: MessageName.RecordName.Childname while Promoted fields are accessed in this way MessageName(PropertySchemaName.PromotedPropertyName)
22. To hide promoted properties from the tools like HAT and BAM, set the promoted property’s Sensitive Information property to True.
23. It is also possible to create message context properties that do not exist in the message by just adding a node to the property schema and setting its Property Schema base property to MessageContextProperty Base.
24. To process a message that contains multiple records in a batch fashion we need to create envelopes. Nesting of Envelopes is also possible to ensure a flexible way of transferring message batches that have complex structure or relationship.
a. Set Envelop property to YES.
b. Body Xpath property need to be set.
25. We can put validation on the input data as in the case of phone numbers, ip address as they should come in a specific format. So we can define formats for them by setting Derived By property to Restriction and specifying the required pattern for that particular field.
1. Active property made true invokes a new instance of an orchestration. Only a nested Orchestration can be started without an active receive. BizTalk Server has no built in mechanism for controlling the number of instances of a given orchestration. If we have to control the number of instances of Orch A then we have to create some rule or Orch which will allow/restrict it to activate one more instance.
2. Static Global variables can be stored in Configuration files or SQL tables in order to share them across all the instances of the Orchestration.
3. Zombie is a message which is discarded when the instance of the Orchestration ends with “Completed with Discarded Message”. It typically occurs when an extra message is routed after control flow in the executing orchestration has passed the receive shape with the matching subscription or due to a time out on a LR transaction or a time out of a delay branch on a listen shape or in a loop that consists a receive shape that exits before consuming all the routed messages.
4. “Delivered Not Consumed” this is the status of the message when it is in the BTS internal work queue. It might be in this state because the engine is busy with other messages or because the destination is processing more slow than expected.
5. Curious case of Serialization in orchestration:
The XLANG compiler requires all its variables in an orchestration to be serializable since when the orchestration dehydrates and rehydrates then it serializes and deserializes those variables.
A non serializable object can only be declared and used in an atomic scope.
An interface cannot be marked as a serializable because we are never sure about their implementation. So Non Serializable objects must run inside atomic scopes.
6. For an Atomic Scope, if Retry is set to true only two exceptions “Persistence Exception” and “RetryTransactionExcepion” will make the atomic transaction retry work.
7. Orchestration supports parallel activation only in following conditions:
a. If one of the tasks of a parallel activation has an active Receive as the first shape, all of the tasks of that parallel activation must have an active Receive as the first shape, and all of those Receive shapes must initialize at least one correlation.
b. If a particular correlation is initialized on more than one task of a parallel activation by a Receive shape, each of the concerned activating Receive shapes must initialize exactly the same correlation.
8. Difference between Start Orchestration and Call Orchestration:
a. Call Orchestration is a synchronous call and it returns the control back to the caller.
b. Start orchestration is an Asynchronous call and hence it starts the orchestration in a non deterministic way. In this case some time what we expect that the new orchestration will start in time to create the necessary subscriptions to receive the messages that will be sent to it but quite often it doesn’t happen so. In this case it gives” could not find subscription error".
9. Persistence points in Orchestration:
The orchestration engine saves the entire state of an orchestration instance at various persistence points to allow rehydration of the orchestration instance. The engine stores state at the following persistence points:
• End of a transactional scope (atomic or long running)
• At debugging breakpoints
• At the execution of other orchestrations through the Start Orchestration shape
• At the Send shape (except in an atomic transaction)
• When an Orchestration Instance is suspended
• When the system shutdowns in a controlled manner
• When the engine determines it wants to dehydrate
• When an orchestration instance is finished
10. BizTalk Server upgrade: BizTalk 2004 and BizTalk 2006 cannot reside on the same machine and so as SQL Server 2000 and 2005. So while upgrading BTS2004 to 2006 database also needs to upgraded from 2000 to 2005.
Note: Within a single group in case of multiple BizTalk servers if one server is upgrade then all the servers need to be upgraded because interoperability between BTS2004 and BTS 2006 is not supported due because of DB changes.
11. Business Rule Engine:
a. Rule: A single executable statement which is made up of a condition and an action.
b. Policies: Logical group of rules.
c. Vocabulary: Friendly name given to a field.
How does rule engine works:
Business Rule Composer is used for developing business policies, vocabulary definitions, publish the policies. Inside the BRC when we want to test the policy for a .Net component we need to create a Fact creator wrapper around the .Net Component implementing the interface IFactCreator. Create Facts is the method called by the rule engine. Rule engine deployment wizard deploy/export/import the policies and vocabularies. Rule engine evaluates the condition based on fact. When a policy is executed, the facts are brought into memory. After execution all the facts submitted to the rule engine are retracted from the working memory of the rule engine.
Important: When we test a policy that uses database facts with the DataConnection binding in the Business Rule Composer, a DataConnection object is automatically built. However, when we call the same policy from an orchestration by using the Call Rules shape, no DataConnection object is passed to the policy automatically. We should create a DataConnection object in the orchestration and pass it as a parameter or create a fact retriever component that asserts the DataConnection object, and configure the policy to use the fact retriever component.
How to call Rules from:
a. Orchestration: We can call rules from orchestration using Call Rule shape. Also we can use .Net API inside the expression shape to call the policies.
i. Create the object of the samplepolicy we created in BRC.
Policy = new Microsoft.RuleEngine.Policy(“SamplePolicy”,1,0);
ii. Create the input parameter for the policy
typedXmlDoc = new MS.RE.TypedXmlDocument(“inputXML”,inmputmessgae);
iii. Execute the policy and then dispose.
Policy.Execute(typedXmlDoc);
Policy.dispose();
b. C# code:
Same as above. Only difference is that we need to create the facts object array to hold the input params for the policy as objects[] facts = new object[1];
Facts[0] = typedXmlDoc;
Policy.Execute(facts);
Advanced Concepts:
a. Forward chaining: One rule invokes the other rule.
b. Short term vs. long term fact:
i. Short-term facts are facts loaded into memory by rule engine and are available for only one execution cycle of the rule engine, after the execution facts are retracted back from memory. Long term facts are available for multiple execution cycles of rule engine.
ii. Short term facts are passed to rule engine as array of objects, whereas long term facts are passed as typed Data Table which has typed Data Rows to rule engine.
12. Transactions in Orchestration:
a. Atomic Transaction: Either completely successful or completely rollbacked.
i. Cannot contain nested Atomic transaction or LR transaction or a exception handler however can contain a compensation block.
ii. We cannot construct an atomic transaction with a request response pair of actions, nor we can have send and receive shape that uses the same correlation set.
iii. When a message is received in an atomic transaction, it is delivered to the orchestration but not removed from the message box until the transaction commits.
b. LR Transaction: A transaction which executes for several hours, days or even weeks and contains several atomic transactions. These smaller atomic transactions which are completed/committed, cannot be rolled back and hence need to be compensated.
COMPENSATION: Undo operation
Exception block does not roll back the transaction but just throws the error.
13. When many long-running business processes are running at the same time, memory and performance are potential issues. The orchestration engine addresses these issues by "dehydrating" and "rehydrating" orchestration instances.
Dehydration is the process of serializing the state of an orchestration into a SQL Server database. Rehydration is the reverse of this process: deserializing the last running state of an orchestration from the database. Dehydration is used to minimize the use of system resources by reducing the number of orchestrations that have to be instantiated in memory at one time.
14. Correlation is used to map a message to its corresponding Orchestration instance A correlation set is a collection of promoted message property values that we use to route an incoming message to an executing instance. The message is evaluated for the message type and every property in the set in order to correctly route it to the instance. Correlation is achieved with the help of "Initialize Correlation Set" and "Follow up Correlation Set" properties in the Send and Receive shapes.
15. Deployment: After build phase of the BizTalk project when we need to migrate the work from our work environment to test environment first we need to export the .msi files. Remenber that configuration values what we have made in BTSNTSvc.exe.config file are not exported. Patches(only added\modified file) can also be exported. Export bindings and plocies.
After exporting import the .msi and binding files in the test environment.
16. Binding Model in BizTalk:
a. Direct Binding(Most Flexible): In this Model, orchestration ports do not automatically use BTS.SPID or BTS.RecievePortId. Rather filter expressions or self correlating or message context property can be used. Can be used to send message to other orchestration. Drawback is that we cannot configure our orchestration port using binding files. We need to do more programming in order to fully exploit the flexibility.
b. Specify later: Less flexible but most common. BTS.SPID, BTS.RecieverId
c. Specify now: BizTalk collects transport and pipeline info at design time.
d. Dynamic Binding: In expressions we have to give URLs that can be picked from config file.
17. Delivery Notification in BizTalk: If an Orchestration port is marked with Delivery Notification = Transmitted, and the Send shape in the Orchestration is in a synchronized scope, the Orchestration will wait until it either receives an ACK or a NACK for the message that was transmitted. In the case that the message was successfully transmitted, the engine will publish an ACK ensuring that it is routed back to that Orchestration instance, once the Orchestration receives the ACK it will leave the scope and continue processing. If however the transmission failed and the message was suspended, the engine will publish a NACK which again will be routed back to the Orchestration instance, the Orchestration will throw a DeliveryFailureException which can of course be caught and handled as appropriate in the Orchestration.
18. Dynamic Mapping: Dynamic mapping is the concept of specifying the map to be used for a transform at runtime inside the orchestration. That means no Transform Shape is used to specify the map or input and output schemas.
Example: We are receiving a standard invoice from multiple locations for the same vendor. The schema is exactly the same but the mapping of the vendor data to the base schema (date formats, currency conversion, etc.) is slightly different based on the vendor location.
Why not map on the Receive Port? This is the most common solution to this type of scenario. This uses document normalization to transform all your messages into the same type before it hits our business process. This is a great solution but what about exceptions?
Exceptions in maps on the Receive Port can be hard to react to and even harder to orchestrate a retry or recovery process. That is when mapping inside an Orchestration and Dynamic Maps come into play.
With dynamic maps, the map name can be stored inside an attribute in the message, read from the SSO, or read from some other custom component. Then, it is as simple as creating a System.Type with the strong fully qualified map name.
This would look something like this:
Suppose SubscriberInformation is the node in input xml which contains the recipients info then we will take it in a variable.
SubscriberInformation = Generic_In(DynamicMaps.PropertySchema.SubscriberInfo );
then we will take the maptype in another variable of System.Type like this
tMap = System.Type.GetType("DynamicMaps.Map_ABC,DynamicMaps, Version=1.0.0.0, Culture=neutral,PublicKeyToken=f85be9e4dd36fb1d");
then in a message assignment shape we can construct the out message as follows:
transform (Message_Out) = tMap(Generic_In);
Alternatively we can do it in an expression shape using the construct keyword as below:
construct Message_Out
{
transform (Message_Out) = tMap(Generic_In);
}
19. BizTalk Server can accommodate two or more schema with the same root node as long as the schemas have unique namespace designations.
20. Message context includes all the instance specific and exchange specific data fields, and essentially is the metadata that the messaging engine of BizTalk Server uses to process messages. While duplicating a message it should be noted that Only MessageDataPropertyBase gets copied not the MessageContextProperty Base. So to copy the message context property of message 2 into the message context of message 1
Message1(*) = Message2(*);
21. Distinguish fields are used opposed to promoted fields to enhance the performance.
a) Distinguish fields are available only within a single orchestration and they are not available to other BizTalk Server objects such as receive locations, send ports, send port groups and tracking utilities.
b) Distinguish fields can be of any length; promoted properties have a maximum length of 255 characters.
c) Distinguished fields have less of a performance impact than promoted properties as they are not persisted to the Message Box database. Instead they are XPath aliases which simply point to the appropriate XML data field.
d) Distinguish fields are accessed in following fashion: MessageName.RecordName.Childname while Promoted fields are accessed in this way MessageName(PropertySchemaName.PromotedPropertyName)
22. To hide promoted properties from the tools like HAT and BAM, set the promoted property’s Sensitive Information property to True.
23. It is also possible to create message context properties that do not exist in the message by just adding a node to the property schema and setting its Property Schema base property to MessageContextProperty Base.
24. To process a message that contains multiple records in a batch fashion we need to create envelopes. Nesting of Envelopes is also possible to ensure a flexible way of transferring message batches that have complex structure or relationship.
a. Set Envelop property to YES.
b. Body Xpath property need to be set.
25. We can put validation on the input data as in the case of phone numbers, ip address as they should come in a specific format. So we can define formats for them by setting Derived By property to Restriction and specifying the required pattern for that particular field.
Friday, July 24, 2009
Kya ab bhi Insaniyat baaki hai....
Kya ab bhi Insaniyat baaki hai....
Ek vyang bhari muskaan kal mujhe chhoo kar nikal gai..
Dil me bhavnayein jo thos thi, Sab pighal gai...
Aansuon ki dhar kuchh aise bahi surk gaalo par..
dhadkan meri antar tak sihar gayi....
jab bhangi se jaaga to paas koi bhi nahi tha...
Dur un masoom hatho me aluminium ka katora pada tha..
Log aate jate us par taras khate nikal jate the..
Katora paise se kam, bas umidon se bhara tha..
Aaj un karun aankho me kasish thi, tanmayta thi...
kabhi jinme sapne saakaar karne ki utsukta thi...
bhavishya apna wo ab logo ki thikro pe banata hai bigarta hai..
kal tak jin khwabo me kuchh kar gujarne ki kshamta thi...
Kaise toote sapne uske iski bhi ek datsan hai..
maa baap ke guzarte hi bechara kitna pareshaan hai..
karib ke rishtedaro ne mushkil me kinara kar liya..
aur nishthur lalchi duniya ne use besahara kar diya..
Jab Jab ek palak bhi use dekhta hun..
is nirdai samaj ko kosta hun...
Bharosa ab to insaniyat par se uth gaya hai..
Aur sir bhi mera sharam se jhuk gaya hai..
Kya manviya mulya patal k gart me sama gaye hain..
ya fir hamari aatmaaon ko kaal nigal gaye hain..
Mar chuki hai insaniyat ab to, sirf chhal kapat chhaya hai..
Is kale mahasagar me bas kagazo ki maya hai..
Hatash ho chala tha mai, par tabhi dekha un haatho ko..
jo badh chale us chhote bachhe ko thamne ko...
Is wakye ne Insaniyat ko fir se jila diya..
aur ab bhi mari nahi hai insaniyat, ye mujhe sikha diya..
par ek vyang wali muskaan fir se mujhe hila gai...
apne kavi hone ke garv ko jad se murja gayi..
kalam se likhe ke apna kaam poora kar diya..
maan ke ho gai smaaj jagrut, man me hi khush ho liya..
par humse bada kavi to wo insaan hai ..
Jo samasya ko samajhta hai..janta hai..
Sirf likhta hi nahi, balki kuchh karke dikhata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
Ek vyang bhari muskaan kal mujhe chhoo kar nikal gai..
Dil me bhavnayein jo thos thi, Sab pighal gai...
Aansuon ki dhar kuchh aise bahi surk gaalo par..
dhadkan meri antar tak sihar gayi....
jab bhangi se jaaga to paas koi bhi nahi tha...
Dur un masoom hatho me aluminium ka katora pada tha..
Log aate jate us par taras khate nikal jate the..
Katora paise se kam, bas umidon se bhara tha..
Aaj un karun aankho me kasish thi, tanmayta thi...
kabhi jinme sapne saakaar karne ki utsukta thi...
bhavishya apna wo ab logo ki thikro pe banata hai bigarta hai..
kal tak jin khwabo me kuchh kar gujarne ki kshamta thi...
Kaise toote sapne uske iski bhi ek datsan hai..
maa baap ke guzarte hi bechara kitna pareshaan hai..
karib ke rishtedaro ne mushkil me kinara kar liya..
aur nishthur lalchi duniya ne use besahara kar diya..
Jab Jab ek palak bhi use dekhta hun..
is nirdai samaj ko kosta hun...
Bharosa ab to insaniyat par se uth gaya hai..
Aur sir bhi mera sharam se jhuk gaya hai..
Kya manviya mulya patal k gart me sama gaye hain..
ya fir hamari aatmaaon ko kaal nigal gaye hain..
Mar chuki hai insaniyat ab to, sirf chhal kapat chhaya hai..
Is kale mahasagar me bas kagazo ki maya hai..
Hatash ho chala tha mai, par tabhi dekha un haatho ko..
jo badh chale us chhote bachhe ko thamne ko...
Is wakye ne Insaniyat ko fir se jila diya..
aur ab bhi mari nahi hai insaniyat, ye mujhe sikha diya..
par ek vyang wali muskaan fir se mujhe hila gai...
apne kavi hone ke garv ko jad se murja gayi..
kalam se likhe ke apna kaam poora kar diya..
maan ke ho gai smaaj jagrut, man me hi khush ho liya..
par humse bada kavi to wo insaan hai ..
Jo samasya ko samajhta hai..janta hai..
Sirf likhta hi nahi, balki kuchh karke dikhata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
aur Is samaj me Insaan hone ka Ehsaas karata hai..
Wednesday, July 22, 2009
MERA BACHPAN
MERA BACHPAN
EK Shararat maine ki thi bachpan me
Dhoonda karta hun ab bhi jisko apne youwan me
Shararat jo us waqt koi khaas na thi
Churaye the aam unke jab wo paas na thi
Kabhi Jab Yaad aata hai wo, Papa ka mujhe school me chhod ke aana
Aur unke ghar wapas pahunchne se pahle hi mera ghar pahunch jana
Ek halki si muskurahat mere chehre pe aaj bhi khinch jati hai
Aur mujhe barbas un purane dino me khinch lati hai
Tab jab hum befikar ko kar dhoop barsaat me khela karte the
Kshitiz ke is paar se us paar ko dauda karte the
Na kahin tha girne ka darr,
dhun me rahte the apne
Subah Shaam aur charo pehar.
Yahin kahin aas paas wo masterji ki chadi dikhai de jati hai
Aur wo karun drishya fir se aankho ke samne ubhar aati hai
Fir wo yaad aate hain dosto ke sang wo jhagde aur jhanjhat
Wo class ki ladkiyan, kitni pyari kitni natkhat.
Ye lo wo panwari ki dukan bhi aa gayi
Hamare gappon ki dastan ko fir se duhra gayi
Fir wo yaad aate hain kitabo ke andar wo comics rakhkar padhna
Nagraj, dhruva, bhokal aur wo chhota bauna.
Wo jab ladko ko sadak pe sutta marte dekha karte the
Kisi hasin ladki pe unke comments suna karte the
Ek kasak kaisi jagti thi dil me
aksar sochte the kab bade honge
Aur shamil honge unki mehfil me.
Din gujra aur lo aaj fir sham ho gayi
Der se daftar se lautna baat ye aam ho gayi
Samajh nahi aata ye kaisi zindagi hai
Ghar se daftar aur daftar se ghar, bas yahi bebasi hai
Barish me bhigna to ab khwabo me hi dekhte hain
Dhool dhoop aur mitti ke naam se sihar jate hain
Aksar galiyon ke bachho ko jab hurdang machete dekhte hain
Dil hi dil me bas man masos ke rah jate hain
Kash hum aaj bhi bade na hue hote
Is bhaag daud ki zindagi me Khade na hue hote
Ek baar sochta hun kabhi kabhi, Kaash aisa hota
Ek baar wapas ja kar apna bachpan fir se ji leta
Apni aankhein mund leta aur fir kabhi bada nahi hota…..
EK Shararat maine ki thi bachpan me
Dhoonda karta hun ab bhi jisko apne youwan me
Shararat jo us waqt koi khaas na thi
Churaye the aam unke jab wo paas na thi
Kabhi Jab Yaad aata hai wo, Papa ka mujhe school me chhod ke aana
Aur unke ghar wapas pahunchne se pahle hi mera ghar pahunch jana
Ek halki si muskurahat mere chehre pe aaj bhi khinch jati hai
Aur mujhe barbas un purane dino me khinch lati hai
Tab jab hum befikar ko kar dhoop barsaat me khela karte the
Kshitiz ke is paar se us paar ko dauda karte the
Na kahin tha girne ka darr,
dhun me rahte the apne
Subah Shaam aur charo pehar.
Yahin kahin aas paas wo masterji ki chadi dikhai de jati hai
Aur wo karun drishya fir se aankho ke samne ubhar aati hai
Fir wo yaad aate hain dosto ke sang wo jhagde aur jhanjhat
Wo class ki ladkiyan, kitni pyari kitni natkhat.
Ye lo wo panwari ki dukan bhi aa gayi
Hamare gappon ki dastan ko fir se duhra gayi
Fir wo yaad aate hain kitabo ke andar wo comics rakhkar padhna
Nagraj, dhruva, bhokal aur wo chhota bauna.
Wo jab ladko ko sadak pe sutta marte dekha karte the
Kisi hasin ladki pe unke comments suna karte the
Ek kasak kaisi jagti thi dil me
aksar sochte the kab bade honge
Aur shamil honge unki mehfil me.
Din gujra aur lo aaj fir sham ho gayi
Der se daftar se lautna baat ye aam ho gayi
Samajh nahi aata ye kaisi zindagi hai
Ghar se daftar aur daftar se ghar, bas yahi bebasi hai
Barish me bhigna to ab khwabo me hi dekhte hain
Dhool dhoop aur mitti ke naam se sihar jate hain
Aksar galiyon ke bachho ko jab hurdang machete dekhte hain
Dil hi dil me bas man masos ke rah jate hain
Kash hum aaj bhi bade na hue hote
Is bhaag daud ki zindagi me Khade na hue hote
Ek baar sochta hun kabhi kabhi, Kaash aisa hota
Ek baar wapas ja kar apna bachpan fir se ji leta
Apni aankhein mund leta aur fir kabhi bada nahi hota…..
Tuesday, July 21, 2009
Confession of a Rapist
Confession of a Rapist
“A Software Engineer of an IT Giant raped his colleague”. This headline in the local newspaper drawn my attention and shook me from inside. Since the incident was from my city so it aroused my attention. In a flash I read through the column. It seemed to me a blot on the society and moreover on the humanity. My anger burst up and my inner self gave the verdict instantly “Hang him till death”. Suddenly I realized that I know this culprit. He stays in Mr. Waghmare’s house as paying guest from last one year. He never seemed to be such a devil. But in this age of lies and corruption nothing seems to be impossible.
I thought of visiting Waghmare sahib. I saw the entire family in great shock. “He has always been good to my daughter infact like an elder brother” Mr. Waghmare said.
I went inside into his room. I noticed a strange silence there may be it wanted to tell us everything about his dark character. His laptop and other accessories were seized by the police. I found torn pieces of notebooks and albums in the dustbin. I brought all with me in my workshop. I didn’t know why I was doing all this but I was simply doing.
I came back to my place and tried to rejoin all the torn pieces and snaps. I was not able to figure out all the snaps but could able to recognize most of them. In all his childhood snaps his face was disfigured maybe some ill disease he has caught in his childhood. His face was so absurd that at times it seems to me horrifying. I tried to rejoin his diary pages and could read some of them. His dark childhood was there in front of me. This was his inborn disease. And due to this how he got always neglected by his parents, brothers, sisters and class mates, all his plight was clearly mentioned in fainted letters he has written to God. He has always been longing for attention but no one gave him his due place in the society. He always complained God that not a single girl looks at him. This feeling was growing inside him and he was fighting with it every day every minute and every second. He chose education as his weapon to show the world what he is made up of. He pursued MCA degree but didn’t get any job at his hometown. So he came down to this city of dreams. But again his face was holding him behind. He knew that the treatment for this disease is possible but he had no money. He started his career with developing small web pages for small organizations. Gradually he started getting good offers and after so many hardships he earned a place in a reputed IT company. But here also the discrimination followed. He was now more focused on his transformation. Treatment brought good results for him and his face was improving but all this didn’t come so easy. He had to undergo severe pain. But on practical grounds things were still the same. He had no friends in the company. Moreover he wanted everyone’s attention. He thought he will achieve this but he could never make it in the traps and tricks of this industry. He was disappointed, heart broken…All his hopes were on the final surgery which was to happen next week. He had his plans after that. From a long time he had hidden love for his colleague. He always used to see her from a distance but never had enough heart to talk to her.
Finally the surgery was over. He took rest for one week. When he saw his new avatar in the mirror he was overwhelmed. He rushed to his love to confess how much he loves her. But she reprimanded him. She called him ugly and asked him to remain in his limits. This offended him to the core. He was devastated. All the anger, insult within him was eager to come out. And in this frustration he committed this heinous crime. He was not a bad man but at that moment of time he was worst. He was even worse than an animal. I realized that no person is good or bad but sometimes he becomes devil.
I also read the confession letter what he has written to his God. I think he has done all this to get the attention of the world which he was deprived since his childhood. I was not able to decide who was more guilty, he or the society. Who was more ugly, he or the society??? His action cannot be condoned but is this society forgivable? He has dishonored his love whatever may be the reasons; no one can justify his act. But I had to think again “should he be given death sentence”?
I felt that this will be infact good for him to hang him because even left free after 14 years of imprisonment; he won’t be able to survive. His soul will again and again raise questions to him. Will he be able to bear the pain for his entire life?
I sighed “May this society give something back in form of death sentence to this “Dog of lesser Gods” and I set fire to all the stuff.
“A Software Engineer of an IT Giant raped his colleague”. This headline in the local newspaper drawn my attention and shook me from inside. Since the incident was from my city so it aroused my attention. In a flash I read through the column. It seemed to me a blot on the society and moreover on the humanity. My anger burst up and my inner self gave the verdict instantly “Hang him till death”. Suddenly I realized that I know this culprit. He stays in Mr. Waghmare’s house as paying guest from last one year. He never seemed to be such a devil. But in this age of lies and corruption nothing seems to be impossible.
I thought of visiting Waghmare sahib. I saw the entire family in great shock. “He has always been good to my daughter infact like an elder brother” Mr. Waghmare said.
I went inside into his room. I noticed a strange silence there may be it wanted to tell us everything about his dark character. His laptop and other accessories were seized by the police. I found torn pieces of notebooks and albums in the dustbin. I brought all with me in my workshop. I didn’t know why I was doing all this but I was simply doing.
I came back to my place and tried to rejoin all the torn pieces and snaps. I was not able to figure out all the snaps but could able to recognize most of them. In all his childhood snaps his face was disfigured maybe some ill disease he has caught in his childhood. His face was so absurd that at times it seems to me horrifying. I tried to rejoin his diary pages and could read some of them. His dark childhood was there in front of me. This was his inborn disease. And due to this how he got always neglected by his parents, brothers, sisters and class mates, all his plight was clearly mentioned in fainted letters he has written to God. He has always been longing for attention but no one gave him his due place in the society. He always complained God that not a single girl looks at him. This feeling was growing inside him and he was fighting with it every day every minute and every second. He chose education as his weapon to show the world what he is made up of. He pursued MCA degree but didn’t get any job at his hometown. So he came down to this city of dreams. But again his face was holding him behind. He knew that the treatment for this disease is possible but he had no money. He started his career with developing small web pages for small organizations. Gradually he started getting good offers and after so many hardships he earned a place in a reputed IT company. But here also the discrimination followed. He was now more focused on his transformation. Treatment brought good results for him and his face was improving but all this didn’t come so easy. He had to undergo severe pain. But on practical grounds things were still the same. He had no friends in the company. Moreover he wanted everyone’s attention. He thought he will achieve this but he could never make it in the traps and tricks of this industry. He was disappointed, heart broken…All his hopes were on the final surgery which was to happen next week. He had his plans after that. From a long time he had hidden love for his colleague. He always used to see her from a distance but never had enough heart to talk to her.
Finally the surgery was over. He took rest for one week. When he saw his new avatar in the mirror he was overwhelmed. He rushed to his love to confess how much he loves her. But she reprimanded him. She called him ugly and asked him to remain in his limits. This offended him to the core. He was devastated. All the anger, insult within him was eager to come out. And in this frustration he committed this heinous crime. He was not a bad man but at that moment of time he was worst. He was even worse than an animal. I realized that no person is good or bad but sometimes he becomes devil.
I also read the confession letter what he has written to his God. I think he has done all this to get the attention of the world which he was deprived since his childhood. I was not able to decide who was more guilty, he or the society. Who was more ugly, he or the society??? His action cannot be condoned but is this society forgivable? He has dishonored his love whatever may be the reasons; no one can justify his act. But I had to think again “should he be given death sentence”?
I felt that this will be infact good for him to hang him because even left free after 14 years of imprisonment; he won’t be able to survive. His soul will again and again raise questions to him. Will he be able to bear the pain for his entire life?
I sighed “May this society give something back in form of death sentence to this “Dog of lesser Gods” and I set fire to all the stuff.
Monday, July 20, 2009
Colours of Friendship
Colours of Friendship
“Dring”..” Dring”….the usual ring of alarm broke the silence of the dawn. I woke up and stopped the alarm. I was feeling lazy enough to go to gym. So decided to sleep more what I do more than often. I was still thinking about her. So going to gym was not promising me either. I had talked to Kashish last night about her. She encouraged me to take the first step on this friendship day. I thought sleeping little bit extra will help me in recollecting the necessary guts.
“Wake up man and lets go for Gym” screaming like anything Niket came and shaked me off. “Not coming …baby…m not feeling well” I replied pretending if I was really ill. “F off” he said showing his middle finger. I know he was abusing me thoroughly but who was cared. I was still in my wonderland.
It was shiny morning. I woke up in a flash soon the sunrays fall on my face through the window. “Oh my God..I am late . Its already 8:29 am. What a big duffer I am” I yelled at myself. I never wanted to reach office late . So I took my bath and rushed to the office. Anyhow I managed to reach before ten. The First thing I did after getting into my office was to take the blank papers from the printer. It was a kind of routine for me to go and check the printer if it is running. Actually It was my way to have a glimpse of her . I didn’t found Nishi at her place. My eyes were looking for her as if I was searching a diamond pendant from the heap of straw. Of Course for me she was more than a diamond. I came back to my seat little disappointed. I couldn't engage myself into anything. Frustrated I took the bottle and went to the water cooler to get some water. My goodness, she was there. I was not able to breathe. I smiled at her but she moved away looking towards the ground. I never knew the reason but this demoralized me from the core.
It was lunch time and I was not feeling like taking lunch. Even himal and Kashish were not coming for lunch. I declined to join my team for lunch but the hope of seeing her again made me not to do so. Alas she was there with her friend (Langoor , My friends call him). My eyes got broaden as soon as I saw her but to my disappointment she left without noticing my presence. The day was turning out to be very inauspicious for me. Suddenly I remembered today is solar eclipse..surya grahan what we call it in Hindi… This made me more hesitant from inside. Halfheartedly I returned back to work.
I told Kashish about it. We had already discussed about all this last night. The more she was excited about all this, the more gloomier I was. Nevertheless we all were set to inform my feelings about her. But something was stopping me from behind. She took the control of my system and wrote something on IM. It was her name on the receiving end…and the message was “Hi” with a smiley. I went paralyzed after that. I didn’t have any clue what to do. “Damn It” you just messed it all. I waited for her reply but she didn’t show up. Kashish was equally in panic but tried to handle the situation. She added “seems u r busy. Just Wanted to wish u Happy Friendship day in Advance. Have a nice weekend. Bye”. I was shivering as my body temperature was creeping up. I saw everything getting vanished in front of me. Soon I realized there is nothing to vanish since nothing is there in real. I smoothened myself and went to play football to just get out of what has happened just now. I was targeting the football hard as if it was the only root of all my worries.
Opponent was comparatively weak and we crashed them by 7-2. I scored 4 goals on a trot and this made me feel better. On the way back home I was thinking about the day what went wrong. I wished If Nishi would be watching my football game. Finally I reached home and threw my cell phone on the bed and went to terrace. Some bitter moments of my Life passed by my mind. To get rid of them, I planned to watch a movie. I went downstairs and was all set to watch “Kagaz ke Phool”. Suddenly I saw my cell phone, a message was from kash.
“Sorry for What I have done today. I thought you were all set to propose her. Sorry Again Fattoo”. I rehearsed her words again. “Fattoo”…I asked myself “AM I FATOOO”…several times…and the thousands of replies came yes you are..yes you are…..I laid on bed…and lost into the trap of sleep…
“Dring”..” Dring”….the usual ring of alarm broke the silence of the dawn. I woke up and stopped the alarm. I was feeling lazy enough to go to gym. So decided to sleep more what I do more than often. I was still thinking about her. So going to gym was not promising me either. I had talked to Kashish last night about her. She encouraged me to take the first step on this friendship day. I thought sleeping little bit extra will help me in recollecting the necessary guts.
“Wake up man and lets go for Gym” screaming like anything Niket came and shaked me off. “Not coming …baby…m not feeling well” I replied pretending if I was really ill. “F off” he said showing his middle finger. I know he was abusing me thoroughly but who was cared. I was still in my wonderland.
It was shiny morning. I woke up in a flash soon the sunrays fall on my face through the window. “Oh my God..I am late . Its already 8:29 am. What a big duffer I am” I yelled at myself. I never wanted to reach office late . So I took my bath and rushed to the office. Anyhow I managed to reach before ten. The First thing I did after getting into my office was to take the blank papers from the printer. It was a kind of routine for me to go and check the printer if it is running. Actually It was my way to have a glimpse of her . I didn’t found Nishi at her place. My eyes were looking for her as if I was searching a diamond pendant from the heap of straw. Of Course for me she was more than a diamond. I came back to my seat little disappointed. I couldn't engage myself into anything. Frustrated I took the bottle and went to the water cooler to get some water. My goodness, she was there. I was not able to breathe. I smiled at her but she moved away looking towards the ground. I never knew the reason but this demoralized me from the core.
It was lunch time and I was not feeling like taking lunch. Even himal and Kashish were not coming for lunch. I declined to join my team for lunch but the hope of seeing her again made me not to do so. Alas she was there with her friend (Langoor , My friends call him). My eyes got broaden as soon as I saw her but to my disappointment she left without noticing my presence. The day was turning out to be very inauspicious for me. Suddenly I remembered today is solar eclipse..surya grahan what we call it in Hindi… This made me more hesitant from inside. Halfheartedly I returned back to work.
I told Kashish about it. We had already discussed about all this last night. The more she was excited about all this, the more gloomier I was. Nevertheless we all were set to inform my feelings about her. But something was stopping me from behind. She took the control of my system and wrote something on IM. It was her name on the receiving end…and the message was “Hi” with a smiley. I went paralyzed after that. I didn’t have any clue what to do. “Damn It” you just messed it all. I waited for her reply but she didn’t show up. Kashish was equally in panic but tried to handle the situation. She added “seems u r busy. Just Wanted to wish u Happy Friendship day in Advance. Have a nice weekend. Bye”. I was shivering as my body temperature was creeping up. I saw everything getting vanished in front of me. Soon I realized there is nothing to vanish since nothing is there in real. I smoothened myself and went to play football to just get out of what has happened just now. I was targeting the football hard as if it was the only root of all my worries.
Opponent was comparatively weak and we crashed them by 7-2. I scored 4 goals on a trot and this made me feel better. On the way back home I was thinking about the day what went wrong. I wished If Nishi would be watching my football game. Finally I reached home and threw my cell phone on the bed and went to terrace. Some bitter moments of my Life passed by my mind. To get rid of them, I planned to watch a movie. I went downstairs and was all set to watch “Kagaz ke Phool”. Suddenly I saw my cell phone, a message was from kash.
“Sorry for What I have done today. I thought you were all set to propose her. Sorry Again Fattoo”. I rehearsed her words again. “Fattoo”…I asked myself “AM I FATOOO”…several times…and the thousands of replies came yes you are..yes you are…..I laid on bed…and lost into the trap of sleep…
Wednesday, July 15, 2009
A Perfect Valentine
A Perfect Valentine
It was Valentine Day again.....Thousands of hearts break...Hundreds of hearts make....
I had no idea what will happen to my heart…make or break……But at the end of the day...What happened…It was a nightmare…I never knew it could be so devastating….
Last week I came across a question:
What is more unfortunate?
a) One sided love that is unsaid.
b) Two sided love that is unsaid.
c) One sided love that gets rejection.
d) Two sided love, which ends in a break-up.
e) Two-sided love where one person betrays the other.
f) No love.
I gave a thought but then I couldn’t come up with a conclusion. However I had already planned for this valentine.
Since last year October I know her. She had just come out of a relationship. Although it was a very brief one but it had left impressions on her. Even I had faced breakup in May and that had devastated me to the core. Though her breakup was more recent one, but still she always looked more balance than me. Perhaps girls very quickly take hold on their emotions…even if not they hide it very well…This is not the case with Guys…they always look to fill the absence with someone else. I guess the same happened to me.
I used to share everything with her and even she was no different. But every time we talked, her past was a major part of the discussion which I always used to refrain. I always used to pour my affection on her but she always used to draw a line. I can see very clearly that her past is taking toll on her even if she is not showing this to world. I had seen into her eyes the fear to get into any other relationship and my motive was to remove this.
I wanted to celebrate my valentine day with her. So I thought of proposing her on the eve of it. My plan and intentions were clear to me.
12th February, 2009:
I bought a valentine card, and wrote my emotions on it. I didn’t write my name on it since I wanted to create suspense. Rather I took a Cadbury chocolate and tore the packet. On the wrapper I wrote “I love you” all over. I also jotted my blog site where I had published a poem for her. I put the chocolate inside and sealed it very carefully making sure that no one can trace if it was torn. I was damn sure that once she will read the poem on that blog, she will understand who is behind all this. It seemed to me a perfect plan for a perfect valentine. I wrapped the card and chocolate with a gift paper and put it into refrigerator to ensure that chocolate will not melt till morning.
13th February, 2009:
In the morning when I woke up at 5:30 am, power was gone. I rushed to the fridge to see if chocolate is alright. I was relieved to see it in perfect shape. I had to take bath with cold water. But anything for you my sweetheart I thought in my own. I dressed up quickly and moved to the bus stop. Not a single cab show up going to phase II. I consoled my heart “No pain No gain”. I took a cab to phase I and then luckily got a bus to phase II.
I was overwhelmed after reaching at my destination. From there I had to go to SDB6 2nd floor. In a flash I reached there but to my disappointment it was an ODC. I got panicked but didn’t lose my heart. I asked the security lady to please allow me inside to keep this at her desk. But she was adamant enough. I tried all my tricks on her but all in vain. I never knew the start will be so bad. I kept the gift pack with the securities main gate. I had to write her phone number on the pack but my cell was switched off. I wrote some arbitrary number on that. With a heavy heart I came back to phase I.
At 11:00 am, I asked my friend to call her up and ask her to collect the gift from the main gate. After half an hour she ping me back. My fingers were crossed. She asked “what was this prank all about?”
I replied”Do you feel this was a prank?”
She said I knew it was you. So I tried to call you from the gate but you cell was not reachable.
I was much relieved seeing her so relaxed and calm. I found myself on seventh heaven.
In excitement I asked “Did you like the card?”
She exclaimed “Card???? Which Card???”
I was all shocked. I controlled myself and asked “Didn’t you ask the security person about the gift pack”. She said I thought it was all a prank.
I got aghast at this. I asked her to go and collect it.
And it was just a start of the night mare. She opened the card read it and lost her temper. She didn’t even open the chocolate pack and threw it in dustbin. There was no question of reading the poem. She soon called me up and poured all her anger on me. I just listened to everything she said and thought that I will justify her in evening after office hours.
But it was too late. She had removed me from her communicator. I called her in evening but she didn’t pick the call. Moreover she sent me a SMS “Don’t spoil my mood by calling me or messaging me. I thought you are my friend. I don’t want to speak to you.”
Everything went wrong for me. I lost a good friend of mine. Then only I realized:
What is most unfortunate is:
To propose your friend and that ends with a broken friendship rather than a new relationship.
14th February, 2009:
I closed the doors and windows of my house. I watched all the saddest movies I have in my kitty. Kagaz ke phool, DevDas, Khamoshi(old)……..
At the end of the day I realized It is not the end of the world…and It is not the end of my life and Moreover it is not the end of the girls…
15th February, 2009:
I started my day with Andaz apna apna, Angoor and then Herapheri…….
So all in all it was a perfect valentine for me. I saw all the emotions of life..not only saw but lived it.
For You, My Love
I always dreamt of the One ...........
hanging around with whom will be fun..
She entered my life, my wishes were done..
but she left me alone in the long run...
Did not imagine I could be so pleased..
I searched so long through the deep sea blue..
I love you my baby, my prize is you..
hanging around with whom will be fun..
She entered my life, my wishes were done..
but she left me alone in the long run...
My eyes were moist and heart was sad..
emotions were dry and experience was bad...
soon i saw a girl who went through the same..
but on her face, no trace of pain...
Quite often she used to take his name...
what I always used to refrain..
within inside she has overcome all in a flash
I still wonder why I am living in a trash...
previously she was a chatterbox and so was I
she is still enthu but I am dry..
One day I felt she is the one..
my heart always looks for whose tantrum..
I always try to go forward and say...
I love you my sweetheart in every fray..
but her love for him holds me behind..
though to me she is considerate and kind..
Every now and then she talks about some one..
all are her friends, one of which is very handsome..
the other one is a master at music..
she says one day he will go to Zurich..
One has got very good GRE score..
one is technically strong at the core..
One is at the P.A level..
and the other has got master's label..
One she knows since her childhood..
One she feels was the college dude..
One she got in her training batch..
and I am the one she got in her recovery patch..
One is her training teacher..
who has got some special features..
She says he is her big time crush...
and my feelings gone into flush..
All the friends are dear to her...
All the friends are near to her..
Only guy who feels left out is me..
Only one whom she doubts is me..
I know I don't have any qualities to impress...
as she says you even don't know how to dress..
But why to learn if you are always there...
I want you to love me in every flair...
I love you more than you know...
I will keep loving you till next row..
I want to let you know for sure..
My love for you is genuinely pure..
Only one thing I have realized till date...
I love you deep even if you are not my fate..
But some day I am sure my luck will change..
Destiny will bring you for my arrange....
Did not imagine I could be so pleased..
I searched so long through the deep sea blue..
I love you my baby, my prize is you..
I am an Indian first
I am an Indian first
Last week I was travelling by train. One fellow passenger asked me about my permanent address.
PERMANENT ADDRESS….!!!.......I thought for a while….but couldn’t get an answer.
Often we need to fill permanent address in various forms. It often brings me in great dilemma. I always ask myself. Is there any PERMANENT ADDRESS?? And I never get a reply.
Recently one decent person called few people of this country as Bihari’s and asked them to move from his territory. He accused them for being Non-Marathi. This incident soon became a political drama and all the political parties made a big hue and cry to take the advantage of the situation. These incidents really sadden me. How can I say that I am not from the village I was born and not from the town I studied and not from the city that provided me my living. It is not possible for me to forget any place which has contributed so much to my life. All the places are equally close to my heart.
I was born and brought up in BIHAR. So for convenience I can call it my birth place. In my childhood I played in the soil of the fields. All the villagers used to treat me as dulara son. The sweetness of their love and affection is still with me. Even now when I go back to the village it seems the trees on which I played in my childhood have spread their limbs to welcome me.
I was brought to Bokaro Steel City, Jharkhand for my primary education. There in my school I was famous for my naughtiness. Every other day I could be spotted standing out of my class punished. How can I forget the cane of sharma sir which I was most afraid of . It is not possible for me to say that I don’t belong to this place which made me learn the meaning of basic education. In my Kendriya vidyalaya days as a part of “Teach the Kids in rural areas” campaign I went to Orissa. In a small village Chilpuda in Jharsuguda district, children had never seen a teacher. I stayed there for two weeks . How can I forget them calling me “Master Saheb” in their fainted voice? The villagers see me with respect and often bring some species of fruits I had never tasted before. I can never forget those white berries an old man brought for me as his regard. I would feel proud to say that I belong to this place.
How can I deprive myself from saying that I don’t belong to Sangli, Maharashtra where I spent four years of my engineering life. It is the place which gave meaning to my existence. It is the place where I shaped my career. The sweetness of sugarcanes and grapes from the fields near my college campus is still with me. The peasants used to offer us whenever we go there. In my college I was part of Rotary Club and for General Awareness regarding Cleanliness I went to Margaon, Goa. In a very short span of three days it became an integral part of my life. I found there so nice and humble people. They listened to us carefully and pledged to spread the awareness to others.
Karnataka has got always a special place in my heart. I was in Mysore and Bangalore for few months. I got my love at this place that I can never forget. Though she is no longer with me but this place made me learn different aspects of life. Someone picked my pocket at bus stand in Mysore. How rest of the passengers helped me out will be memorable to me throughout the life.
For official reasons I had been to Hyderabad, Pune. I am all obliged to the people of these places who were so nice to me and never let me felt out. These people made me realize that I belong to them. I belong to each and every place of India. All these places whether it is Bihar, Maharashtra, U.P, Karnataka… are integral part of India. All these places made me understand our culture and heritage in their very special way. These places made me understand the meaning of “Unity in Diversity”. All these places contributed some Indianness in me.
Finally I got my answer…….that even so loud………
I am an Indian first.
Last week I was travelling by train. One fellow passenger asked me about my permanent address.
PERMANENT ADDRESS….!!!.......I thought for a while….but couldn’t get an answer.
Often we need to fill permanent address in various forms. It often brings me in great dilemma. I always ask myself. Is there any PERMANENT ADDRESS?? And I never get a reply.
Recently one decent person called few people of this country as Bihari’s and asked them to move from his territory. He accused them for being Non-Marathi. This incident soon became a political drama and all the political parties made a big hue and cry to take the advantage of the situation. These incidents really sadden me. How can I say that I am not from the village I was born and not from the town I studied and not from the city that provided me my living. It is not possible for me to forget any place which has contributed so much to my life. All the places are equally close to my heart.
I was born and brought up in BIHAR. So for convenience I can call it my birth place. In my childhood I played in the soil of the fields. All the villagers used to treat me as dulara son. The sweetness of their love and affection is still with me. Even now when I go back to the village it seems the trees on which I played in my childhood have spread their limbs to welcome me.
I was brought to Bokaro Steel City, Jharkhand for my primary education. There in my school I was famous for my naughtiness. Every other day I could be spotted standing out of my class punished. How can I forget the cane of sharma sir which I was most afraid of . It is not possible for me to say that I don’t belong to this place which made me learn the meaning of basic education. In my Kendriya vidyalaya days as a part of “Teach the Kids in rural areas” campaign I went to Orissa. In a small village Chilpuda in Jharsuguda district, children had never seen a teacher. I stayed there for two weeks . How can I forget them calling me “Master Saheb” in their fainted voice? The villagers see me with respect and often bring some species of fruits I had never tasted before. I can never forget those white berries an old man brought for me as his regard. I would feel proud to say that I belong to this place.
How can I deprive myself from saying that I don’t belong to Sangli, Maharashtra where I spent four years of my engineering life. It is the place which gave meaning to my existence. It is the place where I shaped my career. The sweetness of sugarcanes and grapes from the fields near my college campus is still with me. The peasants used to offer us whenever we go there. In my college I was part of Rotary Club and for General Awareness regarding Cleanliness I went to Margaon, Goa. In a very short span of three days it became an integral part of my life. I found there so nice and humble people. They listened to us carefully and pledged to spread the awareness to others.
Karnataka has got always a special place in my heart. I was in Mysore and Bangalore for few months. I got my love at this place that I can never forget. Though she is no longer with me but this place made me learn different aspects of life. Someone picked my pocket at bus stand in Mysore. How rest of the passengers helped me out will be memorable to me throughout the life.
For official reasons I had been to Hyderabad, Pune. I am all obliged to the people of these places who were so nice to me and never let me felt out. These people made me realize that I belong to them. I belong to each and every place of India. All these places whether it is Bihar, Maharashtra, U.P, Karnataka… are integral part of India. All these places made me understand our culture and heritage in their very special way. These places made me understand the meaning of “Unity in Diversity”. All these places contributed some Indianness in me.
Finally I got my answer…….that even so loud………
I am an Indian first.
Always give a try.............
Mai apne aap ko pahchanta kaise,
ke aine the mere ghar me bahot;
kya hun, kyu hun ye janta kaise,
ke aine the mere ghar me bahot....
ke aine the mere ghar me bahot;
kya hun, kyu hun ye janta kaise,
ke aine the mere ghar me bahot....
The energy to win and the fear to lose both resides in the human mind. The feeling which supersedes the other makes the outlook of the person. We see the obstacles in our way only when we keep our eyes off the goal. Often we presume that we cannot do this, and we never give a try. But I say Always give a try since if you win you will be happy else you will be wise.
If you will turn down the pages of history, you will find all those names there because all of them tried the things out their way. It was never a one time effort but it was a constant effort, effort to stand again and give a try. This never die attitude should be there in every individual.
I believe that 25% of our problems will be solved by giving one more tries to the problem. It’s the presumption that it will not happen stop us from trying and finally eliminate all the possibilities of its happening.
I will give you a small example.
Last week when I switched on the television to watch India-West Indies one day series, I was disappointed to find that TenSports is not activated on my set up box. So I straightly went down to the retailer to get it activated. On the way I thought of checking once if it is coming on National. But as always, that presumption came into my mind. “DD does not telecast even the cricket played in subcontinent how can I expect a series from West Indies. I got TenSports recharged for myself for Rs.100 for 4 months (was not available for less than this).After few days I discovered that the series is getting telecasted on DD as well.
Smart people learn from their mistakes and smarter ones from others mistake. I didn’t make the same mistake again. Santa Singh will say it means you checked DD every time before you made any recharge. It is not like that way. I learnt to give a try before assuming any thing.
Last month I vacated my rented house. One of my friends shifted at that place. I was paying 3.5K per month including all the charges. My friend is paying 3.7 K per month, Rs.200 for electricity charges for the same house. He called me one day and told me about this. I thought of giving a try to convince the owner. I called him up but to my disappointment he said the rent was 3.7 from the beginning. So there is no question of reducing it. I was feeling bad, not because he was not convinced but because his version proved me a liar. I called him again and asked him to check the agreement papers since rent is mentioned there. In a minute he called me back apologizing for the mistake. He reduced the rent for my friend from that very month.
Santa Singh will again say “huhh how does it help in a bigger picture”.
I agree that these are very small examples from daily life. But giving one more try always helps. I preach this philosophy to every one. I know that every body already knows about it but nobody cared. One of my friends not only followed this but also got success.
You won’t believe that he proposed a girl for 10 times. All the time she rejected. He came to me saying that your philosophy is crap. I asked him for one more time.
And today they are happily married couple. She asked me why you suggested him to give a try more.
I replied “Each time when he came back to me empty handed, I saw even more determination to get you. I never wanted to let that flame in his eyes die”.
Subscribe to:
Posts (Atom)