Man Made Code - Tuesday, July 14, 2009

Tuesday, July 14, 2009

Favicon – The little icon on the address bar

A Favicon is the little image displayed in your favorites and in the left corner of the Address Bar of Internet Explorer when you bookmark a page. The Favicon was first popularized by its appearance in the "Address Bar" and "Favorites Folder" using Internet Explorer. Currently, Internet Explorer 5.x (IE 5.x), Linux's Konqueror and Mozilla/Netscape 6.x (NS 6.x) Web browsers support the Favicon function.

Classic ASP | HTML | Internet Explorer | MS.Net

Tuesday, July 14, 2009 6:22:24 PM (India Standard Time, UTC+05:30)

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

Saturday, June 13, 2009

Smarter the better – SQL Server tips – part 03

This is in continuation to my previous post on SQL Server Tips.

Databases | SQL Server

Saturday, June 13, 2009 11:12:33 PM (India Standard Time, UTC+05:30)

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

Saturday, May 16, 2009

Smarter the Better – SQL Server Tips – Part 02

This is in continuation to my previous post on SQL Server Tips. Use table variables instead of temporary tables. Include SET NOCOUNT ON statement into your stored procedures to stop the message indicating the number of rows affected by a T-SQL statement.

Databases | SQA | SQL Server

Sunday, May 17, 2009 12:22:01 AM (India Standard Time, UTC+05:30)

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

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

Statistics

Admin

Navigation

Recent Posts

On this page....

Archives

Categories

Blogroll - Fav Blogs

Acknowledgments

Disclaimer

Technology Blog