Category Archives: Data Platform

Power BI Create Pie Chart for a single none numeric column

This post dhows you 2 options to generate a pie chart using single none numeric column. This post expect you know how to get the data from Power BI. As can see from the below table, there is a column … Continue reading

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

SQL Server Cannot generate SSPI context.

This short post shows you a tip of resolving the error “The target principal name is incorrect. Cannot generate SSPI context.”. The normally happen when you are connecting to SQL Server remotely using Windows Authentication. If you search on the … Continue reading

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

SQL Server Execution Plan eBook

This post suggests you to read the useful SQL Performance Tuning eBook. The first two chapters will be fine for you to understand many of the SQL executions and test the performance. Even though this need substantial amount of time … Continue reading

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

SSIS Script Component as Data Source

This post is showing how to use Script Component as Data Source in SSIS. This article expect you know what is Data Flow and Script Component in SSIS. In this article I will insert a row into Northwind database, Products … Continue reading

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

SSIS using ADO connection manager for Script Component

This post is to show how to use ADO connection in SSIS Script Component. At the same time, this is what myself always forget. Bear in mind, I never successfully using OLEDB connection for this. I only successfully using this … Continue reading

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

R accessing SQL Server Northwind table columns

This post shows you how to access to SQL Server database table using R. In the previous Connect R to Microsoft SQL Server https://chanmingman.wordpress.com/2018/08/21/connect-r-to-microsoft-sql-server/ article. I showed you how to access to the database. In here we will access to … Continue reading

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

Reconstruct database with tables using C#

This post shows you how to reconstruct the database using the scripts you have generated, https://chanmingman.wordpress.com/2018/08/11/sql-server-generate-database-script/. This code split into 2 major functionalities. 1. Reconstruct the database. 2. Reconstruct the tables. The below is to construct database only without the … Continue reading

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