Can you change the authentication to Windows, eliminating the need for a separate ID and password? Use groups to control access to specific dataabses and tables. That would be my...

These are the situations where having set procedures in place help tremendously. If there is a document outlining the steps to take when something bad happens, the chances of rash...

This is why all companies need to have clear, and enforced, policies about controlling data, including sending data to third parties. The DBA mentioned above ought to be fired, and...

I am a big fan of not allowing an everyday ID to have elevated access to production servers. And, conversely, not allowing the production iD to have rights to a...

One option is to force two DBA's to be present when working with sensitive data. Give each of them half the login credentials and have them watch each other. To...

CirquedeSQLeil (1/10/2010)

Paul White (1/10/2010)

Indeed. i was thinking of an 0900...

Here's something I found when I searched for AES-128 data size

"AES turns 16 byte input blocks into 16 byte output blocks. The only expansion is to round the data up...

GilaMonster (1/10/2010)

The biggest city south of the Sahara. (not sure if Cairo's bigger or smaller,...

Unless you have a huge amount of temporary data, you need to add disks to the second server. I've never seen a situation where the temporary data was large enough...

A DBA manager doesn't need immense technical knowledge to be effective - that's what the DBA's are for. The manger's role is to make sure the way is clear for...

You probably need to search for rows that contain the unicode codes for Arabic. Search Books Online for the functions related to Unicode string handling.

I've had decent results using MS Access to compare data from different sources. Link tables to each of the databases, then use Access queries to do the comparisons. As long...

Jeff, I had wondered that as well. If the new IP's are stored in a table with the old IP's, it would seem simpler to just do an update statement...

Why would a developer have the ability to drop a table in a production database? As others have mentioned, proper grants of authority are the appropriate way to control access...

We told our main vendor that sa was no longer an option. Period. They complained, but finally changed their install and update routines to work just fine with dbo equivalence...