Posts tagged with: deployment

Idempotent statements

Idempotent statements are those where applying the statement multiple times yields the same result. Commonly in database development this is significant during deployment activities. If we create a new table the deployment script will merely have the CREATE TABLE syntax....
Continue Reading →

Moving SET NOEXEC OFF in SQLCMD deployment scripts

Currently when we build deployment packages we try to validate that the deployment is properly configured for the customer site to reduce errors. We do this by validating the version number, the database it is pointed to, connections are working,...
Continue Reading →

Deployment Variables Anti-Pattern and Site Configurations

This example has been in my list to post on for quite some time now and a recent conversation reminded me to bump it up the list. The number one benefit of database projects is definitely the compiler, or as...
Continue Reading →

The Value of Naming Constraints

In certain designers, such as SQL Server Management Studio table designer, when you create certain constraints (Primary and foreign keys, defaults, and check constraints) they will be given a name that contains a GUID to verify the name is unique. This...
Continue Reading →

Our enterprise tools and using the CUSTOM schema

I was recently asked a question about what is the CUSTOM schema in our tools used for and I thought it may be a good idea to write about it in case you are not familiar with it. With our...
Continue Reading →

Hiding the SSRS Breadcrumbs from Users

It is common when rolling out our SSRS prototypes that different onsite users will be interacting with the different products. This means that typically different user groups will be setup and certain groups will have access to specific SSRS report folders...
Continue Reading →

SSDT Deployment Optimization for Table Constraints and Calculated Columns

Calculated columns on tables can be helpful. For example let’s assume you have a table with Name Fields and you have a formula for FullName. You typically want that formula in a single spot.  A common way to handle that...
Continue Reading →

Avoiding deployment grief from database drift

*Movie guy voice* In a world where applications are developed and shipped to multiple customers. One company effectively saves money and has happier customers by understanding database drift. I was once talking to a friend at a SQL Server Users...
Continue Reading →