Geeks With Blogs

News My Blog has been MOVED to
Michael Freidgeim's OLD Blog My Blog has been MOVED to 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 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 ......

Posted On Saturday, February 28, 2009 5:32 PM

3-D Secure credit card verification Links
Overview: 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 : Verified by Visa and MasterCard SecureCode:or, How Not to Design ......

Posted On Sunday, February 22, 2009 12:29 PM

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

Posted On Saturday, February 21, 2009 6:50 PM

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

Posted On Thursday, February 12, 2009 9:13 PM

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

Posted On Monday, February 2, 2009 10:27 PM

Copyright © Michael Freidgeim | Powered by: