Welcome to MSDN Blogs Sign in | Join | Help

Random Hacks!

Awaiting my Bohemian Rhapsody

News

So long, and thanks for all the fish!!

So this is it! This is my last post in this blog. As I come to the end of my stint with this great company, I would close out this blog. Thanks to all the visitors, and thanks to the company for giving me the chance to giving vent my random thoughts in a platform like MSDN Blogs. My new address in blogosphere would be @ Windows Live Spaces. Thanks again, and so long!

P.S. I have received some queries from some friends whether the title of the post is to reflect my fooding habits, so just to clarify - here is the justification for those unacquainted with DNAs classic.

New .NET Logo

.NET - the coolest framework product in the world (IMHO) ......gets a cool new brand identity....and the new wave identity is COOL too!!

.NET Framework new logo

"When caching is enabled for the XmlDataSource that is control tree it requires a UniqueID that is unique throughout the application" - Use an ID for XmlDataSource

XmlDataSource class internally calls a private method called CreateCacheKey. Now, if you are using XmlDataSource without an ID, after upgrading the solution to ASP.NET 3.5, this might throw an exception - "When caching is enabled for the XmlDataSource that is not in the pages control tree it requires a UniqueID that is unique throughout the application." This is due to the absence of the UniqueID (which is read-only, but my experiment shows that setting the ID handles the same), which is used as part of the caching key, without which all instances would try to use same caching key. Setting a distinct ID solves this problem and the problem goes away.

Thanks and credits to http://forums.asp.net/p/1294664/2510357.aspx

Example.

XmlDataSource XmlSrc = new XmlDataSource();
XmlSrc.ID = "XmlSource1";

Free SQL Server 2008 online trainings

Get some cool SQL 2008 trainings here - http://sqlserver2008jumpstart.microsofttraining.com/

Neat stuff!!

Jeff Prosise talks Silverlight on .NET Rocks

It doesn't get better than this ... Jeff on Silverlight :)

http://www.dotnetrocks.com/default.aspx?showNum=302
 

Visual Studio Gallery

The one stop shop to get all the armory needed to defy all challenges!!

http://www.visualstudiogallery.com/ 

Enjoy!

Visual Studio 2008 does not show Solution view when there is only one project in the Solution (by default)

Visual Studio 2008 does not show Solution view when there is only one project in the Solution by default, which makes it difficult to add another project to the solution. This persists even when we add a new (blank) solution. The solution is to go to Tools>Options>Projects and Solutions and check "Always Show Solution" (which is unchecked by default).

 Enjoy!
 

Query to check for a text in All SQL Server 2000 sources in a database

If you ever felt a need to perform a query to check for a particular text instance in all sources (SPs, functions, triggers et al) in your SQL 2000 db, chances are you might have already written this little goodie. But if you haven't and if you need some quick script to get this done for you, here's one I have been using for quite sometime and I gotta say, it works like a sweet charm! Best of luck!

 

 
SELECT [number], [TEXT], A.name

FROM syscomments B, sysobjects A

WHERE A.[id]=B.[id]

and TEXT like '%your text%'

ORDER BY [number]

GO

 
And here's the sql job part -

 

 
select S.name

from msdb.dbo.sysjobs J

inner join msdb.dbo.sysjobsteps S

ON J.job_id=S.job_id

where command like '%your text%'

ROI of Web Services and the Challenges

Web Services are the order of the day - and all the industry movers and shakers are betting big on them! But here's some authentic info on how web services are being used for good - and how they are driving down the costs. For starters, using Web services to streamline internal processes has reduced General Motor's vehicle design process from forty-eight to eighteen months - as stated by this HBS Working Knowledge feature.

However, with all its benefit and the concept of SaaS and its synergies to business strategies, the good old problem of "common standards" continue to challenge web services to become the next big thing...as told by this interview of Andrew McAfee

The bottomline is, while Web Services provide a perfect stepping stone to integrate, centralize IT systems and bring about serious cost savings, it doesn't provide a magic solution to the age-old problems of system integration. The current hype cycle might lead people to jump into it looking for overnight gains, but the best way still is to analyze, define and design systems with diligence, and then, reap the benefits :) .

