Man Made Code




















Statistics

Total Posts: 34
This Year: 0
This Month: 0
This Week: 0
Comments: 174


RSS 2.0   SocialTwist Tell-a-Friend


Admin

Sign In

Navigation

Home
imorfus (Complete Intranet Solution)
The Alchemist - India
Mix Match Parade
Developers Logic
Speaking Dodo
Programmer's Logic
i-Vista Digital Solutions Pvt Ltd

Recent Posts


On this page....

What is the max length of a file name or folder name in Windows OS?
Debugging web pages with IE Developer Toolbar
Converting a comma separated string having IDs to row result
How to determine the size of a table in SQL Server database?
Understanding and Using PIVOT clause in SQL Server 2005
Using Advanced Stream Redirector (ASX) to stream audio/video through HTTP Protocol
How to open .MSG Outlook file in Internet Explorer from a web application?
How to check a web form can have HTML/Script Injection?
Gardening W3WP Worker Processes in IIS Web Garden
Another way to export SQL Server table data to a Text file

Archives

 Full Archives By Category
 2007 Calendar View
November, 2009 (1)
August, 2009 (1)
July, 2009 (1)
June, 2009 (1)
May, 2009 (2)
April, 2009 (1)
March, 2009 (2)
February, 2009 (5)
January, 2009 (6)
December, 2008 (12)
November, 2008 (2)
<February 2009>
SunMonTueWedThuFriSat
25262728293031
1234567
891011121314
15161718192021
22232425262728
1234567

Categories

CDOSYS (1) Classic ASP (10) Command Line (2) Databases (16) Excel (1) HTML (1) IIS (10) Indexing Service (1) Internet Explorer (7) Media Streaming (1) MS.Net (2) SQA (7) SQL Server (16) Windows OS (2)
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Blogroll - Fav Blogs

 Geek Speak
 Gyan Guru

Acknowledgments

DasBlog Theme Design by: Tom Watts
E-mail: Send mail to the author(s)
Theme Image by: dreamLogic

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

Technology Blog

# 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.
Read more ...
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?
Read more ...
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”.
Read more ...
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?
Read more ...
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.
Read more ...
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.
Read more ...
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
# Saturday, January 10, 2009
How to open .MSG Outlook file in Internet Explorer from a web application?
Considering an example web application where the application allows uploading files with extension DOC, RTF, XLS, PPT, GIF, JPEG, PDF and MSG. The view page has the list of attachments and allows viewing files by invoking relevant applications. But files with .MSG do not open or do not invoke Outlook to view it.
Read more ...
IIS | Internet Explorer
Saturday, January 10, 2009 2:37:54 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Friday, January 09, 2009
How to check a web form can have HTML/Script Injection?
Injection of HTML code and/or client side scripts like JavaScript, VBScript, and Jscript by malicious web users into the web pages viewed by other users is a computer security vulnerability typically found in web applications. This is popularly known as Cross Site Scripting (XSS) Attack.
Read more ...
Classic ASP | SQA
Friday, January 09, 2009 1:24:12 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Sunday, January 04, 2009
Gardening W3WP Worker Processes in IIS Web Garden
What is Web Garden? How do I configure Web Garden? Why do my web application face random and frequent loss of sessions? Ho do I balance load on Worker Process? There are many more questions... You may find solutions for them in this article.
Read more ...
Classic ASP | IIS
Sunday, January 04, 2009 7:18:35 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Friday, January 02, 2009
Another way to export SQL Server table data to a Text file
No doubt that a DTS or SSIS package can be used to export SQL Server table data to a text file. The below article is to demonstrate another way to export SQL Server table data to a text file using xp_cmdshell extended stored procedure (This is with reference to SQL Server 2005 and above).
Read more ...
Command Line | Databases | SQL Server
Friday, January 02, 2009 2:22:02 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
 
ss_blog_claim=c020e08c7a23c693b3a7d2b925279828