Category Archives: programming

Debug T-SQL using Visual Studio

Posted on May 14, 2024 by chanmingman

This blog article shows you how to how to debug T-SQL statements using Visual Studio. In the blog article Querying All Tables in a Database Using Dynamic SQL in Microsoft SQL Server we have the SQL code as follows. Start … Continue reading →

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

Add GitHub Copilot to Visual Studio

Posted on May 12, 2024 by chanmingman

This blog article shows you how to add GitHub Copilot Completion and GitHub Copilot Chat to Visual Studio 2022. This article expects you to know how to create a Console App in Visual Studio 2022. The figure below is before … Continue reading →

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

Querying All Tables in a Database Using Dynamic SQL in Microsoft SQL Server

Posted on May 11, 2024 by chanmingman

Are you dealing with a database where you need to query every table, but you’re not keen on writing out individual SELECT statements for each one? Microsoft SQL Server offers a solution through dynamic SQL and cursors, enabling you to … Continue reading →

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

Azure Storage download files using PowerShell

Posted on May 11, 2024 by chanmingman

This blog article shows you how to download the file from Azure Storage folder using PowerShell. Below is the code snippet to download the files from Azure Storage Container. Connect-AzAccount -Tenant TanantId -Subscription SubscriptionId $resourceGroupName=”resourcename”  $storageAccName=”accname”  $directoryPath=”document” $container = “container” … Continue reading →

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

JavaScript Calls Web Api

Posted on May 7, 2024 by chanmingman

This blog article shows you how to call a C# Web Api using JavaScript. For JavaScript to call the Web Api, you might need to add the CORS allows code in Program.cs in your Web Api like below. app.UseCors(builder => … Continue reading →

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

Create Web Api using Visual Studio C#

Posted on May 6, 2024 by chanmingman

This blog article shows the basics on how to create Web Api using Visual Studio 2022. Start Visual Studio 2022. Click on Create a new project. In the search box, type web api, choose ASP.NET Core Web Api. Click Next. … Continue reading →

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

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

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