Monthly Archives: September 2019

Using MAX(DateTime) in SSIS get duplicated records

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

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

Manage people who like to comment only

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

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