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

Yet another impressive view of Paris

http://www.gillesvidal.com/blogpano/paris.htm

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]

SQL Artwork

MS Premier Field Engineer Fabricio Catae posts a stunning piece of deadlock artwork.

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

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.