Anything But SourceSafe

Source Control: Anything But SourceSafe ->
Visual SourceSafe Version Control: Unsafe at any Speed? ->
Visual SourceSafe: Microsoft's Source Destruction System ->

Source Control HOWTO ->

Article "Version Control for Multiple Agile Teams" by Henrik Kniberg

CSS contents and browser compatibility

Checks Web sites for broken links.

Xenu screenshot report

It is hard to live without tool like Xenu's Link Sleuth in today Internet age. This tool help me with projects at work. I scanned this blog and found that I need to do some cleaning here as well.

"Xenu's Link Sleuth (TM) checks Web sites for broken links. Link verification is done on "normal" links, images, frames, plug-ins, backgrounds, local image maps, style sheets, scripts and java applets. It displays a continously updated list of URLs which you can sort by different criteria. A report can be produced at any time. "

Tuning Up SQL Server 2005 Databases

Work around for XML data type not supported in Distributed Queries

Cast(a.XML_Data as XML) as XML_Data
Cast(XML_Data as Varchar) as XML_Data
) A

Basically, the data is queried on the remote server, converts the XML data to a varchar, sends the data to the requesting server and then reconverts it back to XML.

StephenDudzic at 2007-9-3 22:09:22 >

"Re: XML data type not supported in Distributed Queries This is a limitation in SQL Server 2005. Columns of xml type or CLR type cannot be queried directly or referenced from one server to another - this means the following:
  1. You cannot use a table or view that contains xml or clr type as 4-part name in your query
  2. You need to cast the column to either nvarchar(max) or varbinary(max) or other appropriate type to use
  3. If you have a table that has xml type for example then you need to create a view that contains all columns other than xml and query it instead. Or you can issue a pass-through query using OPENQUERY with the appropriate columns only."