Exporting to Excel with bcp

I was recently looking for a quick way to export SQL Server table data (over 1,00,000 records) to a Excel file.I found that the bcp command line tool can export SQL Server table data to a .xls file but when I export it to a Excel 2007 (.xlsx) file, I couldn't open the file. It throws a warning - "Excel...

Read More

Travel Planning & Reservation Tips using Online Tools

A number of online tools & services have emerged for travelers in India in the last couple of years that help you plan & complete reservations, faster than ever.What is the fastest and/or cheapest way to travel between two places in India?Try 90di.com's online travel search engine. It gets you...

Read More

Microsoft Office Labs Community Clips

I knew that there were free screencasting tools available, but I did not know about the Microsoft Office Labs Community Clips until I read about it on Channel 10. Community Clips provides a little app that on installing integrates into Office applications. It lets you record a clip or a tutorial in...

Read More

Spelling & Grammar Check in Browsers

It's good to see browsers picking the good features of each other & in some cases refining them so that it becomes a standard in subsequent versions of other browsers. Tabbed browsing, In-line Search, "Find As You Type", Undo Close Window (Ctrl+Shift+T), built-in Developer Tools are all innovative...

Read More

Virtual TechDays

If you work with Microsoft technologies, there have been a lot of new developments that you may have to keep pace with to stay current. Microsoft India is conducting free online sessions (nearly 50 in all) from August 19 to 21st on the following topics:Web DevelopmentWindows 7 and Client DevelopmentMicrosoft’s...

Read More

Free SQL Server Tools

SQL Server Magazine has compiled The Mega Guide to Free SQL Server Tools that has over 80 tools for under these categories -AdministrationBackup and RecoveryBest Practice and ComplianceBusiness IntelligenceChange ManagementCode FormattersDatabase ComparisonDatabase SecurityDevelopmentJob ManagementLog...

Read More

HOW TO access a HTML Label tag's text programmatically

On a technical Forum that I frequent, there was a question on how to get the Label tag's text associated with a radio button (or for that matter any other control). The easiest way I found is to use jQuery -alert($("label[for='radio1']").text()); //radio1 is the ID of a radio buttonYou would need to...

Read More

ASP.NET MVC vs. Web Forms

The July edition of MSDN mag has an interesting article by Dino Esposito that compares Web Forms And ASP.NET MVC. The author presents an excellent 100 feet view of ASP.NET MVC and I loved reading it. As I'm going to re-read it & recommend it to others, I've made a Reader's Digest version of it that...

Read More

Selecting multiple attachments at once in GMail

I came across the multi-select attachments in GMail feature by accident but later found that this has been documented or rather blogcumented. You have to hold down the Ctrl key and click on each file you want to attach to your message.However, there is a twist. This feature works in all browsers (IE,...

Read More

Mobile OS Upgrades

In a mailing list that I'm part of, there was a question on why installing a new OS on a Mobile is difficult. MVP Saurav's response was interesting and I quote him (with permission) -Mobile Phone ecosystem is not like a PC. On a PC a user can upgrade the hardware as he wants. If he wants a higher megapixel...

Read More