Here's what I did to resolve the issue.

I set to single_user with rollback immediate which didn't resolve the issue. I couldn't switch back to multi_user because the system id was...

It is interesting that when I run a backup command, the wait types switch.

So normally spid 16 has the pagelatch_up and the wait resource is 1:2872334.

When I run a...

This is on 2008 R2 SP2. I know there's a KB addressing a similar bug for 2008.

Grats on the interview and I hope it goes well for you.

I can't say I've ever interviewed for a SSRS job but I would think the usual interview policies would...

SSRS cache can be a curse and a blessing. It normally affects development as your making many changes quickly and end up being a victim of the cache's old data.

The...

Without additional auditing there is no default way to detect the reason for log growth.

opened a connect bug for it

TDE works seamlessly and ... transparently in the database. No encryption/decryption needs to happen at the application level.

Depending on your environment schemas can be used a couple different ways. They can logically group types of tables together like

Schemas can also provide additional security functionality for a database....

powershell 2.0

I had tried IP addresses in the scripts and it also returns a null systemName. I even tried creating a DNS alias for the long server name and it still...

Alright. I did some more testing and I figured it out!

The computer naming convention we have is 15 characters in length which is apparently too long for powerShell.

I created a...

Great suggestions, unfortunately it was still an unsuccessful attempt. I tried hyphenated, en-dash, and em-dash, all of which returned the same results, yet still no systemName. I went so far...

Nats/Tigers game last night. Pretty much the same atmosphere. Started out raining then slowed down to a misty drizzle. Game was delayed an hour but I got to see Mr....

Talk about scary. Happ had a rough night I bet.