Monthly Archives: February 2022

CTO February 2022 articles and resources

Posted on February 27, 2022 by chanmingman

These are the good reads found in this month. Quantum computers: Eight ways quantum computing is going to change the world 1. DISCOVERING NEW DRUGS 2. CREATING BETTER BATTERIES 3. PREDICTING THE WEATHER… https://www.zdnet.com/article/quantum-computers-eight-ways-quantum-computing-is-going-to-change-the-world/ Recruiting tech workers is getting harder. … Continue reading →

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

Where to find SQL Agent in Admin Pack for SQL Server for Azure Data Studio

Posted on February 26, 2022 by chanmingman

This blog article shows you how to reach the SQL Agent in Azure Data Studio. First, you need to install the Admin Pack for SQL Server extension in Azure Data Studio. Connect to your SQL Server. Right click the Server … Continue reading →

Posted in Uncategorized | Leave a comment

Exclusive access could not be obtained because the database is in use

Posted on February 24, 2022 by chanmingman

This blog article shows you one of the possible ways to resolve the error “Exclusive access could not be obtained because the database is in use” when restoring a database. Scenario: I have a database named Northwind in SQL Server … Continue reading →

Posted in Uncategorized | Leave a comment

Difference between Protected Internal and Protected modifier C#

Posted on February 20, 2022 by chanmingman

This blog article is to show you the difference between Protected Internal and Protected modifier. For example, the 2 classes in the below code are in the same namespace but the compiler will give the error “‘BaseClass.myValue’ is inaccessible due … Continue reading →

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

Get Connection String from appsettings.json Console App

Posted on February 20, 2022 by chanmingman

This blog article shows you how to read the connection string from appsettings.json. First you need to create a appsettings.json with the following content after you creating a .Net Core Console App. {     “ConnectionStrings”: {       … Continue reading →

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

SQL Server COUNT Function using LINQ

Posted on February 19, 2022 by chanmingman

This blog article shows you a possible way to use the COUNT function in SQL Server with retrieve all the rows then count them. You can either use the function below. public static void Count1() {     using (var context = … Continue reading →

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

Five Steps to Simplify Your Data Mart and BI Solution (ebook)

Posted on February 16, 2022 by chanmingman

Discover how to map, manage and modernise your organisation’s data solutions by migrating your legacy data mart and online analytical processing (OLAP) workloads to Azure Synapse Analytics. Download the eBook, Five Steps to Simplify Your Data Mart and BI Solution, for … Continue reading →

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

Mathematical Induction Proof using Programming Language

Posted on February 13, 2022 by chanmingman

This blog article shows you an example on how you can convert Algorithm to programming language. I read this book Art of Computer Programming Volume 1 by Donald E. Knuth. In page 11, I saw the interesting concept of Mathematical … Continue reading →

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

Get the Biggest Number Among 3 Numbers in T- SQL

Posted on February 13, 2022 by chanmingman

This blog article shows you how to compare 3 numbers to get the biggest number using T-SQL. The T-SQL code as below. — Declare 3 variables DECLARE @firstcount INT DECLARE @secondcount INT DECLARE @thirdcount INT — Assign the values to … Continue reading →

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

LIKE operator in LINQ

Posted on February 11, 2022 by chanmingman

This blog article shows you one way to operate as the LIKE operator in LINQ. You can actually imitate the LIKE operator in SQL Statement using Contains in LINQ. But don’t do it likevar result1 = myList.Contains(“701112”); because the above … Continue reading →

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