# Tuesday, September 30, 2003

Debugging DTS Packages

 

You haven’t really experienced sheer hell until you have to debug a DTS package. SQL Server development is something completely different from the traditional 4GL languages like VB and C#, you have to think in rows and columns and joins. A lot of 4GL programmers are forced or simply want to get into writing T/SQL Stored Procedures and realize that it is a whole new ballgame. But one that is easy to master if you put the time in. So a lot of beginning SQL Server programmers who came over from the 4GL side ask me often at conferences, “How do I debug a DTS package?” The answer is “You don’t.” (Oh we are all so spoiled by setting a breakpoint in Visual Studio.)

 

Microsoft has publicly announced some of the new DTS features of Yukon at TechEd in Barcelona and will announce more at the PDC in LA later this month, so I won’t go there and besides Yukon will ship sometime over the rainbow. So let’s start thinking about SQL Server 2000.

 

First off, proper design of your package will only make debugging much easier. Use only Stored Procedures (with or without parameters) and if you have to use SQL dynamically utilize Views. This is because the more dependencies on “real” database objects, the easier it will be to track down your problem. Avoid ActiveX Scripts as much as you can-consider an Extended Stored Procedure that calls a DLL wrote yourself (or call the DLL with a CreateObject in your script if you must).

For the actual debugging itself my advice to you is to take everything in steps. You can run each DTS package’s step individually just by right clicking on it in the designed and selecting “Execute Step” from the pop-up menu.  That is the first part. Then you can deconstruct the step manually and run those pieces in Query Analyzer. (In theory you can debug your stored procedure in Visual Studio too.) From there it gets easier, small bits and pieces of your step may or may not be working, so start looking at your select statements in QA. Before you know it, you will be in DTS debugging heck instead of hell.

posted on Tuesday, September 30, 2003 1:18:06 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [10] Trackback
# Monday, September 29, 2003

 

 

Ok, now that I am home here is the report since I was not able to blog each day.

 

First let me give you the skinny of the plan. The plan was as follows: my buddy Kevin Collins (SQL Server Mobile Edition PM) and I were planning to trek to Mt. Everest Base Camp. Most trekkers hike for 2 weeks and then touch their toe at Base Camp and turn back. Kevin and I wanted to spend some serious time at Base Camp. The problem is that nobody is allowed to camp at Base Camp unless you have a climbing permit and the Nepal government charges $60,000 US for one. Kevin and I are not rich, so what we did was hook up with an Expedition that was going to the summit (they should summit in the middle of October.) So we left the US knowing that we would have a unique experience of being on a real summit expedition and then sleeping two nights at base camp. The expedition was lead by the climbing superstar Wally Berg (4 summits under his belt) and has 4 other clients (including a woman who is going to ski down and be the fist woman to so.) Here is the full story of our three weeks in Nepal (photos up soon, so check this page again in about a week):

 

 

Day 1. “The Talk”

We arrived in Kathmandu and got the talk about the expedition from Wally. Was so cool to hear about his summit plans and how it all works. Being my second time to Nepal, it was nice to come here with a Visa already in my passport this time (note to people who are coming here in the future, get your Visa in advance, trust me!).

 

Day 2. “Burning Dead Bodies”

Today was a rest day and day for others to arrive in Kathmandu, so we spent the time sightseeing Kathmandu. We visited a few sacred Buddhist sights and a Hindu death ritual cremation sight.


Day 3. “Start Walking”

Today we flew a twin otter 15 seat plane to the town of Lulka (9,000’) to begin our trek. The flight was cool and most of the empty seats were filled with our gear and lots of climbing equipment that was going by Yak straight to Base Camp. The airport at Lulka is from the twilight zone since the runway was short and faced totally uphill at about a 75 degree angle, so landing was an experience. From here we begin the trek to Base Camp that is over 60 miles and almost 10,000’ elevation gain away. From Lulka on there are no roads, TVs, phones (land lines, Sat phone only), machinery (all human or animal power) and a very simple way of life in the Khumbu Valley. Some towns have no running water and all supplies are carried by human or yak power.

We trekked for about 3 hours down to the town of Phakding (9,500’) over beautiful waterfalls and mountain views.

 

Day 4. “Running with Sherpas”

Today we trekked from Phakding (9.500’) to the major town (maybe 100 buildings) of Namche Bazar (11,500’). Since I was feeling in such good shape I went ahead with two sherpas (Our Sirdar and Camp II Cook) and a climber. They travel very fast, but at this elevation I am not worried about getting sick. Our Sirdar wanted to hear all about New York. We trekked fast and cleared Namche hill very fast and got to Namche very early and spent time in a tea house cleaning up, doing laundry and took a shower!

 

