Tuesday, 30 March 2010

LHC has stable beams ...

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




Tuesday, 23 March 2010

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

  jb.[name] as [job_name]
  , cat.[name] as [report_name]
  , cat.[path] as [report_location]
  , sub.[description] as [sub_desc]
  , sub.[LastRunTime], sub.[LastStatus]
      , 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

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.