A prototype is not a Minimum Viable Product (MVP)

Minimum Viable Product (MVP) is a term that I hear used a lot, and the concept seems pretty simple. Yet it is too frequently misused in place of prototype by junior developers and non developers (management).

From: Steve Neiland: Blog of a Web Developer

Senior Developers vs Master Developers

We need to do away with the term senior developer in the software industry. Here is why I propose we start using the term Master Developer.

From: Steve Neiland: Blog of a Web Developer

Rerunnable data update scripts for Microsoft SQL Server

We can implement a SQL Server equivalent of MySQL/MariaDB's "INSERT IGNORE" using MERGE INTO as follows...

From: Steve Neiland: Blog of a Web Developer

Rerunnable Data Update Scripts for MySQL/MariaDB

Using the INSERT IGNORE statement you can easily manage reference table's data using re-runnable sql scripts.

From: Steve Neiland: Blog of a Web Developer

Preventing Windows Ubuntu Dual Boot Superblock Corruption

Whenever I switch to ubuntu from windows on my dual boot system I get an error that the superblock is corrupt and I cannot load ubuntu until I fix the corruption using the command line. The issue appears to be windows messing from the ext4 partition.

From: Steve Neiland: Blog of a Web Developer

Resolving directory lookup error on SQLServer backup restore

Restoring a SQL Server database to a new server with a different file system structure can result in a Directory Lookup error since SQL Server makes assumptions about file locations. Fortunately there is a simple solution by using 'WITH MOVE'

From: Steve Neiland: Blog of a Web Developer

New Year - New Server - New Direction?

What happened with the blog and whats next

From: Steve Neiland: Blog of a Web Developer

Add a JQuery Validate rule for No Date Greater Than Today

Share this snippet from my archives for adding a JQuery Validate rule which disallows any date greater than today

From: Steve Neiland: Blog of a Web Developer

Populating a database column with an incrementing value

Here's a quick way to populate a table column with an incrementing value in sql server.

From: Steve Neiland: Blog of a Web Developer

You can sort on columns by their column number

While not a great idea, it is possible (at least in SQL Server) to order on a column by its numeric column number in the query.

From: Steve Neiland: Blog of a Web Developer

Delete duplicates but keep first record

Expanding on last weeks article about finding the most recent entry in each group we can apply the same technique to delete duplicate database entries while keeping the first original entry.

From: Steve Neiland: Blog of a Web Developer

Get the most recent entry for each group in sql server

To get the most recent entry for each named group within a sql server table table use partition and number rows by group as follows...

From: Steve Neiland: Blog of a Web Developer

Make jquery validate remote calls optional

Sometimes it is necessary to disable remote validation calls when using jquery validate, fortunately its fairly straight forward.

From: Steve Neiland: Blog of a Web Developer

We Have Replaced Everything

With the state of the world right now I don't feel motivated to post about technology today. So instead some observations of the world.

From: Steve Neiland: Blog of a Web Developer

You don't need to make everything an object

Creating objects in ColdFusion has a performance impact that you need to consider when working with large datasets

From: Steve Neiland: Blog of a Web Developer

GitKraken hook fails with error NPX does not exist in path

Using a node version manager can cause gitkraken pre-commit hooks to fail with an error that npx or npm does not exist in the path.

From: Steve Neiland: Blog of a Web Developer

Testing SQL with transactions

Have you ever accidentally deleted the entire contents of a table and had to go spend an afternoon restoring everything from backups? Transactions are here to help you test your sql without all that pain.

From: Steve Neiland: Blog of a Web Developer

AWS Console Change Password Screen Should Display Policy

This error when trying to change your AWS console password, 'Either user is not authorized to perform iam:ChangePassword or entered password does not comply with account password policy set by administrator' is a result of poor UX design.

From: Steve Neiland: Blog of a Web Developer

How to configure your default cfengine on commandbox

Thanks to Brad Wood for refreshing my brain about how to configure the default cfengine on commandbox.

From: Steve Neiland: Blog of a Web Developer

Add comma's to number in javascript

This is a utility function I've had around for formatting numbers into comma separated strings

From: Steve Neiland: Blog of a Web Developer