l'Ishwar incroyable Nataraj

Just a quick note on how to ajaxify Sharepoint 2010:- 1. Download the code files from http://ajaxifymoss.codeplex.com/ 2. Update the location of stsadm to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\stsadm in deploy.cmd and upgrade.cmd files respectively. 3. Open command prompt in admin mode and run the following command: STSADM.EXE -o addajax -url http://UNLT239/MOSS to ajaxify the site. In my case it is the above url, however you would need to specify STSADM.EXE -o addajax -url <sitename_to_be_ajaxified> Once this is done, navigate to the web.config file and ensure that you replace the version of your system.web.extension to 3.5. Also the following changes are extremely vital:- <httpHandlers> <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> <a...

Now many a time it becomes a necessity to track daily expenditure (or weekly expenditure) and try and figure out your spending trend over the year. I created a quick solution for anyone out there who requires something like this. It should not take you more than 3-5 minutes unless you are blogging about it. (Thought of implementing it in SSRS earlier but an excel sheet is good enough to do the trick) 1. Open Excel and type in the Location, Date and Expense made... something similar to the following image:- 2. Now in case you want to just check the trends of your expenditure using databars, create another column or insert a column called trend and then click on conditional formatting on the Home Ribbon (Keeping the Trend Column Selected) and choose the Databar along with the required color formatting --> the image is as shown below: 3. Next Step Ensure that for every cell in the Trend column you point it to the respective cost which in my case are the values present in the B column s...

Ran across an issue while trying to create using Report Builder 3.0:- ERROR DETAILS Following errors were detected during this operation. * [12/29/2011 12:47:47 PM] System.Deployment.Application.DeploymentException (Subscription) - Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application. - Source: System.Deployment - Stack trace: at System.Deployment.Application.SubscriptionStore.CheckApplicationPayload(CommitApplicationParams commitParams) at System.Deployment.Application.SubscriptionStore.CommitApplication(SubscriptionState& subState, CommitApplicationParams commitParams) at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri...

A friend of mine asked me to watch this movie Aaarakshan (pretty bad movie except for Amitabh's performance) but the movie did have a moral to it though it turned out to become a complete Bollywood fiasco at the end. The concept of having a quota in place for people belonging to the backward communities is correct in a manner of speaking. But wait!!! this is not where I stand. I would actually prefer to have the quota system in place for people who are near the poverty belt and below. It does not make sense for a wealthy person who comes from a backward community to take the eay way out and place the trump card ("quota") when it comes to his or her relative battling it with others. Merit should be the ultimate winner here where people work hard and prove to the world that they can stand on their own two feet and not have everything handed to them in a platter. Maybe the UID (Unique identifier system) that is currently taking place in India would be a solution to figure ou...

Have been writing a couple of tech articles in the recent past (If I had started writing it on a regualr basis I might have had an encyclopedia by now.... I should write something else just 4 a change huh!!!): Question posted on one of the SQL server sites out there--> concatenation of rows to columns.... There are 3 ways of accomplishing it and I ain't going thru all those approaches but will just highlight them (except for my solution here):- 1. Creating a dynamic SQL which will keep concatenating the rows into a specific column in a PL/SQL block which returns the required table. 2. Using recursive CTE to concatenate the rows into columns .... Maybe should hit upon CTE's which are extremely useful in a later post (If I get some time i.e.) 3. Now this method is pretty cool Now let me give the problem statement as posted by that individual... Let us create the table in the following manner--> select 'Report1' as reportID,'Browser' as RoleID, 'YChen...

So my next step is to deploy the reports in sharepoint. Great! Except now you might run into the following issue: the full path must be less than 260 characters how would you go about resolving this-->simple follow the steps below.... 1. Create a document library with the document type being null. 2. Else go to the library section and select reports as the type of library. 3. The next step is to ensure that you give a valid name for the library (This is an easy one) so your format would be http:// /SiteName/LibraryName 4. Go back to your SSRS project properties. Make sure that the Target Data source folder and the Target Report Folder are configured with the following value as mentioned in step 3 :- http:// /SiteName/LibraryName 5. The TargetReportPartFolder need not be filled.... Its upto you. This foldercan be used to deploy to a sub library... 6. The TargetServerUrl would be http:// /SiteName 7. Make sure you point the TargetServerUrl to the right version of SQL server. Click dep...

Recently started working with Sharepoint 2010. PPS and excel services seemed pretty simple on the onset. Now while trying to integrate SSRS with share point 2010, I ran into this issue: "Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages" Man--> this was a mind boggler. Let me explain what I tried to do in order to eliminate this issue and still did not work:- 1. Opened the RSManager Config file (located at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer if you have a 64 bit OS) and then changed the following <AuthenticationTypes> <RSWindowsNTLM/> </AuthenticationTypes> and changed it to Kerberos mode: <AuthenticationTypes> <RSWindowsNegotiate/> (acts as a intermediary between NTLM and RSWindowsKerberos)) </Auth...

