Monthly Archives: August 2022

Insert row(s) Into SQL Server Table Using PowerShell

Posted on August 31, 2022 by chanmingman

This blog article shows you how to use insert records into SQL Server Table Using PowerShell. Below is the sample code snippet to insert record into a table. The Products table is the same as the one in Northwind database. … Continue reading →

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

PowerShell Execute SQL Server Stored Procedure

Posted on August 31, 2022 by chanmingman

This blog article shows you how to execute Stored Procedure in SQL Server using PowerShell. I test all these scripts using PowerShell ISE. Firstly, if you have not installed the SQL Server PowerShell module then run the following script. Install-Module … Continue reading →

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

Key takeaways from public-sector digitalization in South-East Asia

Posted on August 30, 2022 by chanmingman

Key Findings The pace of digital transformation has accelerated 71.3% for government agencies Covid-19 has spurred greater investments in technology for 90.7% of public-sector agencies Currently, budget constraints and legacy systems are the biggest barriers to government’s digital transformation. But within … Continue reading →

Posted in Uncategorized | Leave a comment

ML.NET Schema mismatch for label column ‘column_name’: expected Single, got String

Posted on August 30, 2022 by chanmingman

This blog article shows one of the possible ways to resolve the error “Schema mismatch for label column ‘column_name’: expected Single, got String”. You may bump into this error when following the steps in ML.NET Machine Learning with SQL Server … Continue reading →

Posted in Uncategorized | Leave a comment

Steps Toward Building More Sustainable Organisations

Posted on August 29, 2022 by chanmingman

According to a December 2021 Harvard Business Review Analytic Services survey, many companies are struggling to meet their sustainability goals. Learn how to drive your sustainability efforts with smart strategies and digital solutions in Steps Toward Building More Sustainable Organisations, a … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform, News and politics | 2 Comments

CTO August 2022 articles and resources

Posted on August 29, 2022 by chanmingman

These are the good reads found in this month. Ransomware attacks are rising, but paying up won’t keep your data safe says NCSC Ransomware is the biggest cybersecurity threat facing the world today, with the potential to significantly affect whole … Continue reading →

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

ML.NET Machine Learning Value Prediction with SQL Server

Posted on August 24, 2022 by chanmingman

This blog article shows you how to use ML.NET with the data from SQL Server. First, create a Console App using .NET 6. Click Next. Type the name of the project, in this example, ConappKLDBRec. Click Next. I believe .NET … Continue reading →

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

SSIS The type is not supported.DBTYPE_DECIMAL

Posted on August 23, 2022 by chanmingman

This blog article shows you one of the possibilities to resolve the error “The type is not supported.DBTYPE_DECIMAL”. I have a SSIS variable name varValueDate, the data type set to Decimal. I have My database table column ValueDate with the … Continue reading →

Posted in Uncategorized | Leave a comment

Using data to boost supply chain resiliency

Posted on August 19, 2022 by chanmingman

The past couple of years have brought significant supply chain disruptions – but the right strategies and technologies are helping manufacturers adapt quickly, minimise risk and stay competitive. Check out this supply chain infographic to see the trends helping manufacturers … Continue reading →

Posted in Uncategorized | Leave a comment

Ransomware-as-a-Service: How it works and what it means for defenders

Posted on August 18, 2022 by chanmingman

Ransomware-as-a-Service (RaaS) isn’t just a threat, it’s a whole economy. With it, low-skill attackers gain access to sophisticated tools – increasing the number of operators that can successfully execute a ransomware attack. Learn more about this growing threat in Ransomware-as-a-Service: … Continue reading →

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