Monthly Archives: April 2024

Azure Storage Filter Last Modified Date

Posted on April 28, 2024 by chanmingman

This blog article shows you how to filter the files from Azure Storage by Last Modified date. The snippet of the PowerShell as follows. Connect-AzAccount -Tenant TenantId -Subscription SubscriptionId $resourceGroupName =” resourceGroupName “ $storageAccName =” storageAccName “ $directoryPath =”document” $container … Continue reading →

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

Responsible AI guidelines for decision makers

Posted on April 28, 2024 by chanmingman

Discover resources and strategies to help you prioritise responsible AI as you build and modernise your intelligent apps. In this eBook, Responsible AI Guidelines for Decision Makers: Best Practices for Intelligent Apps, learn more about Microsoft’s approach to responsible AI … Continue reading →

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

VBA Loop to Office.js Loop

Posted on April 27, 2024 by chanmingman

This blog article shows you how to do the VBA Loop in Office JS. This article expects you to have basic VBA knowledge. I have a VBA to loop through the column A as follows: Sub LoopA() Range(“A1”).Select While (ActiveCell.Value … Continue reading →

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

How to raise the bar on customer relationships using AI

Posted on April 24, 2024 by chanmingman

Organisations can usher in a new era of customer relationship excellence and business innovation by taking advantage of AI in CRM platforms. Read the eBook to learn how to: Deepen customer engagement. Deliver personalised experiences at scale, fostering deeper customer … Continue reading →

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

Extract Date Number from Date

Posted on April 20, 2024 by chanmingman

This blog article shows you a code sample on how to extract the date number from the date data type. I was testing this using GitHub Copilot. As you can see from the following screenshot. I prompt the Copilot to … Continue reading →

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

Find Primary Key and Foreign Key Dependencies of Database Table in MS SQL

Posted on April 20, 2024 by chanmingman

This blog article shows you how to find dependencies of Database Table in MS SQL. If you get the SQL statement correct, then it is quite straightforward. The SQL statement below will give you the dependencies. SELECT                FK_Table = … Continue reading →

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

Assembly Language with Visual Studio Code

Posted on April 13, 2024 by chanmingman

This blog article shows you how to run Assembly Language using Visual Studio Code. This article expects you to have already used Visual Studio Code somewhere. Open Visual Studio Code, click on the Extension. Install MASM/TASM. Click on Explorer. Add … Continue reading →

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

CTO April 2024 articles and resources

Posted on April 13, 2024 by chanmingman

  These are the good reads found in this month. Low-code and no-code development gets a makeover as priorities shift to AI It’s probably too soon for inexperienced developers to work directly with generative AI. But once AI is embedded … Continue reading →

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

Find Dependencies of Database Table in MySql

Posted on April 12, 2024 by chanmingman

This blog article shows you how to find dependencies of Database Table in Mysql. If you get the SQL statement correct, then it is quite straightforward. The SQL statement below will give you the dependencies. select distinct ref.referenced_table_name Source_Table, tab.constraint_name, … Continue reading →

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

Using SWITCH to Replace CHOOSE in Power Query Excel

Posted on April 12, 2024 by chanmingman

This blog article shows you how to use SWITCH in Power Query Excel. In Excel, you have Choose function. An example is like the following. = Choose (Weekday(A2), “Sunday,”, “Monday,” “Tuesday,” “Wednesday,” “Thursday,” “Friday,” “Saturday”). Unfortunately, there is no Choose … Continue reading →

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