Ahahahahahahaha

I'm even more perplexed

CDC uses the log reader, same as replication. When mirroring or availability groups are used, by default the log reader will not process log records that have not already been...

SQLQueryStress

Need to be very careful of joins with other tables, both for same-collation joins that will now have different collations during the migration process, and different-collation joins that will now...

Very very interesting, thanks for sharing!

Jeff Moden -- amen! Well put.

Being realistic, I don't believe it will happen fully, but we can do our part to make it better.

So very familiar :laugh:

Happily the happy ending came about as well.

Also, disable sa.

Yup, it's one of the best almost unnoticed improvements in 2012.

Any reason you didn't simply use P2V?

liver.larson (7/31/2015)

---

When I do dynamic grouping, I use a calculated field with a simple switch( Parameters!Parameter1.Value="Text1", Fields.Field1Value ... ) It's easy to read, I can add as many switches as...

Hmm, Red Gate's DLM dashboard is indeed an interesting development -- but it's still in beta, and does not integrate with source control. It simply compares databases.

I've actually been...

The problem with relying on source control is that you have to actually enforce check-ins somehow. For example, in the cases described in the article where a DBA does some...

Hear hear