Spent a lot of time trying to talk to a "Muted" WCF ServiceHost

Today i spent 1h trying to figure why i couldn’t talk to a WCF Endpoint hosted on a Windows Service. I did some work on my Vista laptop yesterday where everything was working fine and then copied the Service library (that contains the service i wanted to host) to my main dev box (Win7), added it…


Using Performance Dashboard with SQL Server 2008

Today, by the force of habit i was trying to spawn SQL Server Performance Dashboard to diagnose a SQL perf issue and didn’t even realize the DB was SQL 2k8.I just went ahead to execute setup.sql to setup the sprocs that Perf Dashboard requires for that server and then to my great surprise ran into an…


Must Read – Performance

The Ten Rules of Performancehttp://www.panopticoncentral.net/articles/946.aspx and Improving .NET Application Performance and Scalabilityhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenet.asp My favorite quote:”If your software does not meet its performance objectives, your application is unlikely to be a success.If you do not know your performance objectives, it is unlikely that you will meet them”


Getting a string array from SQL Server

After the last post showing how to pass an array into SQL, i will show how to go the other way around. How to get a string array from a table. I should note that i ONLY pass and get arrays as strings on very specific cases (usually perf, test or dbg related). Whenever possible i use…


Passing an array to SQL Server

Often times i need to pass a variable number of arguments to SQL, and since there’s no array support i usually end up doing: Adding parameters to T-SQL with default values  Passing a string with some delimiter and building a table from that 1. Adding parameters to T-SQL with default values is something like: CREATE PROC…


Hello Blog

I decided to start sharing some thoughts on this blog, hoping they will help people the same way i have benefited from other blogs and web sources. I’ll blog randomnly mainly on System.Data, Xml and SQL Server, as they are closely related to my current job (perf for System.Xml, System.Data (DataSet especially) and MSXML) All…