Monthly Archives: December 2018

SSIS Script Task Read Write Variable

Posted on December 27, 2018 by chanmingman

This post I wanted to post for quite a while but keep forgetting. In order to use Variable in SSIS Script Task there is no Intellisense. You have to remember the exact syntax for it. Very first you need to … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged SSIS Script Task Read Write Variable, SSIS Script Task variable | 3 Comments

SSIS Edit Script… not openning

Posted on December 21, 2018 by chanmingman

This post shows you one of the remedies when your Edit Script in SSIS is not opening in Visual Studio 2017. When you need to do is to uninstall the SSDT. Reinstall it with the option Install new SQL Server … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged SSIS Edit Script not openning | 2 Comments

MS Access VBA accessing to SQL Server

Posted on December 20, 2018 by chanmingman

This article expect you know how to create a Form with a button in Microsoft Access. Like it or not they are still many Microsoft Access users out there today, like a group that I am teaching today. Unfortunately C# … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged SQL Server VBA, vba access sql server 2016, vba sql server | 2 Comments

Microsoft Access Northwind 2016 accdb download

Posted on December 20, 2018 by chanmingman

To search the NorthWind template using Microsoft Access 2013 or 2016 may not work all the time. If you need a copy of accdb 2016 then you can get a copy here https://1drv.ms/u/s!AlUZkNIm6J4hgxoGNF28YaP80ukm.

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged access northwind, access northwind database, Microsoft Access Northwind 2016 accdb download, northwind accdb, northwind database | 2 Comments

Windows 8.1 RT disk space cleanup

Posted on December 16, 2018 by chanmingman

My Windows RT 8.1 in Surface RT only left with few 10s MB. I have tried many ways. Right click on C drive to clean up is totally meaningless here. Too bad that when Microsoft do update they have never … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged surface rt disk space, win rt cleanup, Windows 8.1 RT disk space cleanup, windows rt cleanup, windows rt disk space | 1 Comment

Ryzen 2500U Hyper-V

Posted on December 15, 2018 by chanmingman

If you are wondering whether Ryzen 2500U Hyper-V Can support Hyper-V. The answer is yes but you need to go to BIOS to enable the AMD SVM Technology.

Posted in .Net, Cloud, Community, Computers and Internet | Tagged amd ryzen hyper-v, hyper -v ryzen, Ryzen 2500U Hyper-V | Leave a comment

Microsoft documentation for end users, developers, and IT professionals

Posted on December 14, 2018 by chanmingman

Here is the new look of Microsoft documentation Microsoft documentation for end users, developers, and IT professionals. You can find Azure, Visual Studio, SQL. Somehow I am yet to find Office 365 there. https://docs.microsoft.com/en-us/?WT.mc_id=DP-MVP-36769

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

ASP.NET Web Form vs MVC facts

Posted on December 9, 2018 by chanmingman

In this short article you will know the actually fact how successful is ASP.NET MVC in the .NET world. WYSIWYG Microsoft has captured almost 70% of the programming back then around 1993-2008 if not more. That was because they were … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Office 365, sharepoint | Tagged asp.net mvc vs asp.net webform, asp.net webform vs asp.net mvc | Leave a comment

Windows Server 2019 .NET Framework 3.5 installation failed

Posted on December 7, 2018 by chanmingman

This post shows you how to install .NET Framework 3.5 Features in Windows 2019. I have Windows Server 2019 running. When I want to add a feature .NET Framework 3.5 Features. I checked the Internet was connected. But the installation … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet | Tagged Windows Server 2019 .NET Framework 3.5 installation failed | Leave a comment

SSMS SET IMPLICIT_TRANSACTIONS Side Effect to SSIS

Posted on December 4, 2018 by chanmingman

This post shows you the side effect to SSIS when you set the SET IMPLICIT_TRANSACTIONS in SSMS https://chanmingman.wordpress.com/2018/12/03/run-insert-update-or-delete-without-commit-in-ssms/. When you set the option SET IMPLICIT_TRANSACTIONS in SSMS. You may cause your SSIS to give you the following message when you … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged SSMS SET IMPLICIT_TRANSACTIONS Side Effect to SSIS | Leave a comment