February 2009 Entries

Stored procedure to find the biggest tables in the database

To find the biggest tables in the SQL Server database I am using good stored procedure EXEC dbo.sp_SOS @OrderBy='T' /*downloaded from http://media.techtarget.com... The related article "Find size of SQL Server tables and other objects with stored procedure" Valid @OrderBy parameters are: 'N' --> Listing by object name 'R' --> Listing by number of records 'T' --> Listing by total size 'U' --> Listing by used portion (excluding ......

3-D Secure credit card verification Links

Overview: http://en.wikipedia.org/wik... The Process Flow described in "3-D Secure. Further Technical Information" "Submitting Transactions in the XML Direct Model with 3 D Secure Guide" and "Verified by Visa Introduction"(chapter 4) The UPG Guide for 3D Secure Transaction Delivery Technical Details: Verified by Visa's "Merchant Implementation Guide" Concerns : http://www.computing.co.uk/... Verified by Visa and MasterCard SecureCode:or, How Not to Design ......

Using delicious to mark links "To follow-up"

I am using delicious to save bookmarks with tags, that describe the type of link(e.g. ASP.NET,AJAX etc), but not so often to find my own bookmarks. However often I want to make a note for particuler page, that I need to return back to read, print,copy code etc. For a long time I've used iGoogle gadget "TO-DO list" to save URLs to follow up, but it is not really convinient for URLs, and also required to save the URLs in 2 places. Recently I've got an idea, that I can have extra delicious tag/tags ......

Insert CSS link with updatable version number in URL

More than a year ago I wrote a post Code Render Blocks does not work inside HEAD server controls about the problem, that prevented me to update URL of CSS file, when version of assembly incremented. Now I've created a function /// <summary> /// /// </summary> /// <param name="page"></param> /// <param name="cssFileHref">e.g. "~/StyleSheet.css"</para... /// <returns></returns... public static HtmlLink AddStyleSheetLink(this Page page, string cssFileHref) ......

Validate eMail address using MailAddress.ParseValue

We have Regular Expression validator to validate the eMail address, specified by the users. It usually warn user about some common mistakes. But sometimes eMail address passes validation , but later causes exception in MailAddress.ParseValue called from MailAddress constructor. I decided to call MailAddress.ParseValue as a part of UI validator, but it's private. (I've asked MS to change it) So I had to open constructor inside try block and catch exceptions in case if format is wrong. Alternatively ......

«February»
SunMonTueWedThuFriSat
25262728293031
1234567
891011121314
15161718192021
22232425262728
1234567