A standard question for security clearance is

"Are you or have you ever been a terrorist?"

As if anyone is going to answer Yes! 😀

Be obsessive about backups and restores and don't forget the master,model and msdb and reportserver databases. If you can't restore a production database from a very recent backup you're likely...

It's not all data quality, much of it in the property business is "marketing" - don't reveal the negatives.

If the norm is three parking spaces and the listing doesn't say...

The service accounts don't have the permissions across servers that the special account has and you want to keep them that way for security. BOL or Google will tell you...

I have a special domain user account reserved for this task which has the necessary windows permissions on the places it copies files to and from plus the sql permissions...

In my last post every job description was a set format and had as the last item "10 - Any other duties as...

All the above plus it needs to be readily amendable as everything changes at year end and often calculation methods change too but you have to be able to retain...

Since the table contains the contents of a csv file, go back to the original csv file and import it using SSIS. It doesn't worry if fields aren't quoted as...

Have your external users got the correct dll/rdl files installed?

see [/url]

Users need to be able to download and install active x controls and if they can't they get problems....

How did I miss these first time round? Really useful set of articles and I will be referring back to them, especially when trying to explain indexes to other developers.

Thanks...

Hooray, SSC is so appropriate again that I swear you're monitoring my workload!

As a Christmas present I've just been given the projects of a fellow developer who is leaving...

I fully agree with you and often take advantage of working in the same open plan office as the network guys and active directory and exchange experts to wander across...

A switched-on user in Department X creates a quick application in Access to help with their job. It proves useful, so he gives access to it to others in his...

Thanks for summing up this week's internal battle in one paragraph!

Developers wanting sysadmin rights and I can't override it as they come under a different management chain and their...

We've ditched Cognos for Sql Reporting Services (go for at least sql 2008 version) and we're gradually getting into Sharepoint 2007. It's very popular throughout the business as a document...