Category Archives: Data Platform

SSIS Parallel Data Source using OFFSET…FETCH NEXT

This post shows you how to divide huge single table data extracting in SSIS to multiple parallel data source using the T-SQL offset and fetch next feature. The pre-requisite is you need to have a knowledge on SSIS and T-SQL. … Continue reading

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

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

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

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