WOW, that sounds a bug of sql server 2k5 itself. I am glad we have SP2 + CU10. 🙂

Hi Johan,

I'd suggest the following test in the test environment

1. Have a lock monitoring script running as a job on the server, the monitoring script only monitors the locks on...

I really enjoy it.

Merry Xmas and happy holiday to all SSC folks !

JY

Informative article.

But I am still trying to understand why the transaction isolation level plays a role here. Before a connection is established, there is no isolation level to that "would-be"...

I have not tested it, but I believe you can schedule the snapshot by scheduling the snapshot agent job (which has a category of "REPL-Snapshot") on the distributor server.

Good article to read, and I'd especially echo this:

"The scary part about being a new DBA is that you don't know the extent of what you don't know".

In reality, I...

I have used snapshot extensively in my test environment but not in the prod deployment yet. The reason is not the technology itself, but because we have never failed our...

I see what proposed in the article is an overkill most of time in SQL2K5 EE. For DB side rollback, is there anything better/quicker than the database snapshot? i.e. Do...

If my memory serves me well, I believe you cannot replicate DDL (like adding a column to a publishing table and expecting the DDL will be replicated over to the...

I guess you can check monster.ca to see (at least) how demands for SQL Server professional are like.

I love the summer of Nova Scotia.

I would say "why not?"

B group is very famous and your resume will look better with such experience. In the worst scenario, you can look for another company anyway, right?...

DBAdmin (8/25/2008)

In my opinion, this is an almost inevitable drawback of large organizations. In small organizations anonymity is not an option and everybody understands the contributions of others. In large...

try DBCC useroptions in both environments and compare the results.

HTH

JY

Very nice post.

My own experience (as an interviewer) is I never trust the resume only, I always throw some open questions to the interviewees just to judge their knowledge...

Tomm Carr (8/20/2008)

---

... it is a full time job remaining at Expert level as SQL Server Developer.

The best that companies can end up with when they hire a DBA/Developer is...