It would be very useful for those external suppliers who come in and install their software needing access just for the day. I usually create a sql login with sysadmin...

A country walk or a day at the beach - usually the beautiful Dorset Jurassic Coast.

It's a chance to play with toys you've already got, whether it is bats...

An ITIL foundation course?

Bring back Visio Modeller and Visio before Microsoft bought it and ruined it - you could not only reverse engineer your database but forward engineer from the model too.

We've had a good take-up of the Microsoft Home Use Programme, the Dell Employee Purchase Scheme and the Hewlett Packard Employee Purchase Scheme but we've never offered the software assurance...

I'd try putting an SSIS "for loop" sequence container with a variable set to true and never changed and an evaluation expression testing that variable for false. Inside that, a...

I use proxy accounts on all our servers. The agent account has access only to the local sql server program and data and local backup drives/directories and can thus only...

Computing appealed to women far more in the seventies when I did my degree and the emphasis was on programming and not on networks, hardware, games or similar aspects of...

The attitude amongst managers seems to be that it is "just" a database and you "just stick the data in there" and it doesn't matter how.

More education is essential on...

In my spare time I run a website for a club and my webmistress's report at the AGM included thanks to my OH for his support , patience and for...

Have you been reading my work? 🙂

I spent some time yesterday writing an email to try to put off the business from taking a bunch of non-IT business people,...

Let them have SQLAgentOperatorRole on the development server but not on test or live. DBA does transfer of job to test and then to live once they've set it up...

I look after a couple of club websites in my spare time and often find I can't get things done or posted as soon as I would like. However the...

I'm another one who doesn't do twittering, facebooking, myspace or being linkedin etc. so you're not alone Niall.

The problem hasn't changed though, there has always been the one rule -...

Find out who will stand in for you when you are on leave and learn what they know and what they do in the DBAs absence. If it works it's...