Just a quick code snippet on the usage of the ScriptObjectModel in SSIS script tasks... It takes one through all the required functions that can be exposed using the script object model:- using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SqlServer.Dts.DtsClient; using Microsoft.SqlServer.Dts.Runtime; using Microsoft.SqlServer.Dts.Tasks.ScriptTask; using Microsoft.SqlServer.Dts.Tasks; namespace ScriptObjectNotifier { public class SOCall { ScriptObjectModel objModel; public SOCall(ScriptObjectModel valObjModel) { objModel = valObjModel; } /// <summary> /// gets the connection string from a conn Parameter /// </summary> /// <param name="connName">name of the connection</param> /// <returns>string</returns> public string GetConnectionString(string connName) { string connection...

This code works perfectly and can be configured in any manner: I was struggling due to command timeout and WITH RECOVERY options not present in my code earlier...... Please note that if your database has differential files, set the tsql to NORECOVERY: string dataFileName = string.Empty; string logFileName = string.Empty; string getRestoreQueryList = @" RESTORE FILELISTONLY FROM DISK = N'C:\Test\Ishwar.bak'"; SqlCommand getRestoreQueryListCommand = new SqlCommand(getRestoreQueryList, con); SqlDataAdapter adp = new SqlDataAdapter(getRestoreQueryList, con); DataSet ds = new DataSet(); adp.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { if ("PRIMARY" == dr["FileGroupName"].ToString()) { dataFileName = dr["LogicalName"].ToString(); } else { ...

I am a great believer in Murphy's law and the eventuality that this law can pertain to everything in life and its subsequent impact on humanity in a multitude of ways. Let me constrain myself to the outer realm of business application rather than the internals. Here is my own list (somebody might have come up with it before but maybe not this eloquent :) ) 1> Business will never move in the direction one wants to steer it in. 2> Every time you decide to invest big in the stock market .... it crashes!!! 3> When you feel that your company is in good shape, your competitor is one step ahead into buying you out. 4> Whenever you think about a decision that you made for the benefit of your organization, your organization will get a massive blow to its body bag. 5> When you think that you are the conduit for the success of a project, there are others who have already taken the credit for the success. 6> Mistaking your partner as your pillar of support will eventual...

Recently started learning more about performance related stuff in SQL server. Man oh man!!! so many things to learn and so many things to blog about.... Let us start with the basics: Writing a SQL query you need to measure a couple of things: 1. Query Cost 2. CPU Utilization 3. Time taken for the Query to execute 4. Table scans, Index scans and Index seeks. Let us start by focusing on Query cost---> Write the command- SET SHOWPLAN ON; and then execute a SQL for example--> SELECT E.EmployeeID,E.EmployeeStatus FROM Employee E where E.AddressID = 112345 ORDER BY E.EmployeeID This command will basically give us the Query analysis built into the SQL server. The first aspect you will notice is the Query cost... In this case if there are indexes on the underlying table then we can state that the query cost might be less provided the index is being used else the query cost is going to increase significantly. Also we can minimize query cost by inclusing more filters in our SQL query provi...

I just noticed that the face of humanity has changed a lot from my generation. People tend to not take responsibility very well and keep nagging about various things that actually dematerialize the very foundation on which humanity is built on. Act1: User forgets MP3 player @ office and asks one of his office colleagues to look after the MP3 player. Act2: Colleague decides to keep MP3 player in his/her drawer without locking it. Act3: MP3 player gets stolen. Act4: Colleague pretends to be cool about the MP3 player and coy about the fact it gets stolen. According to his/her logic, the MP3 player would have eventually been stolen because of User's forgetfulness. Is this what humanity is preaching now.... irresponsibility?? Pathetic display of human unresponsiveness to a general situation. Lets us take the current predicament facing us @ the national level. The Lokpal bill is supposed (???!!!) is supposed to eradicate or subside the rise in corruption by giving the common man more pow...

Have not been followin a TV series in a while (The last two I followed pretty religiously were Castle along with Bones and these two were pretty good). But in the recent past I have been following Dexter and another called Spartacus (I was able to catch all the episodes of Blood & sands as well as Gods of the arena). Spartacus is pretty slick in its cinematography bcoz its more like watching bits and pieces of 300 (a good movie) with more of a storyline and the explicit no holds barred kinda program really takes you back to the past. But Dexter on the other hand is quite different from the rest as it shows a bad guy killing other bad guys for sport. I mean to a certain extent what he is doing is nothing but being a vigilante since he is helping in takin out the trash. But does he have the moral right to do so...hmmm (pondering over this). Dexter has a disease and a nasty one at that. He is trying to control it by focusing it on bad guys. But how does he justify whether the person i...

OMG!!! I dont know who I am!!!! Seriously nowadays there are several dime a dozen clones of you online. Being serious here --> Identity theft (IT) has certainly become rampant in all parts of the globe. Maybe some slander your very means of existence & others might be to increase your popularity (online stalkers? ahem). I dont know where I am going with this article but I thought that maybe becoming a Jason Bourne after your identity has been stolen is easier than one thinks. Can this be done easily?? Yes but why?? Does your existence (i.e. the one stealing the identity) does not have a life of his/her own??? Social Networking sites are ever increasing but is that really you on that site?? Lets get past the garbage I wrote earlier and come to the adventure part. Rode a cycle to office today (and back home too --> believe it you naysayers). Maybe about 40 kms. Not bad but more than the back pain it is the back side pain that leaves you struggling. Scenario--> I am in a res...

Finally a technical article after a reallllly long time............ Tip 1: Ensure that when you fetch data from an SQL server data source always use the "(NOLOCK)" option in the sql statement example: select studentid,name from student (NOLOCK) This ensures that a deadlock does not take place (best option to use in a multi user environment :) ). Tip 2: The maximum packet size that can be transferred across a network is approximately 4 MB. Here we could improve the performance of our data fetch from the source and data migration to destination by modifying the connection property of your SSIS package. Right click on the the connection and click properties, you will find a property called packet size: Make sure this packet size is about 32767 to get the maximum benefit across a network. Tip 3: When you have multiple tasks running in parallel in a package(The maximum an SSIS package can actually subdivide these tasks or SSIS can spawn a maximum of 8 processes), so it would make ...

Just thinking a couple of days ago as to the cartoons that I used to watch as a kid (still watch some of them when I get the time). Cartoons are like a breath of fresh air at times. Man, I used to watch so many cartoons. Here is a list of some that I could remember (I can tell my kids someday that these were the cartoons I used to enjoy watching..... a lot of nostalgia here): 1] Grandizer 2] Thundercats 3] Inspector Gadget 4] He-Man and the masters of the Universe 5] Captain Majid (I used to watch the arabic cartoon version) 6] Swamp Thing 7] Skyhawks 8] G.I.Joe 9] Rambo 10] Mr. T 11] Transformers 12] Banana Man 13] Pink Panther 14] Looney Toons 15] Care Bears 16] Smurfs 17] Voltron 18] Ghostbusters 19] Police Academy 20] M.A.S.K 21] Duck Tales 22] Chip & Dale - Rescue Rangers 23] Dennis the Menace 24] The Racoons 25] Count Duckula 26] Transformers 27] Spideman and his amazing friends 28] Bravestarr 29] TMNT 30] Denver the last dinosaur 31] The Hulk Maybe I should keep posting list...

