Microsoft Access Northwind 2016 accdb download

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.

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

Windows 8.1 RT disk space cleanup

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 done a good job to remove the unused file.

I spent almost a day to try to fix the space. The closer link is the one below.

https://support.microsoft.com/en-my/help/4037673/surface-refresh-or-reset-surface-rt-or-surface-2

There is one option here You need to Reset your Windows with the option like Remove all files from user which not directly mentioned in the above link.

You got to Settings > Change PC settings. Select Update and recovery > Recovery. Is the right path. That free up to 20GB for me.

The hopeless links that not resolving any problem for me.

https://www.itworld.com/article/2714040/mobile/free-up-storage-space-on-your-microsoft-surface-rt-device.html

https://www.groovypost.com/howto/recover-4gb-disk-space-microsoft-surface-windows-rt/

https://www.groovypost.com/tips/disable-automatic-windows-8-1-app-updates/

https://answers.microsoft.com/en-us/windows/forum/all/win-81-rt-winsxs-folder-keeps-growing/9dd782b8-e734-4617-b1db-4b29e5014d5c

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

Ryzen 2500U Hyper-V

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 , , | Leave a comment

Microsoft documentation for end users, developers, and IT professionals

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=36769

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

ASP.NET Web Form vs MVC facts

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 providing the programming with fastest way to learn and code. The very populate platform at that time is Winform with Visual Basic. The end product and the development process was seamless because of What You See Is What You Get (WYSIWYG)

In year 2002 Microsoft eliminated a nightmare ASP 3.0 which was using VB Script with HTML by providing the friend. Microsoft came out with ASP.NET Webform another (WYSIWYG). Once again C# became the most happening programming language worldwide.

The change

Not too long later, there was a group of amateur developer like to challenge themselves with no sense of business and kept complaining ASP.NET Webform is slow because of that milliseconds (ms), the business really don’t care actually.

Then this group of people has created MVC. The intention was good so ASP.NET developer has a choice between Webform and MVC. Somehow this was not the case. The intention I have been seeing, after developing web solution officially or unofficially using ASP.NET, was Microsoft wanted to fade away ASP.NET Webform. One very good example was, you could only get ASP.NET MVC as the official ASP.NET training in some of the training centers. Some more they would tell you ASP.NET Wenform was obsolete. You could try to find the ASP.NET Webform training in http://learning.microsoft.com.

Hello world

Try yourself to do a Hello Word program like this one https://www.youtube.com/watch?v=zFYoskhjt0Q. How are you doing this in ASP.NET MVC? You can try to search in youtube and see what you get. In order to do a Hello World in ASP.NET you only an aspx file and a code behind cs file. How many files do you need to the same thing in ASP.NET MVC?

Some guys might even tell you go and do that with HTML and JavaScript. The question is if I am using HTML and JavaScript I can use Eclipse to do it, I do not need Visual Studio.

How the University is teaching

When you type “asp.net syllabus university” in google search, click on all the links on the first page then you will see Server Controls in the syllabus. Lectures are human, they will pick what is easy to teach and what is easy for the student to learn. No lecture wants to challenge themselves because they might have a family to go back to. They might have elderly to take care. No one wants to spend 10 hours to do the job if they can be achieved by 2 hours. Unless the final performance of the end product it completely crab but is ASP.NET that bad?

Database access component

ASP.NET Webform GridView and ListView can bind to the database such as SQL Server very easily. I don’t see ASP.NET MVC can bind to any database directly to the View like what the ASP.NET Webform can do. At the end of the people is moving to Angular js or maybe React js then the Razor view despite how Microsoft forcing the developers to use it. The survey here is showing that https://developer.telerik.com/topics/net/asp-net-intersections-developers-share-2017-platform-choice/ .

The final thought

I believe What You See Is What You Get (WYSIWYG) is still, if not all, most of the developers are looking for. Microsoft can import on ASP.NET Webform by even changing the tag such as <TextBox> to <input type=”text”>. In this case, the tag will no longer be proprietary. The developers out there are looking for a tool can provide that what you see is what you get like Winform, WPF, or even the newer UWP. Today I can see what make C# alive is actually SharePoint CSOM, SSIS, and other projects than the Web project. Microsoft should rethink before Java swallow the C# market share. This is 2016 https://www.codingdojo.com/blog/9-most-in-demand-programming-languages-of-2016/. We all remember that once upon a time C# has been far in front of Java.

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

Windows Server 2019 .NET Framework 3.5 installation failed

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 failed.


I managed to fine a workaround from Youtbe https://www.youtube.com/watch?v=EQ7-rlLx-qo. You need to Specify an alternative source path when came to Confirm Installation selections.


Make sure the iso file is still mounted and is in D Drive then you enter the Path D:\sources\sxs. Click OK. Click Install.


You should be able to get your .NET Framework 3.5 Features install.

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

SSMS SET IMPLICIT_TRANSACTIONS Side Effect to SSIS

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 are opening and running some T-SQL command in SSMS.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component “Script Check Record Exist 1” (2) failed with error code 0x80131904 while processing input “Input 0” (13). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

To resolve this I close the SSMS. Before it closes, it you pop the message below. That also means you have enable the SET IMPLICIT_TRANSACTIONS option.

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