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...

I have always kep Visio diagrams of our databases as part of the systems documentation, using the reverse engineering feature of Visio to create them.

However Microsoft have ruined Visio...

I ticked 4 boxes to cover my job. DBA for both development and production, SSxS developer and ASP.NET developer

That's this month - in a month or two it could be...

Thanks all, especially Beatrix and Stuart. Bristol and Bath are readily commutable and Swindon too. Even Southampton isn't really too far. I'll look for the book and peruse the websites....

I posted this about career options a while ago and just my luck, it didn't even make the daily email and hasn't generated a single reply, but now the...

Have you installed the sql server client tools, notably the visual studio shell part because that is what turns ordinary visual studio into the version for sql ssis, ssas and...

Because SSIS (2008) only writes to one system table we decided to write our package logs to flat files on the database server then add a step to import those...

Having worked in a similar small situation and now in a slightly larger but more regulated organisation, I definitely prefer the latter. We aim to cover each other's tasks so...

When you divert records on error (with a red linking line between transformations) then the last two columns available are error code and error column. You can google the error...