Formatting SQL

Useful WebsitesAt the start of March last year, I posted about a site you can use to format SQL by pasting it in or uploading a file. That site is still present and working, but I’ve found a new website which formats SQL more to my liking (thinking specifically of formatting some of the Microsoft Dynamics GP stored procedures).

The new site I’m using is SQL Formatter from DevArt:

SQL Formatter

The SQL in the above is from my SQL View to Return Budgets by Month post.

Using the options to the right, you can change how the SQL is formatted, so you can alter how the SQL is formatted to make it closer to your required output.

I prefer a web based solution as I sometimes need to format SQL when I’m working on a client system and don’t have access to my own laptop, so one of the tools which can install into SQL Server Management Studio aren’t always usable.

Reduce size of JPEG or PNG images

Useful WebsitesI’ve been doing some work on both my websites and the plugins I’ve developed for ClassicPress in order to make improvements. One of the areas I am aware of is that the images I am using are larger than they could be.

It is possible to compress PNG or JPEG images without any loss of quality. I’ve used a couple of tools to compress the screenshots I’ve already uploaded, without being especially happy with any of them, so I’m not going to recommend anything in that area.

However, I’ve been happier with an online tool called TinyJPG which you can use to compress images:

Tiny Jpg website

As you can see from the image above, a few images I ran through the tool resulted in an overall compression of 57%. This will save me both storage and bandwidth on the website. I am using the free version which allows you to upload up to 20 images up to 5MB in size at a time; they do have a paid service available which does not have these restrictions.