Monthly Archives: June 2022

Democratizing Transformation

Posted on June 29, 2022 by chanmingman

Many companies struggle to reap the benefits of digital transformation investments while others see enormous gains. What are the successful companies doing differently? Find out in Democratising Transformation, a Harvard Business Review Analytic Services report sponsored by Microsoft. In this report, … Continue reading →

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

List all columns in SQL Server Table

Posted on June 26, 2022 by chanmingman

This blog article shows you how to list all the columns in SQL Server database Table. The SQL statement looks simple, somehow it is not easy to remember. The follow SQL statement list all the columns from Northwind database Products … Continue reading →

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

Modernising Applications and Data

Posted on June 25, 2022 by chanmingman

There are a lot of options to consider when it comes to choosing an approach to application and data modernisation. To learn real-world strategies that work, read Modernising Applications and Data: The View from Customers Who Have Taken the Journey with … Continue reading →

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

CTO June 2022 articles and resources

Posted on June 20, 2022 by chanmingman

These are the good reads found in this month. Why management is both art and science Much of the controversy around management being art or science is based on description of the fact that the earlier leaders of industry used … Continue reading →

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

SSIS Azure Blob Source

Posted on June 19, 2022 by chanmingman

This blog article shows you how to use the Azure Blob Source in SSIS. You can watch the video at the bottom to follow. You should have an Azure trial account. The source file from the Azure Blob Storage is … Continue reading →

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

The Impact of Non-Cluster Index SQL Server

Posted on June 18, 2022 by chanmingman

This blog article shows you the impact of Non-Cluster Index SQL Server by reusing the code provided by the video below. The below script will Create Database, Create Table, Queries to compare before and after the Non-Cluster Index. Create the … Continue reading →

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

Drive Innovation and Business Value Through Cloud Modernisation

Posted on June 14, 2022 by chanmingman

Fuel innovation and quickly adapt to changing business needs by moving your apps, data and infrastructure to the cloud. Read this free eBook to find out how to build a cloud migration strategy that will help you optimise costs, enhance … Continue reading →

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

Get top 1 row of each group Excel

Posted on June 12, 2022 by chanmingman

This blog article shows you how to get top 1 row of each group Excel. This has the same effect as Get top 1 row of each group SQL Server. This blog expects you to do how to execute VBA … Continue reading →

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

Gradient Descent using Python

Posted on June 11, 2022 by chanmingman

This blog article tests the Gradient Descent using Python. One of the reasons Python is so popular is, it builds in many scientific functions like Gradient Descent. After watching the video Overview | Stanford CS221: AI (Autumn 2019). I have … Continue reading →

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

Get top 1 row of each group SQL Server

Posted on June 11, 2022 by chanmingman

This blog article shows you how to get top 1 row of each group. What do I mean by that, One of my trainees shows me the SQL Statement and the data below. SELECT * FROM Contracts Then she said … Continue reading →

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