Monthly Archives: February 2023

Case Studies in Cloud Modernisation

Posted on February 27, 2023 by chanmingman

See how purposeful innovation thrives with an ally in the cloud. Find out how five organisations adapted to rapidly changing circumstances in recent years and set themselves up for long-term success with Azure. Read this eBook to learn how these … Continue reading →

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

Power Automate Desktop Write Log to Database

Posted on February 24, 2023 by chanmingman

This blog article shows you how to write the error from Power Automate Desktop to a log to database. This article has a dependency article Power Automate Desktop Write Log to Test File showing you how to add On block … Continue reading →

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

CTO February 2023 articles and resources

Posted on February 20, 2023 by chanmingman

These are the good reads found in this month. 7 tell-tale signs of fake DevOps 1. Placing DevOps in a silo 2. Focusing on tools over people2. Focusing on tools over people 3. Too little automation… https://www.cio.com/article/419248/7-tell-tale-signs-of-fake-devops.html What do customers … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, management, Microsoft Office, News and politics, Office 365, Operating System | Tagged | Leave a comment

Power Automate Desktop Write Log to Text File

Posted on February 19, 2023 by chanmingman

This blog article shows you how to write the error from Power Automate Desktop to a log text file. I have a Power Automate Desktop flow to copy file. To handle the error, I drag and drop the On Block … Continue reading →

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

Accelerate innovation, achieve agility and build on a comprehensive platform

Posted on February 15, 2023 by chanmingman

Bring all your data together with a unified solution – and build on that foundation with machine learning tools and advanced analytics. Discover a comprehensive data and AI platform that unifies databases, analytics and governance. Delve into this infographic and … Continue reading →

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

SSIS Execute Stored Procedure using Execute SQL Task component

Posted on February 14, 2023 by chanmingman

This blog article shows you how to Execute Stored Procedure using SSIS Execute SQL Task component. I have a Stored Procedure named uspCountOrders created in Northwind Database to pass in the Order Id and get the Output count. The Stored … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 2 Comments

Ask ChatGPT to write ADO.NET to select all the rows from Products table in Northwind database

Posted on February 12, 2023 by chanmingman

This blog article shows you how to use the trial version of ChatGPT. Go to https://openai.com/blog/chatgpt/ then click on TRYCHATGPT. I login using my gmail account then asked the following question. How to write ADO.NET to select all the rows … Continue reading →

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

SSIS Dynamic Flat File Connection

Posted on February 11, 2023 by chanmingman

This blog article shows you how to dynamically assign the filename to Flat File Connection by using Variable. The article expects you to know Flat File Connection Manger in SSIS. When you have a Flat File Connection Manager, double click … Continue reading →

Posted in Uncategorized | Leave a comment

Explore Azure OpenAI Service

Posted on February 10, 2023 by chanmingman

With Azure OpenAI Service, now generally available, you’ll access advanced AI models that are backed by the enterprise-grade capabilities and AI-optimised infrastructure of Azure. Create cutting-edge apps for almost any use case and run them confidently on Azure – a … Continue reading →

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

Using SQLCMD in Windows Subsystem for Linux (WSL)

Posted on February 9, 2023 by chanmingman

This blog article shows you how to install and run the sqlcmd in Windows Subsystem for Linux (WSL), Linux. All the commands are taken from the reference link at the bottom. You can group all the commands below into a … Continue reading →

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