Tag Archives: sqlserver

Add Sql Server as user provided service in Cloud Foundry

In this post you’ll add Sql Server from Azure to a dotnet core mvc app. We presume you’ve already created the Sql Server in Azure. If not follow my post azure sql server for centralised database. User Provided Service A … Continue reading

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

EF query optimisation

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

Update statistics from stored procedure (needs alter table permission)

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

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

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 , , , | 4 Comments


We have some SqlJobs that we run in our regression tests. To automate this we need something that can start the job and wait for it to finish. Based on this post we know we need to poll the sysjobhistory … Continue reading

Posted in Test, Tooling | Tagged , , , | Leave a comment