Tag Archives: database

Case sensitive dacpac for coding standards

Posted on December 7, 2016 by erictummers

In our project we have coding standards for SQL objects. But when a code review made us update casing we noticed the dacpac did not contain the changes after a schema compare. What happend? Seems that our sql server databases … Continue reading →

Posted in Development | Tagged , , , , | 2 Comments

Solve concurrency database issues in nServicebus

Posted on June 26, 2014 by erictummers

When we configure nServicebus to run with multiple thread (MaximumConcurrencyLevel) sometimes duplicate records are inserted. This happens when the endpoint has been down for maintenance and the queue has filled up with messages. Repro This is not ideal, but can … Continue reading →

Posted in Development | Tagged , , , , , , | Leave a comment

Red-gate SQL Test

Posted on March 31, 2014 by erictummers

Writing unittests for sql objects was one of my blind spots. Red-gate has a tool called SQL Test that should fill in the gap. I have given it a try. SQL Test is a graphical user interface for tSQLt, a … Continue reading →

Posted in Tooling | Tagged , , , | Leave a comment