:), I'd love to resell these, having a few issues with Amazon. We've pulled them off the site as well for now.

Red Gate is using most of these as marketing...

Thanks for the comments and it's interesting to see what people think.

As I read through these, I think I might actually be more efficient than I expected. If I start...

I actually am writing about this next week, or I guess it's already written for release while I'm at PASS.

It doesn't make sense in the short term, for this system...

Anonymous Post #2

Hi there.

I pretty much get 8 hours in per day. I think I work very efficiently. But I'm currently in a job where I can hide away in...

Interesting. I agree it's not the only metric. Effectiveness is ultimately what matters, but for planning, you need to guess at some xx amount of work and hours is one...

Are you moving to new places or to the same server over and over?

You only need to move logins once, and if you use the same SID, then you...

Just as a note, we usually have 2-3 free admissions to the conference we give away to authors each year.

Anyone that can cover travel/hotel and is interested, write me...

I've gone both ways, but I have tended to separate out the system databases to a separate job.

I'm with TheSQLGuru. I'd shut down SQL Server. If the files are being written to, it's possible that you are slowing things down or there could be an issue. There...

Usually the PK is a field that obviously identifies what's in the tables. Often there is an "ID" field with an identity or integer value in there. If you have...

Short answer: sql agent.

Are you running SSIS packages or are you trying to run SQL scripts from SSIS?

Yammer looks interesting, and thanks for pointing it out.

You definitely need downtime, but the thing to remember is that Twitter, alerts, Blackberry's aren't binary devices. It doesn't mean you are...

It's a problem with your tape drive, or the media. When you see "operating system error" it's something outside of SQL Server.

Backing up to tape is not recommended as the...

Just a chance to meet people from the site. We hire a casino company to cater the event, give away "chips" to play blackjack, poker, roulette, etc. for a couple...

You have some duplicate data in your join.

you could add distinct to the SELECT list, which would remove duplicates.