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