Day 5. “Glacier Melt”

Today was a rest day for acclimation to the altitude. It was spent trying to use the internet over a Sat phone (a very painful experience), hiking up the hill to see our first glance of Mt. Everest and eating “Glacier Melts” in the Khumbu Lodge. (A glacier melt is a deep fried Mars bar.)

 

Day 6. “Sherpa Home”

Today we hiked from Namche to Pangboche (12,700’) and stayed at our Sirdar’s home. Once again I am ahead with the sherpas and faster climbers, but while I got to the destination early, I was pooped, so decided to stick with the main group from this elevation on.

 

Day 7. “Blessing by a Lama”

Today we were blessed by a Lama at the Pangboche Monastery in a delightful ceremony. It was so unique since he blessed the climbing team for their climb and we got to witness that part too. Maegan who is skiing down the mountain had a very moving experience when the Lama spoke directly to her-which affected us all.

We then trekked on to Pheriche (14,000’) over some great hills with views of all of the Himalaya. From the next 8 days or so, I spend over 14,000’, higher than almost anything in the Continental United States.

 

Day 8. “Please don’t Hypnotize me to have Sex with Yaks”

An overnight rest day for acclimation so pretty much dominated by some Frisbee games and a hypnosis session led by the climber David Burger. I was joking that can he hypnotize me to spend less time thinking about the opposite sex and someone suggested that I get hypnosis to start liking Yaks. (Sorry Dennis, I still like girls.) We start to test our Oxygen levels in our blood, I come in at about 86%, which is great for 14,000’ but would put me in the Intensive Care Unit at Sea Level. My body is doing great with the altitude.

 

Day 9. “Too Many Deaths”

For every 6 people who summit Everest, 1 dies. Today we visited on the trail from Pheriche to Loboche (16,000) a memorial site for those who died on Mt. Everest. If you read “Into Thin Air”, Scott Fisher’s memorial was quite prominent, he was popular with the Sherpas who made this memorial-and was also Wally’s best friend, so it was a solemn visit. I spend about two hours trekking alone before Kevin catches up with me and all I could hear is the river and my footsteps, I used this time to contemplate life.

Today we also meet Magi on the trail, a random trekker from the United Kingdom who has been traveling around the world for a year.

 

Day 10. “Just What is Spotted Dick?”

Today we trekked to Gorak Shep (16,800’) to stage our assault on climbing the peak of Kala Pattar (18,700’) the next day and then trekking to Everest Base Camp (17,400). We discover a dessert for sale called “Spotted Dick” and Wally asks “Just what is Spotted Dick” which Magi replies that it is a traditional English dessert. Since it is freeze dried, Gary bought some for us to have at Base Camp. Gorak Shep is not really a town, but just two lodges on the side of a river.

 

Day 11. “Game Day”

Today we woke at 4am and started the climb up Kala Pattar at 18,700’ (but my altimeter said only 18,300’). It was a very hard climb, just about a technical climb for the last 100’ or so with 3,000’ drops into Tibet if you slip. We had to crawl over rocks and ice and snow to get to the top. We watched the sunrise and had a spectacular paranoiac view of the entire range. Saw Everest and Base Camp, the Khumbu Icefall, Pumori and Nuptse and most of the other 8000 meter peaks. This was one of the most amazing sights in my life.

We spent the rest of the day trekking over the Khumbu Glacier to Base Camp (17,400’).  The views of the rest of the glacier were amazing, rocks and ice just falling into glacial lakes. It was very slippery to trek over, so it took well over 4 hours. We spent some time viewing the remains of the helicopter that crashed in May 2003, I stole a piece of the debris for a momento. Upon arrival at Base Camp Kevin’s and my tent was on top of a ice and rock pile at the foot dangerous Khumbu Icefall. We got to sleep at night with the constant sound of the glacier moving and constant avalanches (they occur every 20 minutes or so.) What a sound show.

 

Day 12. “Puja Day at Base Camp”

What a day. We spend the day at Base Camp and witness a Sherpa Buddhist Puja to bless the Icefall and climbers. A totally unique experience, the Sherpas will not begin the climb until the Puja is completed. A Puja is a Buddhist religious ceremony. The monk chants paryers while we throw flower and rice and reflect. We all get prayer strings blessed by the Dali Lama.

