We're still using OEM for SQL Server monitoring, using version 10.2.0.5. It works but I find different nuances every week.

Follow my links from above, the Oracle documentation is good.

I'm...

Roland, thanks for the comment, looks like I missed an edit.

The name of the endpoint on the mirror should be 'MirrorEndpoint'. So yes, the two connect statements should read:

create...

I can do this one, also. It's similar to the other port article.

I'll take this one.

I am smack in the middle of this at my job. My manager is all about security/process/documentation, while other parts of management (and even the upper management) has a...

I love the image you chose, D&D PnP dice and Player's Handbook definition of wisdom. Brought back memories...are (were) you a gamer, Steve?

We're currently studying for the 70-432 certification also. I passed the 70-431 exam, so have some experience here.

As David stated, knowing the T-SQL behind the scenes will give a...

It probably has something to do with a 32bit library vs. a 64bit library. 'procexp' might show you that.

Curious, why are you going to SQL Server 2005? You're...

This is a total shot in the dark, so do some research before, but maybe the .dll isn't registered.

You could modify the account that the SQL Server agent...

Wow...duh! Thanks GS. Forgot my set theory for a second.

Is a join the only way to do this?

Interestingly enough, when I read this I felt a twinge of guilt. Not that I lied on my interview nor did I embellish, but I had just passed my...

I've always wanted to buy some land on the moon on the slight chance that it's legit. I could see my descendants saying something like: "great great great grandpa...

The moon.

Don't handle things twice. If you pick something up, open an e-mail, etc., handle it then. The single largest source of double-work and lost time you will ever encounter is...

Try this:

select * from sys.database_principals

where type = 'A'

Reference:

http://msdn.microsoft.com/en-us/library/ms187328(v=SQL.90).aspx