The personal blog of Jamie Phillips

A blog about software development and other random musings.

Intel NUCs for Development

Intel has been creating these really small machines called NUC, Next Unit of Computing, for more than a few years. I purchased my first one last year, the NUC7PJYH, which has the quad core Pentium Silver. I built it out with 2x4GB 2400Mhz RAM and a 256GB Samsung 850 EVO only running various flavors of Linux. This little machine has been a dream, the small size combined with the rock solid support for Intel products in the Linux kernel has made it a pleasure to use to perform work. It has HDMI 2.0 and is able to drive my LG 34in Ultrawide 3840 x 1440 without any issue, all ports are USB 3.0, and a thunderbolt port. It's also very queit and doesn't produce any noise. I plan to take the NUC7PJYH and install a server Linux distro. I will configure it to be a TeamCity server as I want to be able to perform my own local builds. I will post back on that once I get completed.

Getting started using Azure AD Auth with an Azure SQL Database

If you don't know, you can use Azure Active Directory Authentication with Azure SQL Database. The documentation includes the basics, but I wanted to outline the steps and additional information that I have learned. You can connect using SQL Server Management Studio, Azure Data Studio, and SQL Server Data Tools if you use the AD with MFA options. Here are my recommendations for setup and some watch outs.

SQL Server on QNAP NAS

I run an Intel NUC model NUC7PJYH as my desktop development environment using some Linux distro as my OS. I have been doing some tinkering using SQL Server on Linux, and by the time I spin up docker and the SQL Server container, it starts taking up some resources on my little NUC that I just don't want to give up. I have a QNAP NAS sitting next to me that has an Intel processor and can run QNAP Container Station. I don't use that NAS for much other than photos and some backups, so I am going to put it to work running a SQL Server on Linux container. Here is how I accomplished getting it to run.