Posts

Showing posts from November, 2010

SSIS tips and Tricks

Image
Finally a technical article after a reallllly long time............ Tip 1: Ensure that when you fetch data from an SQL server data source always use the "(NOLOCK)" option in the sql statement example: select studentid,name from student (NOLOCK) This ensures that a deadlock does not take place (best option to use in a multi user environment :) ). Tip 2: The maximum packet size that can be transferred across a network is approximately 4 MB. Here we could improve the performance of our data fetch from the source and data migration to destination by modifying the connection property of your SSIS package. Right click on the the connection and click properties, you will find a property called packet size: Make sure this packet size is about 32767 to get the maximum benefit across a network. Tip 3: When you have multiple tasks running in parallel in a package(The maximum an SSIS package can actually subdivide these tasks or SSIS can spawn a maximum of 8 processes), so it would make

Cartoons from the 80's

Just thinking a couple of days ago as to the cartoons that I used to watch as a kid (still watch some of them when I get the time). Cartoons are like a breath of fresh air at times. Man, I used to watch so many cartoons. Here is a list of some that I could remember (I can tell my kids someday that these were the cartoons I used to enjoy watching..... a lot of nostalgia here): 1] Grandizer 2] Thundercats 3] Inspector Gadget 4] He-Man and the masters of the Universe 5] Captain Majid (I used to watch the arabic cartoon version) 6] Swamp Thing 7] Skyhawks 8] G.I.Joe 9] Rambo 10] Mr. T 11] Transformers 12] Banana Man 13] Pink Panther 14] Looney Toons 15] Care Bears 16] Smurfs 17] Voltron 18] Ghostbusters 19] Police Academy 20] M.A.S.K 21] Duck Tales 22] Chip & Dale - Rescue Rangers 23] Dennis the Menace 24] The Racoons 25] Count Duckula 26] Transformers 27] Spideman and his amazing friends 28] Bravestarr 29] TMNT 30] Denver the last dinosaur 31] The Hulk Maybe I should keep posting list