Tag Archives: sqlserver

Performance tuning EF, ASP.NET and loadtest

Posted on December 14, 2015 by erictummers

We are developing webservices for accessing data in SQL Server. The performance requirement was not met until we started to tune our solution. TLDR: use table in stead of view EF First we added the AsNoTracking() extension from EntityFramework to … Continue reading →

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

XML data type for storing messages

Posted on September 7, 2015 by erictummers

We want to store xml message in a database for batch processing, logging and retention. For some time now Sql Server offers the xml data type for columns. This way we could index the xml, validate it with an xsd … Continue reading →

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

Allow incompatible platform in schema comparison

Posted on June 4, 2014 by erictummers

Schema comparison of SQL Express 2012 database and SQL Server 2008 gives an error A project which specifies SQL Server 2012 as the target platform cannot be published to SQL Server 2008. Set the allow incompatible platform in the options … Continue reading →

Posted in Tooling | Tagged , | 2 Comments

Chocolatey on Azure provision

Posted on May 26, 2014 by erictummers

A recent update on the Windows Azure platform enables you to run a custom powershell script when creating a new Virtual Machine. It can be configured on the last step of the Wizard. This is where chocolatey can do it’s … Continue reading →

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

SpiraTeam database hack for user access

Posted on May 13, 2014 by erictummers

My test colleague uses SpiraTeam and needed some help restoring a backup. After restoring we granted access to the database from IIS (network service). But now he tells me nobody knows the Administrator password. What to do? Solution The SQL … Continue reading →

Posted in Security | Tagged , , , , | 1 Comment