Skip to content

Coding Practice

Learn SQL at the SQL Zoo

Of all the (programming) languages you can learn, I think SQL is the one that will help you the most throughout your career as a software developer. If you know the basics of SQL, you can solve set based problems directly in your database without writing a ton of code to do the same in an imperative way. And your applications will run much faster if they only fetch the data you really need.

How to Import Data From Web Sites Into Excel

Did you ever need to put a table from a web site into an Excel file? If so, you probably used copy & paste and then fixed all the formatting errors and wasted a lot of time.

There is another way you may not be aware of: Excel has an import feature to load data from web sites (and many more formats like PDF files).

How to Transfer Files From One Synology NAS to Another

Synology builds great NAS (Network Attached Storage) devices. For 9 years my DS1512+ worked like a charm. It still works, but since it reached the end of support it is time to move to another device – the DS1618+. The big question I had was how do I move the files from one NAS to the other? As it turns out, there is a surprisingly simple yet robust way to do that.