Monthly Archives: February 2021

VBA get rid of empty rows in between

Posted on February 28, 2021 by chanmingman

This blog article shows you how to write VBA code to get rid of the empty rows in between, for example, between One and two you have 3 empty rows. This article expects you to have basic knowledge of VBA. … Continue reading →

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

Could not load file or assembly ‘System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’

Posted on February 28, 2021 by chanmingman

This blog article shows you one of the possible ways to resolve the error “Could not load file or assembly ‘System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a‘”. Go to web.config file. Search for “b03f5f7f11d50a3a‘. You will see a XML tag as below. <dependentAssembly> … Continue reading →

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

SQL Server use GUI to edit more than 200 rows

Posted on February 27, 2021 by chanmingman

This blog article shows you one of the methods to edit SQL Server table more than 200 rows without writing code. But you need to have Microsoft Access. If you have Office 365 then likely you will have Microsoft Access. … Continue reading →

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

Blazor WebAssembly using Visual Studio Code

Posted on February 27, 2021 by chanmingman

This blog article shows you how to create a Blazor App using Visual Studio Code. You can follow this page here, http://bit.ly/3uwRzzI, but it has less graphics and some step is no longer accurate. 1. Download Visual Studio code, https://code.visualstudio.com/download … Continue reading →

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

Restore Replication Publisher Database

Posted on February 24, 2021 by chanmingman

This document shows you how to backup and restore SQL Server Publisher database. In the document I am using northwind database but in your case then you will use the production Publisher database. Backup the publisher database To backup the … Continue reading →

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

Use app_offline.htm for IIS maintenance

Posted on February 20, 2021 by chanmingman

This blog article shows you how to direct the IIS site to maintenance page without touching your production web application. The article expects you to have basic Internet Information Server (IIS) basic knowledge. You can create a file with the … Continue reading →

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

SQL Server create Maintenance Plan to Rebuild Index

Posted on February 20, 2021 by chanmingman

This blog article shows you how to create SQL Server Maintenance Plan to Rebuild Index. The below step will create a SQL Server Maintenance Plan for Rebuild index, update statistics, and free procedure cache. To start, open SQL Server Management … Continue reading →

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

Add HTML Page to ASP.NET MVC project

Posted on February 17, 2021 by chanmingman

This blog article shows you how to add html page in ASP.NET MVC project. I am actually utilizing angular-route.js. This article expect you to know how to create a ASP.NET MVC project. Under the project structure, create myscript folder under … Continue reading →

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

VBA Intellisense not working

Posted on February 14, 2021 by chanmingman

This blog article shows you the possibilities why VBA Intellisense is not working. You need to fix all the Runtime errors. You see the code below. It has 3 problems. 1. Scripting.Dictionary library is actually not referring to. 2. There … Continue reading →

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

CTO February 2021 articles and resources

Posted on February 12, 2021 by chanmingman

These are the good reads found in this month. CTO Guide To The Business of Cloud Computing What Is Cloud Computing? Due Diligence Assessments and Cloud Computing Cloud Computing Companies in the CTOvision Disruptive Technologies Directory https://ctovision.com/guide-to-cloud-computing/ 7 keys to … Continue reading →

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