Category: Windows

  • Automatically mount USB 3 attached to my wifi router

    As discussed here, I have Seagate Ultra Slim USB 3 attached to my wifi router as a NAS (Network-attached storage). It provides a good backup/sharing storage for my home network that’s accessible from all my home computing devices, which was nice. Accessing it from Windows is easy to set up, all I needed to do…

  • Accessing external USB disk attached to my ASUS RT-AC68U router

    I have my own cloud storage server using ownCloud for many years now, and love it. It’s like DropBox, only better. However, even with that, it’s still nice to have a shared storage for my home network. So today I bought a Seatate Ultra Slim USB 3 disk from Costco, with 2TB capacity. It is…

  • No 32-bit for SQL Server 2016 Express

    I’ve learned that SQL Server 2016 Standard and Enterprise Editions no longer provide 32-bit. But I do wonder about SQL Server 2016 Express Edition. It’s different in that it’s free, and mostly geared toward lightweight usage, people who are learning, etc. So perhaps it still offers 32-bit? After some upgrade work to one SQL Server…

  • Adding attachment to Outlook 2016 email

    A couple of months ago Outlook 2016 on my old PC (Windows 10) started misbehaving: Clicking “Attach File” to add an attachment from my PC to an email message; A window would show up. When it worked, I would be able to move the mouse down and click “Browse This PC…”. However, nowadays this window…

  • SQL Server best practice: grant permissions to per-service SID

    Since Windows Server 2008/Windows Vista, from SQL Server 2008 onward, SQL Server installation process automatically generates per-service security identifier (SID). Whenever possible, it is recommended to grant rights to this service SID for security reasons, instead of your SQL Server’s startup account, which typically is domain user account. For example, for performance reasons, I always…