Tag Archives: database

Case sensitive dacpac for coding standards

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 , , , , | Leave a comment

Solve concurrency database issues in nServicebus

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

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