Posts tagged with: development
Scripting Data from a table doesn’t have to be like pulling teeth
Sometimes you need to be able to script the data out of a table and it is easier than you might think. I commonly do this when I am generating......
Improving Project Success
There was a timely editorial posted this morning on SQL Server Central by Steve Jones concerning Successful Projects. In his post he references Kevin Whitson’s The Kevin Test for Successful......
Project Pre-Kickoff Road-mapping and Scoping
In many cases we are asked to give a WAG for a project very early in the process. This typically includes the assumptions we made, and any known risks. As......
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......
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......
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......
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......
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......
Starting with T-SQL for SQL Server
I was recently having a conversation with someone and they asked me what some good resources were to begin writing SQL. So I thought it would be a good idea......
Lessons Learned: Standard Dashboard Episode 1
Where I currently work many process improvement projects end up requiring some sort of software deliverable be created and left behind to aid in the sustainment of the process improvement......