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!!!
I've now added the option to download the SQL Server Version List.
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!!
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')
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!
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!
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.