It gets so hot that Kevin sneaks a photo of me walking around Base Camp shirtless trying to get a tan (which resulted in a massive sunburn). My body is feeling great that I did not realize I was spending the entire day at over 17,400’ on top of a glacier and at the foot of the largest icefall in the world.

Since we were the only climbing permit, we not only have base camp to ourselves, but all of our Sherpas are the cream of the crop. It was so educational and moving to talk to them and learn about the 1996 tragedy first hand (many were there).

Gary, Maegan, Grant, Ama Timber, the dog and I eat the spotted dick after supper.

 

Day 13. “Snowball Fight at the Top of the World”

Today we wake up to 6+ inches of snow at camp and have a snowball fight with the sherpas. Too bad, but we do have to leave Base Camp today, after 3 days and two nights there. We trek 6 hours through the snowstorm and over the icy glacier all the way back to Loboche (16,800’). I got very friendly with the climbers and it was hard to say goodbye. I lent my gloves to David and he is going to wear them on summit day and Meagan scored my down jacket to leave at Camp II.

 

Day 14. “I need a new Sherpa”

Today we trek down from Lobache back to our Pangboche (12,700’) and I was feeling so good that I decided to race my sherpa a few times at 15,000’ without packs and WON. Kevin and I were so strong that Nima our Sherpa was worn out (we have photos to prove this.) The air is still feeling very thick.

 

Day 15. “Hillary School

Today we trek down to Kumjum (12,500’) and visit the Hillary School and take lots of photos with little kids. Today it hits me why I came here in the first place, seeing these kids with nothing, but just so damn happy.

 

Day 16. “Back to Namche”

Today we walk down to Namche Bazar and rest at 11,500’. Do some shopping for prayer flags and other fun stuff. I made an attempt to check my email on the sat phone computer and it was bad, very bad.

 

Day 17. “Back to Lulka”

Today we did a long haul all the way back to Lulka. It starts to pour but the return to Lulka was glorious, all the porters were with me and singing “Do a little dance, make a little love, get down tonight.”

 

Day 18. “Waiting for the Fog”

Totally fogged in at Lulka, no flights allowed in our out. The military has a curfew of 6:30pm due to the Maoists rebels and walks around with machine guns pointed at you. We comply with the curfew.

 

Day 19. “No Woman No Cry”

More damn fog. I am starting to lose it until we discover happy hour at the one local bar that also has a pool table and a bartender who will do anything I say (including playing Bob Marley’s “No Woman No Cry” 4 times in a row). I beat Dennis at 9-ball and also get incredibly drunk. I also get Mihn Sherpa very drunk, hard drinks were 2 for 1 and about $2-so $1 shots basically-you do the math. Getting super drunk at about 10,000’ is fun.

 

Day 20. “Back to Kathmandu-More dangerous than Everest”

We finally make it back to Kathmandu on the only flight in and out of Lulka for the last 3 days. They also close the airport just after we leave, so we are so lucky. Get to see the first road and car, etc in Kathamndu, however there is a Maoist revolt in Kathmandu and yet another curfew, men with machine guns, etc. This time there are battles with the good guys and bad guys and stuff gets blown up and power constantly goes out. No cars on the streets. Our van that picks us up hides their liscence plates (so the Maoists won’t know who they are) and spray paints “Tourists” on the car, not sure if this makes us a target of snipers or not. We survive and fly off to Delhi the next day.

 

 

 

 

 

posted on Monday, September 29, 2003 3:37:29 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [9] Trackback
# Sunday, September 28, 2003

Back Home!

Finally home. No place like it.

posted on Sunday, September 28, 2003 3:30:08 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [16] Trackback
# Friday, September 26, 2003

Time Zones and Tour of Delhi

Ok, so Jack, Linda and Kathleen call me on my cell phone from New York City last night, knowing full well that India is 9.5 hours ahead of New York waking me up around 5am from my nice alcohol induced sleep. They must die.

Back in Delhi, India rocks. With very little sleep, we visited the India Gate, a memorial to the WWI soldiers, the Presidential Palace and Parliment (where the recent terrorist attacks were) and the Gandhi Samadhi (site where he was cremated), and the center of the Islam period the Qutab Minar.

After I went and spent over $1,000 on a 100% hand made rug from Kashmir. It had to be the lack of sleep since I don't even have a home to put the rug it, so Jack/Kathleen/Linda, expect a bill. I did buy 7 CDs of local music for about $10 and treated myself to a haircut and a pedicure (my first ever) since my feet for a mess from the trek for around $1, so maybe it all balances out. :)

