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).
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.
We can implement a SQL Server equivalent of MySQL/MariaDB's "INSERT IGNORE" using MERGE INTO as follows...
Using the INSERT IGNORE statement you can easily manage reference table's data using re-runnable sql scripts.
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.
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'
What happened with the blog and whats next
Share this snippet from my archives for adding a JQuery Validate rule which disallows any date greater than today
Here's a quick way to populate a table column with an incrementing value in sql server.
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.
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.
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...
Sometimes it is necessary to disable remote validation calls when using jquery validate, fortunately its fairly straight forward.
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.
Creating objects in ColdFusion has a performance impact that you need to consider when working with large datasets
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.
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.
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.
Thanks to Brad Wood for refreshing my brain about how to configure the default cfengine on commandbox.
This is a utility function I've had around for formatting numbers into comma separated strings
