Format T-SQL as HTML and more...

I've just added some new features to the T-SQL Tidy website.

Format the T-SQL into HTML (for blogs and web sites).

More formatting options than you can shake a stick at.

New Web Service call "ParseSQLwithOptions". http://www.tsqltidy.com/SQLTidy.asmx?op=ParseSQLwithOptions

Special thanks to Jean-Claude Manoli for the HTML formatting code website:http://www.manoli.net/csharpformat/

SQL Source Control

Just released a beta of SQL Version Tracker.

It's a version control utility that is integrated into SQL Server Management Studio 2008 and SSMS 2008 Express.

Simply install the Add-in to Management Studio and enable it on your database.

It will track all the changes on the schema of the SQL Server databases.

Feel free to download and try it!! But most importantly give me feedback!!!

SQL Server Version List update (part 2)

I've now added the option to download the SQL Server Version List.

You can download it in XML or CSV formats.

SQL Server Version List update.

As well as adding a couple of new versions to SQL Server version list to the list, I've added the the ability for people to added any missing versions.

• Simply go to the SQL Server version list, scroll to the bottom of the list and enter the missing version information

New Release of T-SQL Tidy Add-in for SQL Server Management Studio 2008

Beta 2 of the T-SQL Tidy Add-in for SQL Server Management Studio 2008 has just been released.

New features include;

• Support for SQL Server Management Studio 2008 Express Edition
• Feedback when T-SQL does not format correctly.
• Script data to: Update and Upsert now supported.
• Version checker now added - so you will be alerted when a new version is available.
• Can now script tables that are called database keywords.

Still on the to do list;

• Add support for SQL Server 2005 Management Studio.

T-SQL Tidy Add-in for SQL Server Management Studio 2008

I have just released the first (early) ‘beta’ of the T-SQL Tidy Add-in for SQL Server.

The add-in is a collection of 3 free tools;

T-SQL Tidy – Formatter of SQL statements.

SQL Version Checker – Reports the service packs and patches of the SQL Server.

Script Data to.. – Scripts the insert statements for a table to a file or new query window.

Over time I hope to add more tools to the collection.

Feel free to leave any feedback or suggestions for new features.

P.S. Did I mention this is free? Download it now!!

What version of SQL Server are you running?

I've added a new facility to identify how patched your instance of SQL Server is;

1) Find out your SQL Server version - if you don't know, here is a link to the Microsoft site that will tell you how to.

2) Go to the following "SQL Server Version List" web page.

3) Enter your version number in to the box.

Easy as that!!

Useful SQL:

SELECT @@Version

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

New Features

I’ve added a new page to the web site called ‘Experiments’.  This is were I will put new things before they live.

The first Experiment is a ‘T-SQL formatting as you type’ applet. 

Just start typing in the text area and it will create a formatted SQL statement in the area below.  I’m surprised no one has done this before!! 

Enjoy!

Moved hosting (at short notice)….

The T-SQL Tidy website has disappeared from its original web host.  I was in the process of updating the site and putting it onto its new home….but it looks like I’ve had to accelerate my plans somewhat.

I’ve decided to go with the new design, although its still ‘fluid’. 

Which is were I ask for feedback! 

I’m going to start work on the next feature-set for T-SQL Tidy, so I would like a bit of feedback about the site.  What features would you like on it? What does work (very well) and what doesn’t work?

All feedback will be award a prize of my respect and adoration for a minimum of 30 working days. No refunds will be given!

Visits from Redmond…

I was obsessively checking my Google Analytics over the weekend when I noticed a hit from Redmond.

I did some digging around and found out it was from Microsoft Corp – In fact it was 4 visits over a couple of months (see pic).  It made me feel smug…. for at least 15 minutes.

Of course, it’s probably some automated bot. But for a couple of moments I thought it could actually be a human, beavering away in a cubicle in Redmond – what a dreamer I am.

New Web Service, Stats and tracking

Been meaning to do an update for a while. Finally got around to it this morning.

I've created a new Web Service for non-Microsoft (all) clients. It's a simplified version of the existing web service. The test page contains all the source code (Javascript) required for using the Web Service.

Although this site is new (just a few months old), I thought it would be interesting to display the usage statitics. The stats show how many Tidies have been done (for Today, Last 7 days, Last Month and Year).

I've also added a 'Share' button, so people can now add TSqlTidy.com to their favourite social networking site. Please, please, please use it! :-)

Free hosting coming to an end...

I was just looking at my hosting provider (http://aspspider.com) and there was an odd message, "Your website is already expired and all files will be deleted soon. Please back up all your files." (in red!).

When I checked the message boards, I found they have changed their free hosting from only having a limit on disk space to now being time limited; 90 days.

Of course the gravy train has to stop somewhere and I can see why being the only company that offer free asp.net hosting and be a bit of an overhead.

The long and short of it means that http://www.tsqltidy.com has to move - and I'm going to have to pay! 

Hopefully I will have sorted a new home out before they remove the site completely.