Tuesday, April 27, 2010

T-SQL for SQL Server 2005 to Shrink database to smallest size possible.

How can you shrink a SQL Server 2005 database to the smallest size possible? Using the below script will do the trick.

Thanks to Pinal Dave for help with log portion!

Sunday, April 25, 2010

CSV Microsoft Encoding a la C# .NET

Small, little method to do CSV encoding of values. It's brute force, but works.

Wednesday, April 21, 2010

A quick example of how to xmlpoke using NAnt an appSettings value that does not exist.

The below is an example of how to use NAnt to xmlpoke a new appSettings key and value xml element into a web.config. The same could be used for an app.config as well. In fact, it could be used generically on how to poke completely new XML elements into any XML document.