Category Archives: Data Platform

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

CTO May 2024 articles and resources

Posted on May 12, 2024 by chanmingman

These are the good reads found in this month. Is Kubernetes worth it? · What to consider · The importance of a TCO analysis… https://www.infoworld.com/article/3714768/is-kubernetes-worth-the-price-tag.html How to set – and achieve – DEI goals in IT · Take stock · … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | 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 Migrate and Modernize

Posted on May 9, 2024 by chanmingman

Create highly differentiated digital experiences and deliver continuous innovation with Azure Innovate, a new offering to help you plan and deploy Microsoft solutions across apps, data and AI to build intelligent applications. Get started with the Azure Migrate and Modernize … Continue reading →

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

Six Strategies for AI Implementation

Posted on May 9, 2024 by chanmingman

Six Strategies for AI Implementation: Responsible AI practices on Azure Position your org for long-term success by responsibly implementing and scaling AI using Azure. Ensure compliance, mitigate risks,and build trust using the strategies for responsible and ethical AI in this … Continue reading →

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

Excel VLookup Common mistakes

Posted on May 3, 2024 by chanmingman

This blog article shows you the common mistakes that people make when creating VLOOKUP in Excel. For example, we want to find the price of the server like below. The first mistake is to start with the wrong column, The … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged | Leave a 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

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