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....
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,...
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...
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...
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...
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...
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...
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...