sql server profiler woes

i couldnt see anything with sp - stmt start - i only saw with rpc completed

http 404 error on wcf rest service httpget

i was getting because of the length of the querystring

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

just means a timeout

sc vs installutil

i forgot how troublesome installutil is - i had a name with "-" and it wasnt coming up right so I used sc - way to go

bizarre NullLogger behaviour

i was using NullLogger in orchard and I needed to do this

    public MenuProvider(UrlHelper urlHelper, IOrchardServices services)

              {

                     _urlHelper = urlHelper;

                     _services = services;

            Logger = NullLogger.Instance;

              }

instead of just referring to NullLogger.Instance.Log("blah")

View dependencies

in ssms is not always correct because it depends on sysdepends



this is more accurate

select t.name as TableWithForeignKey, fk.constraint_column_id as FK_PartNo , c.name as ForeignKeyColumn
from sys.foreign_key_columns as fk
inner join sys.tables as t on fk.parent_object_id = t.object_id
inner join sys.columns as c on fk.parent_object_id = c.object_id and fk.parent_column_id = c.column_id
where fk.referenced_object_id = (select object_id from sys.tables where name = 'BLAH')
order by TableWithForeignKey, FK_PartNo

cache: false in $.ajax( calls

work because they add the following request header

1. Cache-Control:
   no-cache