Going out tonight with Karishma, her cousin (who leaves for London Business School tomorrow) and Magi (random trekker from the Nepal) for a night of sin-so guys I challange you to call me again...

posted on Friday, September 26, 2003 4:11:10 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [1] Trackback
# Thursday, September 25, 2003

Magi Arrives

Magi, the random trekker from Nepal has arrived in India. She will sightsee with me tomorrow. She was a random trekker that we picked up on the trail in Nepal and had to stay the night at Base Camp due to a snowstorm.

posted on Thursday, September 25, 2003 7:48:55 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [10] Trackback

Rajasthan Rocks

 

The last day of our road trip brought us to Jaipur, the capital of Rajasthan. What a great place, spent the day looking at palaces, a “Wind” Palace that is designed to keep the people cool by creating a natural air-conditioning, it was built in 1799. Then the city palace and some forts to guard the city. Rajasthan still has a king, though only ceremonial. Visited the museum he set up on his residence and saw artwork and armor, including the world’s largest wheeled cannon. We ended the day with about 3 hours of shopping for artwork-Kevin and I have helped the GDP of India with our art purchases..

posted on Thursday, September 25, 2003 4:22:51 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [12] Trackback
# Wednesday, September 24, 2003

McAloo and the Taj Mahal

 

Kevin and I kidnapped Karishma, dragged her kicking and screaming out of Microsoft and took a 3-day road trip on the Indian “Golden Triangle” down to Agra (Taj Mahal) and Jaipur (lots of Palaces).  At the Taj, it cost Karishma about 50 cents to get in (being an Indian) and for us "white people" Kevin and I cost about $15 each. So we took turns at the rest of the attractions pretending to me married to her. :) Turns out that there was suppose to be a second Taj, all back for the king, but he was arrested before he could build it by his cheapie son.

 

Driving in India is a trip: mass chaos, oncoming traffic, dust, people, bikes, cows, scooters, and more mass chaos. Plus they drive on the "wrong" side of the road, which really dosen't matter since the concept of a lane has not made it to India yet. They actually have a road sign that says "Please drive on the correct side of the road."

 

We stopped at a tin ruf, mud floor roadside café and it rocked the house, the three of us ate for about $1-and it was the best Indian meal I ever had. Along the way we also stopped at a McDonalds just to see the 100% vegetarian menu and I had a "McAloo" (or potato patty with super cool spices) that was an experience.  

posted on Wednesday, September 24, 2003 2:48:31 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [12] Trackback
# Monday, September 22, 2003

Hari Krishna and a Traditional Indian Dinner

I am sitting in the Microsoft Office in Delhi, India after a great afternoon and evening yesterday. Kevin and I landed in Delhi and Karishma took us to the the Lotus Temple and the ISKCON (International Society of Krishna Consciences) Temple while a Puja was going on. The people at the Puja was so inviting and the Hari Krishna singing and dancing was totally awesome. A truely unique experience.

After that we went to Karishma's Aunt and Uncle's house and had a typical Indian meal and stayed up late talking and catching up. Oh boy did I eat well!

 

.

posted on Monday, September 22, 2003 4:04:57 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [13] Trackback
# Sunday, September 21, 2003

Well the Maoists and 3-day general strike is over but it left Kathmandu a mess. At least two bombs went off yesterday and power was lost several times. The Army was all around the city all day today. Garbage and such is everywhere.

