One of the biggest problems with UK government IT is quite simply the old adage "Pay peanuts, get monkeys". IT staff are paid well below industry rates resulting in higher...

I've worked in various software jobs, including those where you knocked off after midnight and started again at 8 ish but now I'm a civil servant and the formalisedways are...

None of us are working alone with this forum community available.

Enjoy it, act professionally, treat all as equal and every task as a chance to learn and you'll progress and...

This job took me about ten minutes to set up the first time I did it - import from each file in a directory and move them to a "processed"...

I'm another who adds a surrogate identity primary key to my tables and indexes on the natural key. I've too often had the problems of natural key (e.g. employee number)...

Karma's analytical chemists have it right but they are professional analysts operating in a controlled laboratory environment. The breathaliser is in the hands of overworked police who have neither the...

Applicant: Do you really understand SQL Server or are you just reading questions someone else has set?

Absolutely, definitly, no question we want SP for both and regular SP for supported products.

Sounds like you're seriously missing the plot here! BIDS is designed to work on dtsx and you create in BIDS, deploy to either package store or SQL msdb. If you've...

Perhaps it's the Tools Options settings in BIDS (aka Visual Studio 2005) that make it re-draw?

But what's the difference between that and for example someone working and claiming unemployment benefit? Or, as happens in the UK, employing one person legally on paper then splitting their...

What you need to do is BUY SOME BOOKS, as previously mentioned and start there.

But to do an ODBC connection do the connection manager as I said before and you...

When I get so called "engineers" come to install and need the sa password, I don't give it. Instead I create a new sql server account and give it sys...

When you've got your project open in BIDS/Visual studio (whatever you call it), in solution explorer right click data sources, select new data source. The wizard comes up with a...

As an IT professional who literally does clock out - we work formal flexi-time and it's great - I believe anyone who's got the time to blog (non-work) or use...