Operand type clash: int is incompatible with uniqueidentifier (Source: MSSQLServer, Error number: 206)+

Don’t believe the MSDN advice: recreate your subscription. It’s unecessary when a little script will rectify the issue brought in...

Read More+ 3 years ago

Missing windows updates for other products?+

I just want to see “You receive updates: For windows and other products from Microsoft update”. You dreamer. Confused that...

Read More+ 3 years ago

Editing magento PDFs+

The invoice PDF files are stored here: /public_html/app/code/core/Mage/Sales/Model/Order/Pdf So to override, copy the root files and the /items/invoice/default.php file to...

Read More+ 3 years ago

In Google we trust+

What will make you let go of the wheel? What will make you accept seeing drones in the sky? And...

Read More+ 3 years ago
,

Tesco users’ passwords released but what can we learn?+

First let me clarify – this is not a sinister post. Just like we know a business or a person...

Read More+ 3 years ago
,

Find and fix the root issue in a MSSQL replication error+

Several errors can be generated during replication such as ‘Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the...

Read More+ 3 years ago
,

Learning Krita – sketch un+

Yesterday I found Krita. Today I have begun learning it. What’s Krita? Krita is a digital painting and illustration software....

Read More+ 4 years ago

Bulk image compression in C# – directory wide size and quality reduction+

As internet connections continue to improve their robustness and speed, time spent by web developers reducing the page load is...

Read More+ 4 years ago
, , ,

ECUPUP – logo creation, website design & build+

EcupUP were a new company when I tackled this mid-November 2013. As the company name suggests – they specialise in...

Read More+ 4 years ago
,

Master email design with UX+

Designing email isn’t just making it look the same on every app, on every device. It’s not just about subject...

Read More+ 4 years ago
,

Directly run a mySql query on magento for the best seller+

I have prefixed the tables “mag_”, please change to suit. SELECT product_id, sum( total_qty_ordered ) AS ‘total’, `value` AS product_nameFROM...

Read More+ 4 years ago
, , ,

WSUS client error 800B0001+

Following initial set up of WSUS I immediately hit a update error on the already updated clients, namely WSUS client...

Read More+ 4 years ago
, ,

OpenCart efficiency – logging viewed products+

OpenCart, straight out of the box, helpfully records products viewed. /catalog/model/catalog/product.php called from catalog/controller/product/product.php public function updateViewed($product_id) { $this->db->query(“UPDATE ”...

Read More+ 5 years ago
,

November’s coding horror+

Well it’s early, but I’m struggling to envisage another coding horror being able to beat this one.

Read More+ 5 years ago

Major SQL efficiency tip – drag and drop table column list in SSMS+

Most MSSQL DBAs know the object explorer in Microsoft SQL Management Studio has a heap of tricks that go mostly...

Read More+ 5 years ago

Proud to be British – free British Manufacturer images+

The Jubilee. The Euros. The Olympics. I have been totally swept away with patriotism – a fantastic shot of adrenalin...

Read More+ 5 years ago