Today I’m flying back from the UK, all day. Usually this is roughly a 20+ hour day for me to return home, so I’m not likely to do much work. You get to read a republish: Are you a Data Scientist?
Author: way0utwest
-
Initialize-HgsServiceName Fails in VMWare
A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others.
I had a VMWare Workstation v12.x VM of SQL Server 2016 and was working with this tutorial on Always Encrypted with Secure Enclaves. In setting up the HGS server, I got to step 3 which has this code:
Initialize-HgsAttestation -HgsServiceName 'hgs' -TrustHostKey
When I ran this, I got an error:
That’s not good. In trying to find why this won’t run, eventually, I realized that my VMWare system needs the Microsoft Virtualization Based Security. This isn’t an option in my older VM, I believe because this is
a) v12 and not v14+
b) BIOS firmware
You can see my settings here:
Fortunately I had an upgrade for VMWare available and updated to v15, and then build a new VM as a v14+ hardware version. This gave me UEFI and once the VM was shut down, I could check the VBS box.
After doing this, I could move forward with my secure enclave config.
-
Republish: The History of the VCS
In London today, or actually likely still at Heathrow working in an airport hotel. Tomorrow is SQL in the City, so today you get: The History of the VCS
-
More Software Quality with DevOps and CD
Tomorrow is the SQL in the City Summit in London. Right now I’m in a Heathrow airport hotel, finalizing some prep for the event. I have to run a panel as well as give a talk, Building quality into your continuous delivery process, that will cover some of the ways that we can improve quality by moving to DevOps.
That’s a passion of mine because I want better software quality. I know it’s hard, believe me, after the SQLServerCentral migration, I remember how hard it is. I also know that this was a few steps forward with a few backward, and across time, this is a big move forward.
That’s how DevOps will go, especially as you implement it. That was some of what we did, with a complete change in underlying architecture, a software pipeline, and new methods for deploying changes. It’s painful, and we likely went too soon, but we also had external constraints that forced some change.
Hopefully I’ll see some of you tomorrow and have some advice for you on how to improve quality within your organization. Culture is the big item, and I talked a bit about this at SQL in the City Streamed. Watch that and let me know what you think.
