Tuesday 30 March 2010

LHC has stable beams ...


... and the world didn't end!!

http://meltronx.com/lhcdatawide/index.html

http://hasthelargehadroncolliderdestroyedtheworldyet.com/

http://www.cyriak.co.uk/lhc/lhc-webcams.html

Tuesday 23 March 2010

Quick query to list which Reporting Services report the SQL Agent jobs relate to.

SELECT
  jb.[name] as [job_name]
  , cat.[name] as [report_name]
  , cat.[path] as [report_location]
  , sub.[description] as [sub_desc]
  , sub.[LastRunTime], sub.[LastStatus]
FROM (
    select 
      jb.[name]
      , replace(right(stp.[command]
        , charindex('=ataDtnevE@', reverse(stp.[command]))-1)
          , '''', '') as [SubscriptionID]
    from [msdb].[dbo].[sysjobs] jb
      inner join [msdb].[dbo].[sysjobsteps] stp
      on jb.job_id = stp.[job_id]
    where jb.[category_id] = 100
  ) jb
  JOIN [ReportServer].[dbo].[ReportSchedule] sch 
  ON jb.[SubscriptionID] = sch.[SubscriptionID]
    JOIN [ReportServer].[dbo].[Subscriptions] sub
    ON sch.[SubscriptionID] = sub.[SubscriptionID]
      JOIN [ReportServer].[dbo].[Catalog] cat
      ON sub.[report_oid] = cat.[itemid]

Thursday 18 March 2010

I've heard of late trains ... but ...

Snapped this whilst I was waiting for my train home.


I think we can safely say that the trains never ran that late when Connex was running the system ... LOL

Wednesday 17 March 2010

Paris @ 26 Gigapixels

http://www.paris-26-gigapixels.com/index-en.html
a stitching of 2346 single photos showing a very high-resolution panoramic view of the French capital (354159x75570 px)

What’s the signage on the building to the right of the red crane?

How many antennas does the black office building have on it?

What time is it by the clock on the bell tower?


Free Kudos to whoever gets all three correct.