You'll probably get asked to change all the sa passwords when he's gone but beware as there are many bought in apps relying on the sa password being set inside...

With many DBAs in option A, as a contractor you are going to be stuck in a little niche doing what you already know - there's usually little training for...

WinDiff and Notepad++

and an internet connection to sql server central and simple talk 🙂

There was an interesting TV series in the UK some years ago called (I think) Back to the Floor where top level managers went back to the "shop floor" as...

I do exactly as you require using a simple second step after the backup. It is an Operating System (CmdExec) step which does a simple DOS copy across the network

copy...

So many jobs require developer/dba with .NET skills that you'll open up opportunities if you get .NET.

Since I'm a .NET developer/DBA, I can't really say whether I actually need .NET...

Have you tried connecting to the 2008 server and database from Management Studio on the 2005 server?? Get that working first. Cross domain can be a problem as trusts...

Any navigation of the Swindon magic roundabout is complex and random - I think it's linked to DBCC_TIMEWARP 😀

Deploy your packages to msdb using File, Save copy as from BIDS and select Rely on Server.... for security in the bottom option. You can organise the packages into folders...

so you simply need a constraint linking...

Migrating two old domains to one new one has been our major nightmare for the last nine months!

The other two and a half thousand users at various sites around the...

No, Swindon's barely a...

Yes you can - I spent ages with this problem in both 2000 dts and 2005 ssis.

In your Excel data source set the data access mode as SQL Command and...

Unless it is done properly and the application is used internationally then I say stick to local time.

I've fallen foul of this thanks to that heap known as ACT! by...

I create a database role to limit user access within a database - for one troublesome user in particular their role only allows read on just one view in just...