Monthly Archives: April 2016

SSRS Error – ReportServerDatabaseUnavailableException

We recently had a customer trying to upgrade an SSRS solution and they were receiving some of the errors below. Some were from when they were trying to deploy the new reports and some were when they tried to go...
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 →

Equivalence Partitioning and Other Testing Methodologies

I was recently sent an article on different testing methodologies. Thanks Danny. The article covered a topic that I think many people may forget about when thinking of how to write tests. That topic is Equivalence Partitioning. Equivalence Partitioning is used to...
Continue Reading →