Monthly Archives: December 2019

Hadoop installation in Windows 2016 Server

This post shows you the installation of Hadoop in Windows 2016 Server but you might face the warning like I do. If you follow the step of https://muhammadbilalyar.github.io/blogs/How-to-install-Hadoop-on-Window-10/ then you can be successfully setup Hadoop in a Windows Server. Few … Continue reading

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

Migrate to Microsoft SQL Server

This post shows you the tools you can use when migrating your data to Microsoft SQL Server. Compatibility Certification https://docs.microsoft.com/en-us/sql/database-engine/install-windows/compatibility-certification?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 What is Azure Database Migration Service? https://docs.microsoft.com/en-us/azure/dms/dms-overview?WT.mc_id=DP-MVP-36769 Overview of Data Migration Assistant https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 Overview of Database Experimentation Assistant https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant-overview?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 SQL … Continue reading

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

Disk Cleanup without dialog

This post shows how to clean up disk without dialog and prompting. First you need to select what you want to clean by typing the following command. cleanmgr /sageset Tick all the files you would like to clean up. Then … Continue reading

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

Microsoft Machine Learning Server

Somehow Microsoft has a Machine Learning Server. This post shows you some resources if you want to know more. What is Machine Learning Server https://docs.microsoft.com/en-us/machine-learning-server/what-is-machine-learning-server?WT.mc_id=DP-MVP-36769 Install and configure Machine Learning Server https://docs.microsoft.com/en-us/machine-learning-server/install/machine-learning-server-install?WT.mc_id=DP-MVP-36769 Install Machine Learning Server for Windows https://docs.microsoft.com/en-us/machine-learning-server/install/machine-learning-server-windows-install?WT.mc_id=DP-MVP-36769 Quickstart: … Continue reading

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

Develop IT staff competencies using Competency Based Interview

This post shows you a technique to develop IT staff competencies using Competency Based Interview (this is a management post not technical article). There are 3 steps but not simple steps. You need a lot of thoughts in it. 1. … Continue reading

Posted in management | Tagged , | Leave a comment

SQL Tools for Microsoft SQL Server

This post dhows you where to get the graphical and command line SQL Tools. SQL tools overview Graphical tools: https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 Download SQL Server Management Studio (SSMS) https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 Download and install Azure Data Studio https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 Download and install SQL Server Data … Continue reading

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

SSIS Visual Studio 2019 Flexible File Destination

This post shows you how to use Flexible File Destination from Azure Feature Pack. The pre-requisite is you need to know SSIS, you have Azure account and you have installed Azure Blog Explorer. Lastly you need Azure Feature Package, https://chanmingman.wordpress.com/2019/12/15/ssis-visual-studio-2019-azure-feature-pack/. … Continue reading

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

SSIS Visual Studio 2019 Azure Feature Pack

This post is to show you the new feature for Visual Studio 2019 SSIS. You can download the Azure Feature Pack for Integration Services (SSIS), https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15?WT.mc_id=DP-MVP-36769 , if you want to try the Azure feature in SSIS. You need to … Continue reading

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

Export GridView Records to CSV Using ASP.Net C#

The post is to correct the code in the post https://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-records-to-csv-using-Asp-Net-C-Sharp/. This code will never work, have a try but gives you the idea how to get the code correct. The working code as below. private void ExportGridToCSV() {     Response.Clear(); … Continue reading

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

ASP.NET Popup Yes/No Dialog box

ASP.NET Web Form is still one of the fastest ways to build a simple web site. Yes/Cancel dialog you need to achieve it using JavaScript like the one below. <asp:Button ID=”myButton” runat=”server” Text=”Delete” onclientclick=”return confirm(‘Are you sure you want to … Continue reading

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