That said, used effectively, web services will lead the evolution of IT systems as greater business enablers in the days to come and will remain one of the main pillars of the Web 2.0/Enterprise 2.0 revolution, if you will!!

Asynchronous ASP.NET Web Services + ASP.NET Ajax / Silverlight enabled UI = Makes my day!!

Microsoft SQL Server 2008 – Learning Portal Launched

The Microsoft SQL Server 2008 – Learning Portal has been released to external customers now and is available at http://www.microsoft.com/learning/sql/2008/default.mspx

Join there and discover the SQL 2008 Advantage with free e-learning clinics and trainings.

Msg 2812, Level 16, State 62, Line 1 - Could not find stored procedure 'S'. - Issues with osql

If you are used to installing your SQL objects into the database server using scripts and osql command, you may sometime encounter this message

 Msg 2812, Level 16, State 62, Line 1
 Could not find stored procedure 'S'.

 

The error message will be the first letter in the name of the sp/object that is failing. I had this issue and was about to pull out my hairs when, after a lot of searching, I found the solution! It seems that osql doesn't take Unicode as input (unless explicitly specified by -u switch, but I could not confirm that from the documentation at http://technet.microsoft.com/en-us/library/aa213088(SQL.80).aspx ). To get around this, open the objects for which the installation is failing using a text editor, go to File>Save As and save with Encoding as ANSI.

Hope this helps someone out there lost with this bizarre issue. 

The story of United Federation of Software and Services
This is an enticing story of evolution of software architecture to today's SaaS model .... published in Microsoft Architecture Journal........Gianpaolo Carraro tells the story in an unique fashion which I loved and hopefully you will too....follow the link http://msdn2.microsoft.com/en-us/arcjournal/bb906059.aspx
Phishing - a social malice by e-Zombies

Phishing has become a big concern - and it has started to hit Indians in large numbers. With the following two reports from ET - http://economictimes.indiatimes.com/Infotech/Internet_/Call_Centre_man_held_for_hacking_bank_account/rssarticleshow/2548793.cms and http://economictimes.indiatimes.com/Infotech/Internet_/Phishers_get_smarter_keep_ICICI_clueless/rssarticleshow/2527034.cms , its very clear that Phishing is on big time in India. The targets are innocent, non tech-savvy elders who would seldom understand that ICICIBANK.com and domain1.com/iciciabc are different if the UI looks the same. The e-Zombies are wrecking havocs by exploiting these people.

It is highly recommended to use the features provided by the browser manufacturers to keep yourself safe from the same -

IE 7 (IE blog also gives a high-level overview of the protection process) - http://blogs.msdn.com/ie/archive/2005/09/09/463204.aspx

Firefox 2 - http://www.mozilla.com/en-US/firefox/phishing-protection/

Opera - http://www.opera.com/docs/fraudprotection/

However, its always recommended to rely on common-sense and also on the banks recommendation - i.e. never divulge your PIN online etc before even using e-banking even for the first time.  
 

Microsoft India - the Best Company to work for in India

Can't resist making a non-technical post at this cool news! The business today-Mercer-TNS survey is out, and it has ranked us as the Best Company to work for in India - and all can be read here - http://businesstoday.digitaltoday.in/index.php?option=com_content&task=view&id=2257&Itemid=1&issueid=13&limit=1&limitstart=1 

changetheworldorgohome

It's a hell lot of fun.....Changing the world!!!

Howto: undo another users check-out as a TFS admin

Although its a task you seldom would want to do, it might become a necessity when someone leaves the team on hurry/short notice. The way out is aptly described by Matthew at http://blogs.msdn.com/mrod/archive/2007/01/08/undoing-a-checkout-that-belongs-to-another-user.aspx , and I just thought I would mirror the command to give it more live search-ability :)

tf undo /workspace:OtherUserWorkspaceName;OtherUserName  $/Project/..../FileName.cs /s:http://yourtfsserver:8080

 

Also, much more details available at James Manning's blog 

 

 

More Posts Next page »
Page view tracker