Don't use any user's individual accounts - what happens when they leave?

Put users in domain groups e.g. SysAdmins and assign the permissions to these. Then you only have to remove...

Dated files are fine when you want everything in seperate files, each log backup etc. If you want the log backups appended into one file or device with no init...

I've been using the backup script for some time and it works a treat. It is especially good for Sharepoint database servers where databases can suddenly appear as if by...

Microsoft ruined their one decent database design tool when they bought out Visio - it was great before they got their mitts on it especially for object role modelling design...

I had something similar and tried all sorts of adding and removing then it turned out that the person who couldn't connect needed to change the options on their connection...

1. That users know how to use basic windows and the applications they have e.g. how to maximise a window!

2. That we understand every TLA and buzzword around - too...

Cakes are for birthdays - the birthday person brings them so everyone does their turn over the year on or as near the date as possible.

We have an official rewards...

It's easy to do and only those with no drive or ambition make themselves indispensable - who wants to be slogging away with the same old code in 5 or...

Look up Ola Hallengren's backup solution available here on SSC scripts. Backs up all user databases full, diff or just log. Excellent for servers where databases are being created without...

Make your dataset return the required order data in each detail line (if there isn't too much) by using a table join in the select query between the order and...

I prefix my stored procs appropriately - the reporting ones are rp_ , data access layer ones are dap_ and lp_ for drop down list ones which can be used...

You need to deploy your package. I find it all works so much better if you set your package up in BIDS/Vis Studio with the correct connections then do File,...

I find it all works so much better if you set your package up in BIDS/Vis Studio with the correct connections then do File, Save Copy of Package As...

My man and I race sailing dinghies and are especially involved with keeping old ones racing and the Classic and Vintage Racing Dinghy Association for which I'm the webmistress. That's...

Formal flexi time is a great system. Clock in and out but all extra time over 7.5 hours a day is added to your flexi "bank" and we can take...