Thanks NCS.

That's a good suggestion.

Thanks Johan!

Kenneth, an excellent effort at covering a challenging a topic. Good stuff!

One question I imagine other readers might have, "how would the implementation steps differ, if at all, were both...

Hi Jason,

Thanks for your comments.

Great work on taking the initiative, it's one of the key character traits required to be successful as a Data Professional in my view. In...

Hi Milton,

Perhaps you should look into the feasibility of "hosting" the application yourself, Software As A Service(SAAS) in the Cloud using SQLAzure for example. This way you have the option...

Try connecting to SQL Server using the Dedicated Administrator Connection (DAC)

See Using A Dedicated Administrator Connection

Good point, I've seen this play out a...

Oh now this is a very interesting question because it actually discretely touches on quite a few different subjects such as, job enrichment, what skills would be required to be...

Is your Publication database also the Principal in a Mirroring session?

Were this...

Pei Zhu-415513 (12/20/2010)

---

Gail:

Are you sure? rebuild index(such as alter index .. rebuild) is fully logged if db is full recovery db. As a result, log reader should scan log and...

As Gail's blog post article states, Transactional Replication does not require the Publication database to be using the FULL Recovery model.

Interestingly, I wonder if perhaps this confusion has come about...

Right, essentially what you want to do is to give the Database User the db_ddladmin Role but to a specific set of objects. Of course the problem is that you...

Brilliant though provoking editorial Rodney, thanks for sharing.

It provoked so much comment inspiration on my part that I conceded to writing a post of my own.....

Life Without a Net -...

Hmmm interesting....

What about a hybrid solution perhaps, whereby the initial query plan provided is as is currently I.E. a good enough plan is provided quickly, whilst in the background SQL...

Great article, it really struck a chord with me.

These types of in the trenches roles build character and I consider them almost a rite of passage to becoming a well...