adsense

Monday, June 27, 2011

ASP.NET AJAX CollapsiblePanelExtender - Tips and Tricks

Here are some useful tricks for the AJAX collapsible panel. I wanted to programmatically expand the collapsible panel but only succeed it when I set CollapsiblePanelExtender1.ClientState = "false";

http://www.dotnetcurry.com/ShowArticle.aspx?ID=230

Cheers,
samitha






Thursday, June 23, 2011

XLSExport

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.


cheers
samitha


Saturday, June 11, 2011

Choosing the Right Join

What do SQL joins and the "teach a man to fish" Chinese proverb have in common? SQL joins, like regular expressions, are one of those commonplace programming tasks in which true success is entirely dependent upon your ability to conceptualize the outcome. Fail to do so and you'll likely wind up spending a few hours in a frustrating round of trial and error. Like regular expressions, the proliferation of online examples has actually contributed to the frustration, providing the equivalent of a day's worth of fish rather than the proverbial fishing pool

read more
http://www.developer.com/db/3-sql-join-concepts-to-help-you-choose-the-right-join.html

cheers
samitha

Index Management

This article demonstrates an Index Management strategy to tackle day to day performance issues due to improper indexes.  

read more
http://www.sqlservercentral.com/articles/Indexing/68079/


 cheers
samitha
 


Tuesday, June 7, 2011

Encrypting Custom Configuration Sectionsa

This includes both the connection string and machine key sections.  See Scott Guthrie's post for some good references.  Note that if your application runs in a clustered environment you will need to share a custom key using the RSA provider as described in an MSDN article.

regards
samitha