I was having this annoying error with remote desktop credentials not being saved at work. This little tutorial fixed the issue, worth a read if your having this problem.
SQL & Distinct Results
If you are working through a large list of potentially similar entries for maybe a cascading dropdown for manual location entry then you might find the DISTINCT sql command quite valuable.
This query returned 3800+ counties with tons of double entries:
Add in our special DISTINCT keyword and we get just 91 unique counties:
How to Increase Message Size Quota
Sometimes when dealing with web services that return large amounts of data you get the follow error message.
The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.
This can be fixed by increasing the maxReceivedMessageSize, maxBufferSize, maxBufferPoolSize, maxArrayLength & maxStringContentLength variables in your web.config to their max size.
The follow code shows you what the web.config basicHttpBinding section variables should be set to:
