Monthly Archives: May 2023

OpenAI ChatGPT API using Python

Posted on May 28, 2023 by chanmingman

This blog article shows you how to call ChatGPT API using Python. This blog article expects you to know how to use Jupyter. Firstly, need to install the openai library using the following command. pip install openai The code below … Continue reading →

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

OpenAI ChatGPT using C#

Posted on May 27, 2023 by chanmingman

This blog article provides you with the C# code snippet to call ChatGPT API from C#. You can see almost identical code snippets on many articles in the Internet. The code snippet is as follows. static void Main(string[] args) { … Continue reading →

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

Select ActiveCell Value using Office Script Excel

Posted on May 27, 2023 by chanmingman

This blog article shows you one example on how to get a value on particular Excel Sheet Cell. In VBA to get a value at cell B2 for example, the code is as follows. Dim rng As Range Set rng … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, Operating System, programming | Tagged | 2 Comments

Excel compare the Row in different Worksheet using VBA

Posted on May 24, 2023 by chanmingman

This blog article shows you how to compare the row in 2 different Excel Sheets using VBA. In order to do that you must have a unique identifier for the rows. The below code will loop through both Sheets and … Continue reading →

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

Microsoft 365 Office Scripts

Posted on May 18, 2023 by chanmingman

This blog article shows you how to get started with Office Scripts. You can only have Office Scripts in Microsoft 365. Microsoft Office perpetual license products do not support Office Scripts so you still need to use VBA. To start … Continue reading →

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

MySQL Backup and Restore Database

Posted on May 16, 2023 by chanmingman

This blog article shows you one of the methods to backup and restore MySQL database. You can see from the HeidiSQL there is a database in MySQL named world. To backup the database, use the mysqldump command as following. mysqldump … Continue reading →

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

CTO May 2023 articles and resources

Posted on May 14, 2023 by chanmingman

These are the good reads found in this month. 12 ways to maximize your cloud investments Assemble a cross-functional cloud team Define baselines and (realistic) expectations Build a full business case… https://www.cio.com/article/465322/12-ways-to-maximize-your-cloud-investments.html 6 steps to measure the business value of … Continue reading →

Posted in .Net, Cloud, Computers and Internet, CTO, Data Platform, management | Tagged | Leave a comment

Split DateTime column into Day, Month, Year column SQL Server

Posted on May 14, 2023 by chanmingman

This blog article shows you how to split DateTime column into Day, Month, Year column in SQL Server, this is only for Microsoft SQL Server or Azure SQL. After you have the DateTime column, which you will have it in … Continue reading →

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

How to create a row for every day in a date range using a stored procedure

Posted on May 13, 2023 by chanmingman

This blog article shows you how to create a date column in Database Table and populate it with the date range you want This is very handy if you want to create a date dimension for your data warehouse. The … Continue reading →

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

Python Machine Learning Tutorial (Data Science)

Posted on May 7, 2023 by chanmingman

This blog articles provides you with some code for the video Python Machine Learning Tutorial (Data Science), https://youtu.be/7eh4d6sabA0. This will save you sometimes to type the code when you learn through the tutorial. Also: ‘jupyter’ is not recognized as an … Continue reading →

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