Monthly Archives: November 2019

SQL Server SELECT all primary keys and foreign keys constraint

This post shows a simple sql statements that people always forget especially myself. To SQL Server SELECT all primary keys and foreign keys. Let’s say you have a table name called inv_goods. To display all its foreign keys table. SELECT … Continue reading

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

SSIS RowCount for Execute SQL Task

This post presumes you know SSIS. I am copying most of the content from the reference link but the pictures are in Visual Studio 2017. Case How do you get a rowcount when you execute an Insert, Update or Delete … Continue reading

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

SharePoint client library code CSOM

Complete basic operations using SharePoint client library code https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-client-library-codee?WT.mc_id=DP-MVP-36769 Not sure why is this still around Build Windows Phone apps that access SharePoint https://docs.microsoft.com/en-us/sharepoint/dev/general-development/build-windows-phone-apps-that-access-sharepoint?WT.mc_id=DP-MVP-36769 Develop SharePoint Add-ins https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/develop-sharepoint-add-ins?WT.mc_id=DP-MVP-36769 Create a provider-hosted add-in that includes a custom SharePoint list and content … Continue reading

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

SQL Server Analysis Services SSAS Getting Started Resources

This post guides you how to get started with SQL Server Analysis Services, SSAS. This is the path to Multidimensional Modeling. Install SQL Server Analysis Services https://docs.microsoft.com/en-us/analysis-services/instances/install-windows/install-analysis-services?WT.mc_id=DP-MVP-36769 Analysis Services tutorials https://docs.microsoft.com/en-us/analysis-services/analysis-services-tutorials-ssas?WT.mc_id=DP-MVP-36769 Install sample data and multidimensional projects https://docs.microsoft.com/en-us/analysis-services/multidimensional-tutorial/install-sample-data-and-projects?WT.mc_id=DP-MVP-36769 Multidimensional Modeling … Continue reading

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