Articles by Herman<T>.Instance (Articles: 4, Tip/Tricks: 5)

Articles: 4, Tip/Tricks: 5

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.18

Database Development
SQL Server	Dynamic Pivoting with Cubes and eventhandlers in SQL Server 25 May 2011 Updated: 19 Dec 2018 Rating: 4.91/5 Votes: 18 Popularity: 6.17 Licence: CPOL Views: 55,042 Bookmarked: 29 Downloaded: 831 Please Sign up or sign in to vote. In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!
Programming Languages
C#	FTP from Windows CE 5.0 Devices 16 Apr 2014 Updated: 16 Apr 2014 Rating: 4.75/5 Votes: 8 Popularity: 4.29 Licence: CPOL Views: 53,929 Bookmarked: 14 Downloaded: 2,672 Please Sign up or sign in to vote. Windows CE devices are not setup properly for the use of FTP despite the HttpWebRequest and HttpWebResponse classes.
	Disadvantages of SqlParameters Turned into Advantages 6 Aug 2011 Updated: 10 Aug 2011 Rating: 2.06/5 Votes: 10 Popularity: 2.06 Licence: CPOL Views: 63,943 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. When using SqlParameters in a query, the array of Parameters can give a headache. How to prevent the use of paracetamol.
SQL	Pitfalls of the SQL Server Service Broker 16 Oct 2022 Updated: 16 Oct 2022 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: CPOL Views: 6,261 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. It should reflect the event

Average blogs rating:

No blogs have been submitted.

Average tips rating: 3.75

Database Development
SQL Server	Is MS SQL Server Service Broker Responding to Read Uncommitted Data? [Tip/Trick] 21 May 2019 Updated: 21 May 2019 Rating: 2.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 4,162 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. When using SqlDependency, is it possible that a detected change leads to 0 rows in the SqlDependency results?
	EF6 Migrations and TimeStamp Bug with CodeFirst [Tip/Trick] 2 Nov 2021 Updated: 2 Nov 2021 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 5,710 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Migrations does not apply to T-SQL rules for ALTER TABLE ALTER COLUMN
Web Development
ASP.NET	ASP.NET Cannot Load a Reference Assembly [Tip/Trick] 22 Nov 2021 Updated: 22 Nov 2021 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 7,970 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Short route to fix this issue
	AjaxControlToolkit Accordeon has Bad Influence on PagerTemplate of Gridview [Tip/Trick] 8 Jun 2023 Updated: 8 Jun 2023 Rating: 3.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 5,720 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. AjaxControlToolkit Accordeon's bad influence on Gridview PagerTemplate
IIS	A Binding Instance Has Already Been Associated to Listen URI [Tip/Trick] 28 Jun 2016 Updated: 28 Jun 2016 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 10,943 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Very simple problem to solve unexpected easily in IIS Manager

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Herman<T>.Instance

Software Developer (Senior)

Netherlands

I started in the eightees with Basic and QuickBasic. When the ninetees started dBase was my thing. Close to the millenium years I swapped to C++ and since 2003 it is only programming in c#.

There is one thing about me.
Not that kind of OO guy and definately not an ORM-fan. I know a database to well to give the importance of data out in the hands of a tool.