Monday, April 06, 2009

Forgot...T-SQL Tidy Blog

Forgot to put this in previous post. I've created a blog for T-SQL Tidy. I've added a feed to the blog on the T-SQL Tidy site - I will post up the source when I get a chance.

Sunday, April 05, 2009

T-SQL Tidy

Its taken a while but I've finally put version 0.1 of T-SQLTidy.com live.

I was debugging some complex SQL - I was spending most of the time just formatting the SQL because I could find the problem.

I wrote a small program to reformat the SQL, but it was very simple and only delt with a small number of cases, it made me realise that it would be a large undertaking to make it 'usable' - so the idea was shelved. Until a few weeks ago I was a Dev Week 09 and listening to Greg Low's SQL 2008 for developers talk, he was takling about how complex the SQL parser is - but we should check out a couple of web sites...so I did.... www.T-SQLTidy.com is the result.