Monthly Archives: September 2019

Using MAX(DateTime) in SSIS get duplicated records

Posted on September 30, 2019 by chanmingman

This post shows you a solution to eliminate duplicate records when using MAX(DateTime) in SSIS. If you have a statement SELECT MAX(DateTime) FROM DatabaseTable and assign the result to SSIS variable then most of the time you will get duplicated … Continue reading →

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

SQL Server WITH (NOLOCK)

Posted on September 18, 2019 by chanmingman

This post showing you how to use WITH (NOLOCK) without using the keyword WITH (NOLOCK). WITH (NOLOCK) is the same as READ UNCOMMITTED. It is easy for s select statement like below. SELECT * FROM [dbo].[tables] WITH (NOLOCK) If you … Continue reading →

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

Azure Bot Service

Posted on September 15, 2019 by chanmingman

I have this back in early 2018. It should still somehow be relevant.

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

OLE DB provider “SQLNCLI11” for linked server “server” returned message “Query timeout expired”

Posted on September 13, 2019 by chanmingman

This post shows you one of the possibilities to resolve the error “OLE DB provider “SQLNCLI11” for linked server “server” returned message “Query timeout expired”. This error actually from SSIS Data Flow but do not look into SSIS. We resolve … Continue reading →

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

SQL Server list all the database tables

Posted on September 13, 2019 by chanmingman

This post shows a common request. How to list all the database tables in Microsoft SQL Server. It is nor hard but just cannot find this accurate one sometime. What you need is only the statement below. SELECT * FROM … Continue reading →

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

Manage people who like to comment only

Posted on September 13, 2019 by chanmingman

In senior management for many years, there is one culture, bad culture, I have seen. A group of people who has achieved nothing like to comment on those who has been doing their job well, for example in IT industrial … Continue reading →

Posted in management | Tagged | Leave a comment

An explicit value for the identity column in table ‘table’ can only be specified when a column list is used and IDENTITY_INSERT is ON

Posted on September 12, 2019 by chanmingman

This post shows you one of the ways to resolver the below error when you issue a SQL Statement like: INSERT INTO [argo_visit_details] SELECT * FROM [server].[database].[dbo].[argo_visit_details] The error is like below. An explicit value for the identity column in table ‘argo_visit_details’ can … Continue reading →

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

HTTP POST web request C#

Posted on September 9, 2019 by chanmingman

This post shows you how to do a HTTP POST web request using C#. This code below is to call the existing Web API, https://chanmingman.wordpress.com/2019/09/09/asp-net-web-api-post-using-postman/. private static readonly HttpClient client = new HttpClient(); static void Main(string[] args) {     GetPostAsync().GetAwaiter().GetResult(); } public static async Task GetPostAsync() … Continue reading →

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

ASP.NET Web API POST using Postman

Posted on September 9, 2019 by chanmingman

This post shows you how to call ASP.NET Web API POST method using Postman. Recall back on July 5, 2013 I post the following C# code for POST usng Web API. // POST api/values public void Post(Book value) {   Book book = value;   northwindEntities context … Continue reading →

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

SSIS OLE DB Command One Input Columns map to Multiple Destination Columns

Posted on September 5, 2019 by chanmingman

This post shows you one of the possibilities to map a single Column map to Multiple Destination Columns. This article requires you to have the knowledge of SQL Server Integration Services (SSIS). You can see from the Data Flow below … Continue reading →

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