Archives for Language features, Development Methodologies - Page 18
Find Largest Tables in your SQL Server database
Introduction This script uses a temp table to store the results of the query. It sorts the results in descending order – showing the largest tables on top. CREATE TABLE…
Using Delegates in C#
Introduction Delegates encapsulate a method. All they do is provide an alternate way to call (‘invoke’) a method. This concept has been around for a while (function pointers in C…
DataContractSerializer – MaxItemsInObjectGraph exceeded exception
Simple Self Reference Consider the following class – a Person contains a list of Children - who are also Persons. So, Person references Person inside itself. This is a self-reference.…
SQL Server – Applying Database Tuning Advisor Recommendations
Once you have obtained a good ‘performance’ trace for your database, you can enlist the help of SQL Server’s tuning advisor. The advisor will treat the queries in the trace…
A useful sql server (production) trace template
Introduction To run a sql server profiler session, you need a ‘trace template’. The default built-in templates are a good starting point (especially the ‘tuning’ template). However, a more advanced…
Sending Large SOAP messages in WCF
This is just a quick tip. Remember SOAP runs over HTTP – and just changing the SOAP configuration (basicHttpBinding or wsHTTPBinding configuration) is not enough for sending large SOAP messages…
Inserting code snippets into MS Word documents
Step 1 – Insert Object from MS Word’s INSERT menu. Select OBJECT from the drop-down (as opposed to ‘Text from file’). Step 2 – You should see an ‘Object’…
Message Based versus RPC Style Services
Choose Message-Based Programming Over RPC Style You can design Web services by using either of two programming models: messaging style and RPC style. The RPC style is based on the…
Source file ‘\Properties\AssemblyInfo.cs’ could not be opened (‘Unspecified error ‘)
Introduction You’ve just downloaded a project (from either codeproject or github or some other repository) – and opened it up in your current version of Visual Studio. On trying to…
Decompiling external source code–Visual Studio
Introduction There are occasions where one needs to step into 3rd party source code – just to get an idea of what may be going on within their own application…