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

Books - any of Terry Pratchett's Discworld novels - pure escapism.

Best Christmas buy ever though was when travelling to South Africa for christmas - a 24 hour plus trip....

Our main business and finance system is making the Oracle to SQL Server 2005 jump in order to get off unix as the costs of replacing and maintaining the unix-oracle...

There are advantages to working for the government. Fraud awareness training is mandatory for all staff and there is a dedicated fraud department who can be called openly or anonymously...

If the question phrasing represents your standard of English then you'll need to work on it before you get a job here. Communication skills are important and many interview candidates...

What benefit...? Makes you look up middle join in BOL:)

The cheapest way - script both whole databases or selected objectswith the same scripting options and use WinDiff which is generally lurking somewhere on Microsoft systems e.g. Program Files\Microsoft Visual...

Grant - agreed. That's why my own .NET applications only reflect the underlying database structure not replace it. But we're all different so be aware of other ways even if...

Apologies if this has been said but it's a long topic to skim. I'm a .NET developer as well as a sql dba so see both sides.

The original post mentioned...

Moving user databases is DBA bread-and-butter - the basics that earn your keep. Backup and restore with EXEC sp_change_users_login after to tidy up. I keep restore scripts for each server...

Agreed - am I the only person who prefers to speak rather than send a text message, but when I do the message is spelled correctly and in full. None...