My First Post…

Wow, it's been more than a month since my last post from Sri Lanka. Life has been quite busy and I've been overwhelmed sometimes, but things are slowly falling into place.

After getting to Australia, my first biggest challenge was to find a place to rent. The renting system in Australia is well organized but its extremely difficult for someone who doesn't have a rental reference to get a place. I was lucky, on of my friend's friend called Priyasha drove us around on our first weekend and we ended up being able to just look at one house. As luck would have it no one else applied for the house and we finally got it.

The second challenge was to buy a car. Since my first assignment is at Microsoft Australia's SDC (Software Development Centre), I had to get a car since the public transport up there was not too good. Again Priyasha came to my rescue and we ended up buying the last car we saw that day. The car although old is in much better condition than the one I sold off in Sri Lanka and it cost me only $2,750.

We moved in the week before last and had to go around buying all the stuff for the house. I ended up getting just the minimal stuff like the fridge, washing machine, microwave. It's quite a blur, considering that I spent over a year buying all the household items and that too after doing a lot of research on each item. But here it took us a couple of hours to pick all of the items from the Good Guys store.

Plus when you move into a new house you need to do whole lot of things like getting a telephone line, electricity line, gas line, but since I could do all that over the phone it was quite pain free. I've applied for a broadband line which should be hooked up by next week.

My last post here

Looks like this will be my last blog posting from Sri Lanka. Tomorrow I'm flying out to Australia.

My new job is at Unique World and my first assignment will be on SharePoint. It's going to be tough to move over to a new country, start a new job and in the process a new life. But I'm looking forward to the challenge.

So here goes, you will be seeing a lot of SharePoint stuff on this blog in the coming months so stay tuned!

Migrating

Finally a post after an awfully long time. I'm in the midst of moving my life and twitter too is to blame. In the meantime I have this cute picture of Joshua.

Joshua

Following friends on Twitter

The twitter web UI has a bug when you try to follow friends.

The simplest workaround is to add friends by typing the 'follow username' command in the twitter.com site or sending it as an sms.

Twitter

twitter

I just tried twitter last week and was blown away! This is one really really cool service.

For me the coolest part about it is the SMS/Texting feature. For those who haven't used it yet, think of it as a service which lets you SMS/Text all your friends by sending an SMS to just a single number that twitter gives.

Twitter then goes out and updates everyone on your list by sending them SMS plus updating a whole lot of other places like your Facebook profile, your blog...

Other features include sending the message from the Twitter website or even from a downloadable app (imagine that FREE SMS), if you want to you can send a message to just one friend.

Note to Sri Lankan users, this works find on Dialog but a few of my friends on Mobitel had trouble getting setup. If any of you get this working with Mobitel please let me know.

Once you have created a twitter account go to http://twitter.com/merill and 'follow me' to get my twitter updates. 

The two Scotts

One of the cool things that happened at the MVP Summit this year was that I got to meet two people I really admire and both of them are Scotts.

 Scott Guthrie Merill

Scott Hanselman Merill MVPs

What was even cooler was that Scott Hanselman recognized me at the summit, now that's one cool dude who knows his readers. Hai there Scott!

Debugging SQL Server 2005 Stored Procedures in Visual Studio

I used to use the debug feature in Query Analyzer when working with SQL Server 2000 quite a lot. There were a number of time when I did want to do this in SQL Server 2005 but couldn't quite figure it out. I looked high and low on SQL Server Management Studio to no avail.

The reason? Debugging was moved out of SQL Server Management Studio and into Visual Studio.

Debug SQL Server Stored Procedure

Read all about it in this article by Scott Mitchell.

Code Profiling

Until yesterday, if anyone asked me about dynamic code profiling, I would have said that the only way to do it is to buy the Red Gate ANTS Profiler or the Jet Brains dotTrace Profiler.

Little did I know that I already had an excellent profiling tool installed right there on my machine for the last couple of years!

So what am I talking about. It's the small menu option that you see under Tools called Performance. Aha so that's why I never knew about this all along. The VSTS most probably wanted this to be an easter egg!

No worries though Orcas is going to fix this by renaming it to Profiler and moving it under the new Developer menu.

No wonder that this rarely shows up on Live Search or Google. The keyword profiler is nowhere to be found even in the overview page of this feature on MSDN.

So what can you do with the profiler today? Well you can use it to make your .NET applications super-duper fast. You'll find out things like which method gets called the most and which method takes most of the time to execute and a whole number of other things.