Website updates...

I'm now working on a few updates for the T-SQL Tidy website while I take a break between Microsoft Certification exams.

There aren't any (huge) increases in functionality. I'll just fixed problems that annoy me. :-)

Fixes;
New menu - I did the old one in a rush so it didn't really work very well.
Updated blog feed - I sorted out the problems with the formatting.
Twitter account - I created a twitter account (Apparently social networking is the next big thing!)

SQLBits (episode) VI - Westminster Strikes Back...

After the hugely successful SQLBits V (in Newport), SQLBits VI has been announced today. It's going to be held at the Church House Conference Centre, London on the 16th April 2010.

Check out the SQLBits.com website for more details.

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.