Rachit's Blog

Silverlight UI Creation

rachitp — Mon, 17 Aug 2009 14:38:44 GMT

We’ve been looking to get a short-term Silverlight UI person (with of course a little experience integrating C#/Web Service experience) and I don’t know why it’s so hard to find a candidate. Like people who do Flash/Flex/ActionScript based web designing...(read more)

Missing Microsoft.SqlServer.SmoEnum Dll

rachitp — Wed, 29 Jul 2009 16:12:09 GMT

I like this SSB (Sql Server Broker) Admin tool but every time I refer this to somebody they come back to me with the questions that some of the DLLs are missing and they can’t launch the application. You should be able to find all the missing Dlls on...(read more)

Importance of Global Error Handling

rachitp — Tue, 10 Mar 2009 17:53:00 GMT

I saw this a long time back but every time I look at it, it reminds to make sure the friendlier error messages are on for any application. :)...(read more)

SQL Server Power Tools

rachitp — Fri, 06 Mar 2009 15:38:01 GMT

The SSMS Tools Pack is a “must have” for any developer who works with the SQL Server 2005 and above. I thank a lot Mladen for making this tool available. Go give it a try! http://www.ssmstoolspack.com...(read more)

Annoying Package Load Failure Error

rachitp — Fri, 27 Feb 2009 18:33:31 GMT

I’m using TFS Power Tools ( Oct 2008 release ). The Visual Studio 2008 was working fine until I start getting this very annoying “Package Load Failure” error. I didn’t install/uninstall anything but something somehow magically got changed. Error Description...(read more)

How do you read a technical book

rachitp — Sat, 31 Jan 2009 14:17:30 GMT

Given I have a finite reading time, it’s hard for me to read any technical book (300 pages and above) from the first page to the last. Most of the times, first 2-3 chapters give me enough to get going and other remaining chapters just become more like...(read more)

Windows 7 looks great

rachitp — Wed, 14 Jan 2009 00:52:14 GMT

I installed the Windows 7 64bit on my home desktop two days ago and the system is running since then. Other than a HP LaserJet 1012 printer drivers problem and one BSOD , Windows 7 looks fine for Beta for sure. :) Only one thing Microsoft should do, is...(read more)

Clean startup programs in registry in Vista 64 bit

rachitp — Tue, 16 Dec 2008 02:35:07 GMT

Sometime you wonder why the machine is running slow after installing a bunch of programs even if you choose not to run them through Administrator Tools/Services. Look at the following location in the registry and remove you don't need. I believe when...(read more)

Off Topic: Buy.com Customer Service Phone

rachitp — Sun, 14 Dec 2008 16:04:00 GMT

<RANT_BUYDOTCOM> I'm very surprised to notice that there's no (absolutely no) phone number listed for the customer service on the web site . How the hell am I supposed to "talk" to somebody about my order. Given the popularity of the web site, one...(read more)

Revolutionary desktop – BumpTop

rachitp — Wed, 10 Dec 2008 16:03:00 GMT

I came across the BumpTop almost a year ago and glad that I had subscribed for the future development news. The Beta is now available to download for XP/Vista. Let me summarize in a few words. It’s just awesome! Hope, Windows 7 includes something like...(read more)

Better error message please...SQL Error '...is not a recognized table hints option'

rachitp — Mon, 03 Nov 2008 21:29:00 GMT

I was getting the following error in a stored procedure that I had written. Nothing fancy in it as far as concern with using any new features of SQL 2005.

Msg 321, Level 15, State 1, Line 5

"sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function,

ensure that your database compatibility mode is set to 90.

I googled about it and most of the places (like this) the answers are about checking the database compatibility. I looked at our database's configuration and everything seemed fine to me.

Then I realized that I had used the dynamic sql in the stored proc and between two lines of the sql statements, I had forgotten the "space" and that's why I was getting that error. How the hell on the earth that has to do with the error message above?

Why can't SQL management studio give better (correct) error message? Come on, am I asking for too much here?

Javascript Debugging Feature Request

rachitp — Fri, 31 Oct 2008 02:27:40 GMT

It's very helpful to have the intellisense in the Visual studio 2008 for JavaScript. I thank MS a lot for it. I request if the intellisense can be also provided while debugging in the immediate window.

For example, when I want the details of the Date object, the following intellisense pops up which is awesome.

But, when you run the application and try to debug in the immediate window, how do have the intellisense pop out? Have I missed any short cut? The intellisense works for C# or VB.Net in this window but not for JavaScript.

OnPageIndexChanging not working in GridView within UpdatePanel

rachitp — Wed, 22 Oct 2008 19:04:48 GMT

I'm working on a demo ASP.Net page that has multiple User Controls (.ascx) and one of the user controls has the ScriptManager and the UpdatePanel. The GridView control is within the ContentTemplate of the UpdatePanel. I was trying few things and hitting my head against the wall to find out why my Paging is not working. The following lessons are leant:

You have to have OnPageIndexChanging in order for GridView to do Paging.
I had accidently set the ChildrenAsTriggers to false on the UpdatePanel so even if the OnPageIndexChanging fires, it will not update the Grid at all. Remove ChildrenAsTriggers from the UpdatePanel and the Paging should work fine.

Hope this helps someone!

Change Server Url in Email for Reporting Services

rachitp — Sat, 02 Aug 2008 11:24:00 GMT

When you schedule something to run in the Reporting Services and when the report gets emailed to the requestors, by default, in the email, you'll see http://servername/reportserver/report....

So what happens that if you are on the network (which is most likely if the reporting services is used for a corporate), you may get some DNS error that "servername" machine not found.

You can change the "servername" to full qualified domain name i.e. servername.domain.com

Go to your Reporting Server machine and do the following:

Open RSWebApplication.config (C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager) and change the value for key "ReportServerUrl" to "server.domain.com". Save changes.
Open RSReportServer.config (C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer) and change the value for key "Services/UrlRoot" to "server.domain.com/reportserver". Save changes.

That's it. I personally would restart the IIS server and the SQL Server Reporting Services under Administrator Tools/Services. YMMV.

Hope this helps somebody.