Asp.NET Tips

Great news for small startup companies. Microsoft has launched a program called WebSiteSpark for individual developers and small web startup companies (less than 10 employees). Following are software licenses which will be given for 3 years for free 3 licenses of Visual Studio 2008 Professional Edition 1 license of Expression Studio 3 (which includes Expression Blend, Sketchflow, and Web) 2 licenses of Expression Web 3 4 processor licenses of Windows Web Server 2008 R2 4 processor licenses of SQL Server 2008 Web Edition DotNetPanel control panel (enabling easy remote/hosted management of your servers) More of information at: http://www.microsoft.com/web/WebSiteSpark

If you are writing windows application in .Net you should know that your code is not secure. Using free and popular tools like .NET Reflector anyone can easy understand any part of your code. Do you still have something to do with it? Not too much. Here is articles that have good overview of problems described before: http://www.improve.dk/articles/dotnet/securing-dotnet-code/ http://www.yoda.arachsys.com/csharp/obfuscation.html http://www.howtoselectguides.com/dotnet/obfuscators/ Does .Net applications is insecure

Following SQL will return stored procedures that using supplied string: CREATE PROCEDURE [dbo].[proc_FindTextInsideSP] ( @s varchar(50) ) AS SET NOCOUNT ON; SELECT ROUTINE_NAME, CREATED, LAST_ALTERED FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%' + @s + '%' ORDER BY ROUTINE_NAME; RETURN;

Whatever you are developing I'll recommend to run this tool agains your site. It's free, fast and doing exactly what I expected from tool that should look for broken links. The description of the tool is saying " Xenu's Link Sleuth (TM) checks Web sites for broken links."

Using simple algorithm the credit card number can be validated. Each credit card type has his own rules for numbers to start from and for lengh of the number. IssuerIdentifier Card Number Length Diner's Club/Carte Blanche 300xxx-305xxx,36xxxx, 38xxxx 14 American Express 34xxxx, 37xxxx 15 VISA 4xxxxx 13, 16 MasterCard 51xxxx-55xxxx 16 Discover 6011xx 16 Following article explains in details what means digits in credit card numbers. More full example with source code can be found here .

There a lot of debates about how to store custom fields in database. Here is some interesting links that help me to get decision (in my case is EVA solution :-)) Storing Custom Fields in the Database (see also comments) - http://blog.springframework.com/arjen/archives/2008/01/24/storing-custom-fields-in-the-database/ Thread from forum - http://osdir.com/ml/bug-tracking.bugzilla.devel/2005-01/msg00191.html Guide to the EAV (FAD) - http://weblogs.sqlteam.com/davidm/articles/12117.aspx http://en.wikipedia.org/wiki/Entity-Attribute-Value_model The circumstances where you would need to go beyond standard row-modeling to EAV are listed below: The data types of individual attributes varies (as seen with clinical findings). The categories of data are numerous, growing or fluctuating, but the number of instances (records/rows) within each category is very small. Here, with conventional modeling, the database’s Entity-Relationship Diagram might have...