So that's why the weather's so awful here - Steve's brought it from America

Sorry Steve, but June's usually hot and dry because it's the...

Don't forget to check your INIT and NO INIT options are correct - I found a database with the log backing up beautifully every hour but each log backup was INIT and...

Looking after development, test and live environments I find I do restores two or three times a week without the need to choose databases - people are always wanting dev...

Enjoy Cambridge Steve - and don't forget Monday's a Bank Holiday in Britain - traffic jams after 4pm as everyone tries to get home on the M25

Probably a basic boring DBA too but I am also a web application developer and database designer as we're not big enough for a full time SQL DBA and this...

I have a script that iterates through all the database objects and runs a grant statement to set user permissions.

Just tweak it to suit - mine currently has all table...

There's lots of appropriate examples of vb.net with sql server at http://aspnet.4guysfromrolla.com/

I learnt much of my data handling here! The datagrid series is especially recommended.

And P.S. you'd get slated...

I recently had a discussion with my son who was going through doubts about his degree course (Entertainment Technology) and felt it did not relate to the real world. I...

In my company each SQL instance has it's unique sa password which only I know (but is logged in a locked safe). However each designated DBA has their windows login...

As above plus re-consider why you need individual instances on PCs and how on earth you can keep them all patched up to the same standard. Centralised servers are so much easier to...

It's now thirty six years since I decided I wanted to "go into computers" for my career (the phrase IT wasn't invented then) when I was choosing my O level subjects...

Typical Americans! Thinking they are the centre of the world and their little things are of vital importance to everyone.

Let's hope the...

Sounds similar to the problem we used to interview programmers - the exam boards required us to generate a unique id number based on certain criteria and with a check...

As a woman in IT since a computer science degree in the late seventies who's managed to have children, take a gap and get back into IT, I know it...

The original poster is still struggling with this. In dts I simply set the first row and last row on the transform data task properties.

But I can't see a SSIS...