Well the trek to Everest was not as dangerous as the Maoists in Kathmandu, except for a sivere sunburn and about 22 pound weight loss I am fine. No altitude sickness (only went under 19,000') and no "runs" or anything like that. I did accidentally delete all the messages in my inbox, so I have no idea who sent me email when I was away. Oh well, ORCSweb Team to the rescue (Like always)!

Off to India, more on the trip soon!

posted on Sunday, September 21, 2003 5:43:53 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [24] Trackback
# Saturday, September 20, 2003

After 21 days of hiking in the fresh air without hearing any automobiles or seeing any paved roads, phones, electricity and all work was done by human power or animal power, it was kind of strange getting back to the busy city of Kathmandu today to witness a 3-day general strike. 2.2 million people live here but a general strike because of the Maoist rebellion has reduced the city to a standstill, no cars, and sometimes even no power.

Soon I will be reunited with my laptop and have a high-speed connection in India, move news to come...

posted on Saturday, September 20, 2003 8:12:05 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [14] Trackback
# Tuesday, September 16, 2003

Snowball Fight at the Top of the World (17,400')

We all made it and are feeling great. Summited Kala Patar at 18, 500' and went to Base Camp (17,400'). Spent three days and two nights at Everest Base Camp. Before we left, out last morning we had 6 inches of new snow and the sherpas (16 of them!) attacked us in a snowball fight, it was not pretty.

Internet sucks, so more detals later in the week...

posted on Tuesday, September 16, 2003 5:50:36 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback
# Friday, September 05, 2003

Rest day at Namche Bizarre (11,500')

We arrived yesterday at the sherpa village of Namche Bizarre and today is a rest day to deal with the altitude. Civilization, sort of, shower, internet (dial up speeds) and a warm bed to rest up for the push to base camp. Tomorrow we head to higher elevations well over 12,500' and eventually to 19,000' over the glaicer down to Base Camp (17,500') next week.

We did an early morning stroll to the outskirts of town to see the spactular mountaion views (photos to come when I get home) and got the first glimpse of Everest today, what a sight. We are still about 5 or 6 days out, depending on how strong we all are.

Wally got the permit to summit (at $60,000 US) for the climbers, so they are very excited it is a very special time, since we are the only expidition on the mountian with a summit permit. Since Wally has a permit, Kevin and I get to spend some significant time at Base Camp and witness the Sherpa Puja at the icefall on September 12th.

 

posted on Friday, September 05, 2003 5:01:24 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [3] Trackback
# Tuesday, September 02, 2003

Dinner at Rum Doodle (4,500')

So many Everest summit trips have a farewell dinner at the Rum Doodle the night they leave Kathmandu and we are no different. A great night was had by all and we leave tomorrow to start our trek. I am all packed and ready to deal with the altitude, etc. Wish me luck!

posted on Tuesday, September 02, 2003 3:31:17 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback
# Monday, September 01, 2003

 Staging in Kathmandu (4,500')

Wally met with us today for the “talk” about the ins and outs of the expedition. Also met the climbing sidar Sherpa today, a very impressive man who has summitted 4 times. We fly to Lukla Wednesday to start the trek. We will be arriving at Mt. Everest Base Camp on September 11th, a strange day to make it there. A Buddhist ceremony early in the morning on the 12 marks the official beginning of the ascent for the rest of the team. Kevin and I will be spending at least 2 nights at Base Camp helping the expedition get settled in.

Here are the climbers bios:

Wally Berg, Canmore, Alberta

A four-time Everest summitter, Wally Berg is BAI’s founding director and head guide. His achievements in planning, organizing and guiding successful mountaineering expeditions have established him as one of the world’s foremost expedition leaders.

David Burger, Boulder, Colorado

David Burger has guided throughout the world for decades and has climbed to above 6,000m more than 50 times. In 2002, he was part of the successful BAI guiding team on Ama Dablam. When he is not guiding, David is an executive coach and senior team builder.

Maegan Carney, Seattle, Washington

 Two-time World Freeride/Extreme Skiing Champion Maegan Carney aims to be the first American and first woman to complete a ski descent of Mt. Everest. Now making her home in Chamonix, France, her passion is for climbing peaks and skiing obscure, steep couloirs. In 2002, Carney made the first descent of 24,000-foot Cholatse Peak in Nepal.

Brad Johnson, Ridgway, Colorado

Brad Johnson has climbed 25 peaks between 17,000ft. and 27,000ft. high via 30 different routes and summitted Cho Oyu in 1999. He has participated in two expeditions to Makalu and K2. With over 20 years experience as a climbing and trekking guide, Brad spends much of each year leading mountaineering expeditions in Peru.

Garry Porter, Olalla, Washington

Since retiring from Boeing, Garry Porter has dedicated much of his life to mountaineering – and being a grandfather of four! He has reached the summit of Aconcagua, Denali, Cotopaxi, Island Peak, Huayna Potosi, Illimani and Ama Dablam with BAI in 2002.

posted on Monday, September 01, 2003 3:02:27 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [9] Trackback

To The Summit and Safe Return

 

Train Harder. Climb Longer.

 

After more than 8 months of preparation, Kevin and I are in Kathmandu to begin our trek to Mt. Everest. We are waiting for the other 5 trekkers and 4 climbers. (who are going to the top!)

 

To all of my friends and family reading this, you know me well, I will be safe. Thanks for your support. And Dad, one day I will return to this mountain with you.

 

 

 

posted on Monday, September 01, 2003 1:28:18 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [11] Trackback