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...
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,...
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...
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...
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...
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...
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...