DateTime formatting demonstration utilizing a multitude of temporal data formats available in SQL Server 2005/2008.

[Read more...]

From time to time the event where objects need to be cleared from a database without dropping the entire database and re-creating it may arise.  This script works to drop all user defined data types, tables, foreign keys, views, functions, constraints and stored procedures from the database executed against.  This script may need to be extended to include any object types not listed that may reside within your database.

[Read more...]

From time to time you may notice that the tables tied to the built-in DotNetNuke site search can grow quite large and in many cases consume large amounts of space.  This article defines a methodology to clear these tables and re-index the DotNetNuke site search.

[Read more...]

Conditionally Execute Code Based on Active Solution in Visual Studio

[Read more...]

Provides a generic method that can be utilized to programatically change the style sheet in an ASP.NET application.  This method can be extended by creating an additional method to pass in the name of the desired style sheet.

[Read more...]