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....

Smarter the Better – SQL Server Tips – Part 02
How do I read excel file data columns as TEXT always?
Smarter the Better – SQL Server Tips – Part 01
What is the max length of a file name or folder name in Windows OS?
Debugging web pages with IE Developer Toolbar
How to determine the size of a table in SQL Server database?
How to check a web form can have HTML/Script Injection?

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)
<March 2010>
SunMonTueWedThuFriSat
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910

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

# 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.
Read more ...
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.
Read more ...
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
# 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.
Read more ...
Databases | SQA | SQL Server
Sunday, March 08, 2009 7:34:17 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [1]  |  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.
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
# 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, 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