164 - The Pros and Cons of Single Page Websites - Updated

The Pros and Cons of Single Page Websites – Updated

When you're in the initial planning stages of a brand new web design, it's crucial that you decide on the site structure. Your two options are the traditional multi-page website or the single page alternative. Multiple page websites have long been considered the norm, with...

90 - The One2create Website Challenge

The One2create Website Challenge

We are always up for a challenge here at One2create, although we are usually pulling rabbits out of the hat for our customers rather than ourselves.   As a busy agency we hardly ever get a chance to look at our own website and as a result,...

169 - Top Tips for your Online Shop

Top Tips for your Online Shop

Do you have a product to sell and are thinking of launching an e-commerce website Here are some things to consider before you jump into the online shop world!   Is it worth it?   First things first – research, research, research. Conduct surveys, give out samples and really...

81 - The BIG Benefit of Databases for Small Businesses

The BIG Benefit of Databases for Small Businesses

One2create were recently approached by Craft Focus to share our knowledge on the benefits of databases for small businesses.   One2create, web development , creative design and marketing experts explain the major benefits of using databases for even the smallest of businesses.   Databases, they don’t sound like the...

45 - Add Modulo Magic to your Formulae

Add Modulo Magic to your Formulae

Become a Modulo Magician and add this trick to your arsenal…   What is it and how do I use it?   Do you remember doing division back at school? Numbers which wouldn’t divide neatly into each other were always a pain. Before you got onto the tricky stuff...

42 - SQL - Finding and Removing Duplicates

SQL – Finding and Removing Duplicates

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 DuplicateSearch) [No of Rows], ID_Column FROM...

19 - A unique approach to compressing graphics

A unique approach to compressing graphics

XAML & SVG PATH COMPRESSOR   Common image compression techniques are usually found in bitmap files such as JPEG and PNG, and allow a file to be downloaded quickly and then automatically expanded at runtime.   Vector image compression is also possible with the SVGZ format, but it requires...