There was no endpoint listening at

oh my. I didn't check the address - it was missing ;(

Could not load file or assembly Microsoft.SqlServer.SqlClrProvider

here

how to view the GAC as files - allowing copying etc

order by on binary cast as bigint

order by cast(sequence_no as bigint)

will not order by correctly

poweliks virus

addressed here 

actually, in my case I had a mp4 I had downloaded from youtube through a downloading site.
the mp4 itself was doing the trouble - so I went in safe mode and deleted the file - I even had to clear recycle bin


now it looks ok

not in and not exists

here

WCF - The message could not be dispatched because the service at the endpoint address … is unavailable for the protocol of the address

here

change sql profiler defaults

here

Trying to pass a table-valued parameter with 11 column(s) where the corresponding user-defined table type requires 12 column(s).

select tt.name,count( c.name) from sys.table_types tt
inner join sys.columns c on c.object_id = tt.type_table_object_id
group by tt.name