Understand the True Source of Problems

There’s an old joke that goes, “Doctor, doctor, it hurts when I do this.” While the person in question swings...

Upgraded SSD

I was going to call this an upgraded HDD, but that’s not right. Technically it’s a drive update, but really...

Attending and Speaking at SQLBits XIV

The SQLBits conference has a special place in my heart – as I have written before, the previous edition of SQLBits...

Hangout with Boris Hristov

A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL...

Building Rollback Scripts with SQL Compare

There’s a neat switch in SQL Compare that lets you build rollback scripts. It looks like this:

I’ve used this before...

Dev Tools: FARR2 Launching groups of files or apps at once

There are probably a common number of apps you pull up when you pull up your system. For example, I...

Dev Tools: FARR2 Launching groups of files or apps at once

There are probably a common number of apps you pull up when you pull up your system. For example, I...

Two Weeks on the PASS Board

The one absolute promise I made about serving on the PASS Board is that I would let you know what...

Why does SqlPackage keep dropping and recreating constraints?

I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete....

Why does SqlPackage keep dropping and recreating constraints?

I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete. Updating database (Complete) Successfully published database.
This happens everytime...