So some time last year i started looking at asp.net optimization applications , but man these things are hard to come by but luckily for me i came across the Red gate profiler .Hope fully i will get down to installing the application again after the many formats i had to do and post some samples here. But the increases were significant to say the least.
After that i had a semi non official promotion and had more database responsibility which once again led to there wonderful sql toolkit.Of the applications that came with the toolkit i have to recommend the SQL Compare and Sql Prompt.
Sql Compare is a developers best friend. Time is never on a developers side (may be the rockstar programmers ) but for the rest of us i some times ended up doing some work development at home , and this is the biggest nightmare u can imagine .With out sql compare there was a inevitable loss of some of my work at some time as i used to run a dual config setup i.e. at work we had a dev database and at home i had my own database which was most kept in sync with scripts from dev or live. But trust me there is always some small change that u miss that ends up breaking the build and this is where sql compare comes in perfectly keeping databases in sync as well as showing you the changes between the databases and allowing you to chose what to update. Unfortunately after the 14 trial i had to stop using the application as the price was out of my range and i had no buying power in the company. But a 5 starts from me :) .
Sql Prompt is another wonderful application , simply put its everything that Microsoft should have included into SQL Management Studio for a developer .The most important being the auto complete ability as well as short cut phrases. There is not much else to add except that if you come from a Visual Studio background it will make you feel much more at home and definitely increase productivity.Again 5 stars from me :) .
They have just released a new stunning application again called the Exception Hunter ,Not having a chance to test this i will keep it to the quoted text .This application will basically hunt down the locations at which exceptions might occur. Since i have not seen this and no idea how it works, i am going to have to venture on a bit of a gamble.
Here is some pseudo code
1. Load all the code into memory or parts of the app at a time.
2.Try to invoke as many methods as possible using default stored data and mark the locations at which exceptions are thrown and the reason.
3.Search through the code to see if the user throws and exceptions explicitly and mark the locations at which exceptions are thrown and the reason.
4.Check for unassigned variables and any unmanaged code and mark the locations as possible error locations.
Being the coolness that they are they obviously have plenty more checks and are more through with there code then my little pseudo code list :).
If anyone has tried it yet please let me know what you think, but as always i would like to test it my self. (I dont mind sponsors btw :) )