Category Archives: Cloud

SQL Server WITH (NOLOCK)

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 | Leave a comment

Azure Bot Service

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”

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

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

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

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 | Leave a comment

HTTP POST web request C#

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

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