Category Archives: Servers

Permissions for ‘key.pem’ are too open When accessing Azure Linux

Posted on May 16, 2024 by chanmingman

This blog article shows you one of the possible ways to eliminate the error message “Permissions for ‘key.pem’ are too open”. In a Azure VM installed with Ubuntu, you can get the pem key for SSH to login by using … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Operating System, Servers | Tagged | Leave a comment

Upgrade Hyper-V from Generate 1 to Generate 2

Posted on February 3, 2024 by chanmingman

This blog article shows you how to convert a Hyper-V machine from Generation 1 to Generation 2. Firstly, you need to merge all the checkpoints into one, which also means no more checkpoints. Start the VM after merging then type … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Operating System, Servers | Tagged | Leave a comment

Python type list cannot be converted

Posted on May 1, 2023 by chanmingman

This blog article shows you one of the reasons you get the error “Python type list cannot be converted”. I have a code snippet below to extract the test from csv and pass it in as parameter to MySQL, same … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, programming, Servers | Tagged | Leave a comment

ADO.NET Read MySQL Database

Posted on April 21, 2023 by chanmingman

The blog article shows you how to read MySQL using ADO.NET. Firstly, import the required namespaces: using System.Data; using MySql.Data.MySqlClient; Establish a connection to the MySQL database: string connectionString = “server=localhost;database=world;uid=root;password=123456”; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); Define the SQL … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle, Servers | Tagged | 3 Comments

Hyper-V Add Disk Space to Existing VM

Posted on April 6, 2023 by chanmingman

This blog article shows you how to add disk space to the existing Hyper-V Virtual Machine. In Hyper-V Manager right click on the VM you wish to add the hard disk space then select Settings… Click on Hard Drive. Select … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Operating System, Servers | Tagged | 1 Comment

MySQL Source Data for SSIS

Posted on March 31, 2023 by chanmingman

This blog article shows you how to use SSIS to connect to MySQL as Data Source and its common problems. This article expects you to have basic SSIS knowledge. To use MySQL as the Data Source. First, create an SSIS … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Servers | 1 Comment

MySql ODBC Connection not appearing SSIS

Posted on March 26, 2023 by chanmingman

This blog article, a short one, shows you one of the possible reasons why MySql ODBC Connection does not appear in SSIS connection. This article expects you to have basic knowledge of SSIS. When I right click on the Connection … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Servers | Leave a comment

SQL Server Table Memory Optimization Advisor

Posted on January 15, 2023 by chanmingman

This blog article shows you how to use Memory Optimization Advisor. When I right click and select data from a database table in the SSMS, the Memory Optimization Advisor pops up. You can manually right click the database table and … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Operating System, Servers | Tagged | Leave a comment

Run C# Program in Windows Subsystem for Linux (WSL)

Posted on January 1, 2023 by chanmingman

This blog article shows you how to create a simple C# program and run inside WSL. You need to install .NET, run the following commands to add the Microsoft package signing key to your list of trusted keys and add … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Operating System, Servers | Tagged , | 1 Comment

Do more with less with the Microsoft Cloud

Posted on December 3, 2022 by chanmingman

Today’s business leaders must adapt quickly to challenges – from supply chain disruptions to increasingly sophisticated cyberthreats to the evolving needs of hybrid work. In this rapidly changing world, it’s critical to maximise the value of your investments with technology … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, Microsoft Office, Office 365, Operating System, Servers, sharepoint | Tagged | 1 Comment