Installing SQL Server 2017 for Linux on Ubuntu 18.04 LTS

[UPDATE as of 2018/11/21 at the end.] Prior to SQL Server for Linux 2017 CU10 the package dependencies prevented install on Ubuntu 18.04 LTS. The SQL Server 2017 installation packages have updated use the libssl1.0.0 package, allowing installation to occur on Ubuntu 18.04 LTS installations. Ubuntu 18.04 LTS was updated and ships with version 1.1…


MySQL with Entity Framework Core in ASP.NET Core

.NET Core offers.NET developers a great way to create cross-platform applications. If you want to create a web app with some database support, most likely you will use Entity Framework (EF) Core and ASP.NET Core. In this blog post, I’d like to give you some tips if you choose to use MySQL. 1. Db Provider…


Release: SQL Server Migration Assistant (SSMA) v7.9

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? Each iteration of the…


Using the Registry to Test the New Japanese Era on Windows

[Updated to include 令和 (Reiwa) instead of the test entry] Japanese Era Registry Key I’ve posted about using the registry to test for the Japanese Era before (Win7+) — some folks were looking for a little more guidance, so I created a couple registry files to help out. Japanese calendar eras are enumerated in the…


Why does my Azure Function sometimes stop being triggered

I moved this post to its new home here: https://benperk.github.io/msdn/2018/2018-08-why-does-my-azure-function-sometimes-stop-being-triggered.html Azure is so awesome because the features it provides are so very dynamic and flexible.  The platform provides a starting point for the fruition of ideas, ideas only limited by ones imagination.  With its dynamic nature and the flexibility it delivers to consumers, sometimes you just…


SCOMHelper PowerShell Module – A SCOM Admin’s Best Friend

(installation instructions at bottom) There are a number of cool scripts that I’ve collected, borrowed, and written in my travels as a SCOM field engineer and PowerShell enthusiast. I decided to put them all together into one module for easier maintenance and use. Enjoy. SCOMHelper Module Functions:   New-SCOMClassGraph First and foremost my pride and…