Today's employers don't want their data going out of the office so they provide virtual machines on their servers for contractors and staff and you work on that remote desktop using...

If you favour the backup/restore approach, try pushing the cost angle of that - setting up a backup/restore = less than a day's work, setting up an SSIS job to...

Many of us who are limited company contractors in the UK consider our IR35 tax status before accepting invitations to corporate events, Christmas parties or away days since they are...

The gig economy is everywhere now and it makes me glad I'm not young and trying to build a career again as there is no job security for the youth...

BitBucket, JIRA and the associated Confluence wiki to document everything. SourceTree front end on local (virtual) pc. I like the way it all links together so the BitBucket branches show in the...

Two weeks somewhere in Europe. The channel tunnel is booked (free thanks to Tesco's clubcard rewards scheme) but we'll just pack the camper van and decide where to go at...

In summer, I enjoy going dinghy sailing after work. Many sailing clubs are now finding the mid-week race evenings more popular than weekend race days and one factor is getting...

Now sit back and see who screams when they can't run their report 😀

I buy very little technology - my last computer purchase was my Linx windows tablet a year ago for use on the train commute - runs Kindle for pc, One...

For those who don't know, the database diagrams in Management Studio are a good way of visualising the relationships set up between tables - just add a table to the...

In a previous job, ACT! by Sage did some tricks like this, removing all logins it hadn't created from the front application and especially admin accounts. It was a total...

One side effect of dyslexia is an inability to estimate time and manage time hence my OH is always late unless I'm ruthlessly managing our arrival.

He knows when I say...

Standard ritual with all my home pcs - backup to external hard drive then (slightly less often but minimum monthly) back up to second eternal hard drive which is kept...

It sounds like the account that runs it as a job (the sql agent service account) does not have permission to access the MyServer MyDB database.

You need to give it...

I keep my config file on the same server as the packages run on though I store those packages in msdb.

The account that is defined in the sql agent...