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

Just remember the security issues of having personal data stored - can you secure the mySQL database suitably?

We decided against developing an external recruitment online application for this very...

Word, Excel Visio, Outlook and lately Notepad++, which is brilliant and handles larger text files than MS products, although I had to think about that one the other day when...