SQL 2014 Security Updates

It has been a busy time. I've moved house, moved country and moved jobs. Things have happened fast but the dust is starting to settle and I'll soon get into a swing of posting more often. A few things of note for February 2020, other than the Covid 19 virus, were:

SQL Security update.

There was a SQL Security Update in February for SQL 2014.

Ignore the mistake in the prerequisite section referencing SQL 2016 version. This update is for SQL 2014 only and  should read: "To apply this update, you must have SQL Server 2014 SP3 or any SQL Server 2014 SP3 CU release through SQL Server 2014 SP3 CU4 installed."

VS Code is rather good.

I have been writing SQL and PowerShell side by side for a couple of projects and have really started to enjoy VS Code (https://code.visualstudio.com/) where I can code and execute solutions in both languages in the same enviroment. Occasionally this makes my life easier. The code formatters are also a "nice to have", especially when managing legacy code.

PowerShell is also rather good.

Finally, it is easy to get a file's hash value using the powershell command get-filehash. If you want to check that your download is correct, you don't have to install additional utilities to check file hashes.

<< Go back to the previous page