Man Made Code - Friday, May 15, 2009

Friday, May 15, 2009

How do I read excel file data columns as TEXT always?

Many developers/programmers while writing code to extract data from an excel Intermixed data columns struggle to read the data. Reading data from an excel file is always been a challenge as the first row (record) of the data in excel defines the data type of the column. For example if the first row has the data as Integer and any consecutive row has the data as Float, excel read operation would fail as it expects the rest of the data in that column to be of Integer type.

Classic ASP | SQA | Excel | MS.Net

Friday, May 15, 2009 11:41:32 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Saturday, April 11, 2009

Applying Windows Integrated Authentication in IIS 6 gives error HTTP 401.1 – Unauthorized: Logon Failed

Recently I did hosting of a website on IIS 6 on Windows XP Professional SP2. The website is applied with Basic Authentication and Windows Integrated Authentication. Strangely the Integrated Authentication does not work, but the same website on Windows 2003 Server SP2 works fine. When attempted to browse the website, it does ask for username and password; but does not login and shows the error HTTP 401.1 – Unauthorized: Logon Failed.

IIS | Internet Explorer | Windows OS

Saturday, April 11, 2009 1:48:38 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Sunday, March 08, 2009

Smarter the Better – SQL Server Tips – Part 01

There are many occasions where a SQL Server Developer uses scripts which take longer to execute. I would rather say a wrong choice or approach in writing scripts caused the execution of the script longer. There are smarter ways to achieve results. In this post I will try to consolidate few tips on smarter SQL Server programming.

Databases | SQA | SQL Server

Sunday, March 08, 2009 7:34:17 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [1] | Trackback

Monday, March 02, 2009

Finding Stored Procedure Create and Modified Date in SQL Server

We all have created Stored Procedures in SQL Server. We keep doing regular updates on the applications using SQL Server database. The real problem comes when the application need to be made live and the database stored procedure is required to be synced with the live server. Unless there is no track of change monitored, it would be difficult while deploying the updates and upgrades in SQL SPs on to the live server. Now the question is more clear... Can I find the last modified date for a stored procedure in SQL Server?

Databases | SQL Server

Monday, March 02, 2009 6:35:32 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Friday, February 20, 2009

What is the max length of a file name or folder name in Windows OS?

Most of you have been using Windows OS. Have you ever tried finding, what is the length of a file name or a folder name could be? Except those who have specifically worked on File system Object (FSO) would have not bothered to know as how a file and folder name is defined in Windows OS.

Classic ASP | SQA | Windows OS

Friday, February 20, 2009 8:58:29 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Saturday, February 14, 2009

Debugging web pages with IE Developer Toolbar

I think I wrote the program correct, but still the web page does not show the desired HTML output. How do I debug and validate my web page HTML and CSS rendered to the browser?

Internet Explorer | SQA

Saturday, February 14, 2009 12:02:40 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Friday, February 13, 2009

Converting a comma separated string having IDs to row result

This post is in continuation to my previous post on “Converting Row Data as Comma Separated String”, which is to demonstrate exactly the opposite process “Converting a Comma Separated String Having IDs to Row Result”.

Databases | SQL Server

Friday, February 13, 2009 8:51:01 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Thursday, February 12, 2009

How to determine the size of a table in SQL Server database?

You know how many fields are there in the table. You know the size of each field in the table. You know how many records are there in a table. But do you really know the size of a table? How much space is that table really taking?

Databases | SQA | SQL Server

Thursday, February 12, 2009 11:46:10 AM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Friday, February 06, 2009

Understanding and Using PIVOT clause in SQL Server 2005

SQL Server 2005 has lots of new features, of which one is PIVOT clause. This is similar to Pivot tables in MS Excel and Matrix Control in Reporting Service. Here is a simple example demonstrating how to use PIVOT clause. I am right now taking a simple example. There are scenarios where there could be a need to write a big stored procedure to build a Pivot table in lower versions of SQL Server.

Databases | SQL Server

Friday, February 06, 2009 9:09:00 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Monday, January 26, 2009

Using Advanced Stream Redirector (ASX) to stream audio/video through HTTP Protocol

Advanced Stream Redirector (ASX) files are based on the Extensible Markup Language (XML) syntax, and are made up of various elements with their associated tags and attributes. This is designed to store a list of Windows Media files (.WMA, .ASF, .WMV) to play during a multimedia presentation. The ASX files can be effectively used to play songs over the Internet/Intranet through HTTP protocol.

Classic ASP | IIS | Media Streaming

Monday, January 26, 2009 5:54:01 PM (India Standard Time, UTC+05:30)

| Akash Heranjal | Disclaimer | Comments [0] | Trackback

Statistics

Admin

Navigation

Recent Posts

On this page....

Archives

Categories

Blogroll - Fav Blogs

Acknowledgments

Disclaimer

Technology Blog