Home
Alessandro Melandri
Cancel

VMware and SQL Server Best Practices

We love VMware in our SQL Server consulting practice. But there are some things you should know and do first. These aren’t deep and mysterious secrets. But they’re things we see a lot of folks s...

Apache virtual host basic template

This is where I start when I have to configure an Apache server: a simple virtual host template with ssl rewrite. <VirtualHost *:80> ServerName my.domain.com ServerAlias my.domain.c...

How to create products with the least amount of complexity

A truly simple product is built around a deep understanding of the problem it’s meant to solve. This is challenging because it requires us to set aside our way of thinking and develop empathy fo...

How to setup CrashPlan Cloud Backup on a Synology NAS

A very detailed post about setting up CrashPlan Cloud Backup on a Synology NAS running DSM 5.0 Remember, any good backup strategy follows the Backup Rule of Three. 3 copies of anything you c...

Acrobat Forms - Execute javascript on document open

This is a simple trick to run a javascript code while opening an Acrobat Form. I use it very often in server side generated forms to change the required flag based on fields value. You need to add...

Remove .DS_Store Files From A Git Repository

Remove existing files from the repository: find . -name .DS_Store -print0 | xargs -0 git rm -f --ignore-unmatch Add the line .DS_Store to the file .gitignore, which can be found at the top level...

Removing orphaned users from a SQLServer database

If you are using SQLServer probably you had to restore a database from a backup and got stuck with an orphaned user that was no more associated with a login. Microsoft provides a stored procedure ...

Welcome to iPhone 6, friend

We have spent countless hours engineering the thinnest, most powerful smartphone in the world onto which you will now put a case. We have burned untold person-years, an innumerable number of lif...

Custom notifications for a specific status change in Jira

The default Jira notification scheme sometimes might look like a spam bot, especially if you have a lot of users actively using it, so for one of our project we decided to create an empty notificat...

Update table with data from another table using SQL

A simple but useful SQL snippet that lets you update a table using data from another table UPDATE Table1 SET Table1.col1 = Table2.col1, Table1.col2 = Table2.col2 FROM Table1 ...