Sunset from our office window

One of the last sunsets from this window. Rumour has it that we're moving to new offices soon.

Out at dinner

Enjoyed a great dinner with my brother Dave, his wife Toni and two of their kids (Jacquie & Andrew).

GPS navigation is fun

Found a new use for my PDA that has been sitting idle since I got my laptop a few months ago. Add some extra software and a bluetooth GPS receiver and I've got a functional GPS Navigator for next to nothing.

Check last backups for all databases

 

Been way to long between posts. Have had my head down busy with work and being secretary of the cricket club.

 

Here's a handy script from my tool chest. It shows the database status, last full backup and last log backup.

select

    db.[db_name]
    , databasepropertyex(db.[db_name], 'status') as [db_status]
    , db.[last_backup] as [last_db_backup]
    , lg.[last_backup] as [last_log_backup]
    , getdate() as [current_date]
from ( 
    select
        convert(varchar (50), substring(db .name,1,50)) as [db_name]
        , max (bs.backup_finish_date) as [last_backup]
    from master..sysdatabases db (nolock)
        left join msdb..backupset bs ( nolock) 
        on db .name = bs.database_name
        and bs.type = 'd'
    group by db. name
) as db
left join (
    select
        convert (varchar(50), substring (db.name,1 ,50)) as [db_name]
        , max(bs.backup_finish_date ) as [last_backup]
    from master..sysdatabases db (nolock )
        left join msdb ..backupset bs (nolock) 
        on db.name = bs .database_name
        and bs.type = 'l'
    group by db.name
) as lg
on db.[db_name] = lg.[db_name]

 

Our cat snowball loves boxes

My cricket bat arrived yesterday and our moggie just couldn't stand not squeezing into the empty box.