This year, Sport England are going to appoint one city in the UK as the first ever City of Football. This prestigious accolade brings with it £1.6 million of National Lottery Funding which will be invested in the winning city to allow them to run
Working in a creative agency means we all have tonnes of ideas floating around the office pretty much all the time. However, like everyone else, we sometimes hit a massive creative block. Everyone has experienced a lack of motivation or creativity at some point, especially
Got a to do list as long as your arm? Struggle to keep focused on your work? Check out these great apps and websites that you can install on your computer or phone to help keep you focused, organised and smash out your work super
There is a growing trend for businesses to use video animation to help market themselves in a very demanding digital world. Customers and consumers desire instant information and want to receive it in the best possible way. An original animation or video can go a long
TIP 5 : SPACE BAR SELECTIONS Another beginner tip, this one’s a massive help for quick edits. It’s also a bit of a lifesaver that goes hand in hand with the last tip , copy merge. Making a selection is easy, you select
The following blog post is the first in a series that will get you thinking in depth about your online presence, and ensuring that you are moving in the right direction to maximising your return on investment. We are going to kick things off
TIP 4: COPY MERGE The discovery of Copy Merge was one of those lightbulb moments, where you think “Why has it taken me so long to realise Photoshop does this?” Need to copy a selection of your choosing but Photoshop doesn’t seem to want
With the use of a CTE and the ROW_NUMBER() ranking function, you can easily find, and delete, any duplicates in a table. First, let’s take a look at the code you’ll need within your CTE: SELECT ROW_NUMBER() OVER (PARTITION BY DuplicateSearch ORDER BY
TIP 3: ALWAYS WORK ON A COPY Tip three is a quick one, ALWAYS WORK ON A COPY! You can’t imagine the amount of issues this causes whilst using Photoshop. When making destructive changes to an image the first thing you should be doing
Imagine the scene. You walk into an art gallery to find nothing on the walls – no framed or glassed masterpieces, just empty space…Oh and that big cloud in the middle of the room of course. This is the work of Berndnaut Smilde –
