Anything But SourceSafe

Source Control: Anything But SourceSafe -> http://www.codinghorror.com/blog/archives/000660.html
Visual SourceSafe Version Control: Unsafe at any Speed? -> http://www.developsense.com/testing/VSSDefects.html
Visual SourceSafe: Microsoft's Source Destruction System -> http://www.highprogrammer.com/alan/windev/sourcesafe.html

Source Control HOWTO -> http://www.ericsink.com/scm/source_control.html

Article "Version Control for Multiple Agile Teams" by Henrik Kniberg  http://www.infoq.com/articles/agile-version-control

CSS contents and browser compatibility

http://www.quirksmode.org/css/contents.html
http://en.wikipedia.org/wiki/Comparison_of_layout_engines_(CSS)
http://www.thenoodleincident.com/tutorials/box_lesson/boxes.html

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

http://www.w3schools.com/sql/sql_select_into.asp

Work around for XML data type not supported in Distributed Queries

http://www.msdner.com/dev-archive/84/19-85-847101.shtm

SELECT
Cast(a.XML_Data as XML) as XML_Data
FROM OPENQUERY([LINKED SERVER NAME HERE],'
SELECT
Cast(XML_Data as Varchar) as XML_Data
FROM
[DATABASE NAME].[SCHEMA].[TABLE NAME]'
) 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."