« first day (226 days earlier)      last day (372 days later) » 

Mark Hurd
Mark Hurd
11:06 AM
3
A: How can I write a cross-site Data Explorer query that joins databases on linked accounts?

Mark HurdHere's a query to generate the comparison of EmailHashes and the resulting query, which is of course interesting to run from different base sites :-) Just noting I've updated these queries to cater for the lack of collation coherency on EmailHashes in the current (December 2012) export, as well ...

Posted the above answer update to point out that the EmailHash collation is different across the December exports. Of course I don't know which, just that the error was reported.
 
 
4 hours later…
Tim Stone
Tim Stone
2:53 PM
@MarkHurd Hmm, the tables on the Data Explorer side seem to be consistent, EmailHash is SQL_Latin1_General_CP1_CS_AS across all of them.
Fix issue where viewing a text-only result query with cached multi-resultset results doesn't seem to work correctly
 
 
1 hour later…
Anonymous
4:04 PM
Any status to report, @TimStone? ;P
 
Anonymous
(I'm not actually in an anxious hurry to play with it right now, but I have become committed to my role as poker-of-Tim.)
 

« first day (226 days earlier)      last day (372 days later) »