I love to travel, but flying has become a huge hassle. By the time I get all my 3oz or less toothpastes, shampoo..., get to the airport somehow, arrive 2...

I worked at a university in northern Arizona in the late 90's. We had customized Peoplesoft HR to the point that if you terminated a person with a post dated...

That all depends on your HBA and switches and disk config on the SAN. If all the other areas are underutilized then sure it will help. But if your HBA...

I found if I indexed all my keys to the dimension tables (25 or so), that my cube processing time dropped substantially.

Good luck

The main thing for HIPAA compliance is documentation. Do a risk assessment and document what you are doing to protect the data. Encrypt anytime it goes outside your network, then...

The Novell client actualy "proxies" you through the windows authentication - so you many not actually be authenticated. If the A DLU Policy ( Dynamic Local User ) is setup,...

I agree IT is no different than any other consultant. In healthcare we frequently get business consultants that try to fix us - but they do not have the needed...

I wonder if your really need to re-index every week? Are your indexes so fragmented after a week (I'm not saying that can't happen, but wow that must be lots...

Ditto above and I would not recommend you do too much shrinking of the log file as continued shrinking and growing will slow the system down. Instead, try to find...

Having read rhat's comments, I realize one of the most important skills - interpersonal relations. As a DBA you have to work with many groups (SAN, Server, Network, Developers, Security...

I would wonder why objects are owned by different users. My practice (and I was told it was best practice??) was that dbo should own all objects in production. Because...

Ah, you probably have orphaned users. the knowledge base article here:  http://support.microsoft.com/kb/314546  has good techniques for transfering logins and fixing orphaned users.

I've found BCP is still the easiest way to import fixed width flat files (particulary wide tables). I normally create the .fmt file in Excel then copy to a text...

What happens if you get rid of the order by? As your using many calculated fields, I would think the entire result may need to be tempdb'd to do the...

You are correct if its passive you would use the same license - nothing additional needed.

I believe you could do the mirroring to 1 box, but I would recommend seperate...