Monthly Archives: December 2023

NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported

Posted on December 30, 2023 by chanmingman

This blog article shows you one of the possible ways to resolve the error “NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported” in Python. I accidentally install mysql-connector. After that I got the following error. I have tried the following but … Continue reading →

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

Write a C# Program to Export Database Table in MS SQL Server to PDF

Posted on December 30, 2023 by chanmingman

This blog article shows you how to write a C# Program to Export Database Table in MS SQL Server to PDF. This code snippet uses the System.Data.SqlClient namespace to connect to the MS SQL server and retrieve the data from the customers … Continue reading →

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

Write a C# program to export database table in MS SQL server to Excel sheet

Posted on December 29, 2023 by chanmingman

This blog article shows you how to write a C# program to export customers table in MS SQL server to Excel sheet using NPOI. Microsoft.Office.Interop.Excel is only for .NET Framework and can no longer be used in .NET 5 and … Continue reading →

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

Create a Data Dictionary for MySQL Database using Python

Posted on December 28, 2023 by chanmingman

This blog article shows you how to create a Data Dictionary for MySQL Database using Python. To generate a data dictionary from a MySQL database using Python, you can use the mysql-connector-python library to connect to the database and query … Continue reading →

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

Fibonacci using C++ with Matrix

Posted on December 25, 2023 by chanmingman

This blog article should you how to do Fibonacci calculation using C++ with Matrix. In mathematical terms, the sequence Fn of Fibonacci numbers is defined by the recurrence relation. Fn = Fn-1 + Fn-2 Below is the code extracted from … Continue reading →

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

How to recover from MS SQL Server Service that is stuck in the starting state

Posted on December 22, 2023 by chanmingman

This blog article shows you how to recover from MS SQL Server Service that is stuck in the starting state. When you open windows Services and check, your SQL Server Service gets stuck in the starting state. Double the SQL … Continue reading →

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

Microsoft Digital Defense Report

Posted on December 20, 2023 by chanmingman

Build resilience against the constantly changing threat landscape with a clear picture of the state of cybersecurity and indicators that can help your organisation predict the next moves of attackers. Read the just-released edition of the annual Microsoft Digital Defence Report to: … Continue reading →

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

6 Tips to Integrate Security into Your DevOps Practices

Posted on December 20, 2023 by chanmingman

Ship more secure, compliant software faster by embedding security practices into your day-to-day app development and management. Learn how to build a collaborative DevSecOps program that breaks down business silos using the best practices, tools and resources in this eBook. … Continue reading →

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

How to Create Microsoft SQL Server Stored Procedure

Posted on December 19, 2023 by chanmingman

This blog article shows you how to get started with Microsoft SQL Server Stored Procedure. I am achieving this using SSMS. I am using northwind sample database. To create the Stored Procedure, expand the database in my case, Northwind. Expand … Continue reading →

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

Prime Number using C++ and Vector STL

Posted on December 17, 2023 by chanmingman

This blog article shows you how to check for Prime Number using C++. This article also shows you how to determine the Prime Number in Vector collection. Firstly, you need to have the below function to determine whether the number … Continue reading →

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