They might not be planning on Windows for the OCPL, but they did alter the specs slightly to meet the Windows min. I think it's good that there's an option...

Ah, it wasn't to trick you, but educate you that these are restart-restart counters. I think you could argue that they are set to zero, or nothing. It's just...

Both QA and app use cache, but the way the cache gets used is that exactly the same command needs to run, down to the whitespace. This means that it's...

Interesting notes from Kimball. I'm only 100 pages or so into his book, but looking forward to the rest of it.

Couple things: First do the processes run fine normally and then occassionally timeout?

Check that your connections or the server isn't set to have things timeout. By default queries run to...

In 2005, a DDL trigger might be the best way. As jezemine mentioned, log to a table, then set up a job that runs and joins this to logins. Anything...

You want to walk a hierarchy.

http://www.sqlservercentral.com/columnists/sSampath/recursivequeriesinsqlserver2005.asp

Jason,

I think you've brought up a great point and I think SQL Developer is different than DBA. I've got a couple weeks focusing on DBAs, more the admin, full time...

Chris,

I think for sure you'd qualify as a junior DBA or be able to get hired as one.

I'm sure that there skills are all over the board for some people,...

The only way I know of is to audit logins and then delete or disable those that have not logged in within xx days.

Another easy way to do this is build a query to get the status and insert this data into a table in another db every minute. That way you don't...

Absolutely. This should only be used on development machines for testing parallelism in queries.

Yes. The cores don't matter to SQL Server, it just sees what the OS presents. And licensing is by sockets, not cores, so you license by the CPU sockets. 2...

These aren't necessarily the tasks a junior does on day 1, but they're the basic skills. And they apply to basic cases.

Being able to find a blocking connection doesn't...

Paul, I tend to agree with you on the last point. A manager should be trying to help people do their job, removing distractions and providing motivation.

However I do often...