Recently read an article by the CEO of Google. Mr. Eric Schmidt tries to emphasize that business works primarily on the pillar of honesty and being brave enough to admit when one is @ fault. I do agree with Mr. Schmidt but there are certain aspects where taking responsibility will not achieve anything but a more severe reprimanding by the powers to be. Rather than accepting fault readily people especially at the top should first investigate as to what the impact of a particular transaction/event can do. Once this is done, what are the steps necessary in order to ensure that the details are and will be ready to the public @ a gradual pace. Nowadays due to the impact of media, information gathering as well as spreading will hardly take a couple of seconds. The media has the right to make their assumptions as well as the fact that it needs to be extremely clear to the public that @ the end of the day, it is an assumption and not a fact. People are always ready to jump to several conclusio...

Follow this diagram to save the tiger Note: Created this one after seeing the Aircell ad. Could'nt post it earlier. Follow this diagram and evrything will work. --> Simple and ideal. (i)We got to move inwards out so our primary goal is to secure the land for this magnificent animal. (ii) The second step is to have a steady food source for the tiger (which would include the food source for the tiger's food source and naturally the cycle will continue till everything is in place) (iii) We need to have uncorrupt officials in charge of taking up this magnanimous/huge responsibility and ensure that funds raised are directed towards the correct measures. This is the root cause of the tiger's problem. We fix this and we can save the tiger for sure!!! (iv)Taking a regular census of the tiger population (either the goverment does this on a regular basis or they could actually utilize the private census benefits offered by international wildlife protection agencies). (v)Kick poach...

Just to refresh my memory, I am going to jot down the following as part of my cheat sheet, so that one glanceover would refresh my memory: ACID :---> Atomicity: This is the process by which any transaction performed on a DBMS, will not take place (or will be rolled back) in case a part of the transaction fails. Consistency: Consistency implies that the state of the database would be constant at any period of time. During transactions, the db would move from one consistent phase to another consistent phase. (All the constraints and regulations of the database is maintained) Isolation: Isolation indicates that every transaction is performed as a seperate action and will not be interdependent on one another. In case of any such dependencies then the transactions will take place in a sequential manner (based on FCFS or some priority based operation) Durability: This indicates that the database will be robust and will not collapse at any period of time. At frequent time intervals snapsho...

This initially was a set of plans I had given to an organization I used to work for, (These ideas were given about 2-3 years ago and still have merits at this time and age). I have a couple of ideas which I feel the any Pharmaceutical software company could really capitalize on. The ideas and suggestions I have are as follows: A] The Indian Pharmaceutical market is burgeoning in size as well as improved technological capabilities have ensured that the Indian field force is on par with most of its counterparts across the globe. I feel that it is extremely important to strike the iron when it is hot. And this is a golden opportunity to showcase our products (probably a more stripped down version of MI and the other products in our product suite) to the Indian market. The cost factoring will definitely be a major hassle but I am sure our great marketing minds in your organization would definitely come up with an idea to embattle this and get the price bracket right. I presumed that with ...