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.

HOWTO: View all images on a site

Did you know that you can view all the images on a site by searching for site:<url> e.g. site:merill.net. Works on Google Image search as well.