Category Archives: Development

Dotnet development

EF query optimisation

Posted on June 7, 2017 by

We have a view that is very slow when you don’t use a filter on the name field. Everywhere in our stored procedures and (sub)queries we have this applied. In our web applicatie we use Entity Framework. The business layer … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Speed up ASP.NET MVC debugging

Posted on June 5, 2017 by

Whenever I was debugging my ASP.NET MVC application the wait times for every page is about 8 seconds. This was not happening after deployment to a webserver (thank god!) Today I discovered that disabling the browserlink will speed things up … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Linq to entities and CAST

Posted on June 2, 2017 by

We use an EDMX to access our database with Entity Framework. Before you comment: we have our reasons not to use code-first. Today we encountered a small problem with linq to entities and validating a varchar field that contains an integer … Continue reading →

Posted in Development | Tagged , , , , | Leave a comment

Scrum Master Skills

Posted on May 26, 2017 by

We’re working on our project for some months now. Time to freshen up on scrum. For this we use the Scrum Master Skills course on pluralsight. Once each sprint we sit down as a team for an hour. We play and pause the … Continue reading →

Posted in Development | Tagged , , | Leave a comment

Update statistics from stored procedure (needs alter table permission)

Posted on May 24, 2017 by

Today instead of the beautiful information our reports displayed this ugly error An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘StoredProcedure’. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server … Continue reading →

Posted in Development | Tagged , , , , , | Leave a comment

TypeLoadException

Posted on May 15, 2017 by

Introducing a new member to the team is always a good thing. This brings up problems that would stay under the radar otherwise. Our new tester experienced an application crash that we’ve never seen before. Using the remote debugger we … Continue reading →

Posted in Development | Tagged , , | Leave a comment

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server

Posted on April 12, 2017 by

We use SSIS packages to import files. These SSIS packages are run with sqljobs. During deployment the sqljobs are created with a script. That is the plan. While running the script to create the sqljobs we got an error: Error … Continue reading →

Posted in Development | Tagged , , , | Leave a comment