Skip to content

2022

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).

SQL Server and Microsoft Defender: A Slow Combination

We are currently migrating our larger databases to SQL Server 2019. While the migration went smoothly for the small databases, there was an unexpected problem with the last server: the backup was incredibly slow.

The first larger database we moved to the new server took 10 times longer to back up than on the old server (50 minutes instead of 5). If the backup time would proportionally increase with the database size, our biggest database would use the whole maintenance window just for the backup task. We had to fix this problem immediately.

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.

Visual Studio 2022: An Improved Paste JSON as Classes

Visual Studio 2022 offers so many new features that we easily overlook how existing features have been improved. In today's post, I like to point out how "Paste JSON as Classes" got better and better. Pasting XML or JSON as classes exists since Visual Studio 2017. However, in Visual Studio 2022 you can work with complex object graphs that earlier Visual Studios could not handle.