↓ Skip to main content

Visual Studio 2012

Deploy a database project with TFS Build

·2 mins
When you develop web application you often have this scenario. Some people are testers, they are testing the application in dev all day, and they want always to test latest version. Moreover testers usually fills data into web application, so they want their data to be preserved between various deploy. If you simply clear all data in test database you will end with a lot of furious tester so do not even think to do this. If a developer needs to change database schema, we need to automate not only the deploy of the web application, but we need also to sync test database with the latest changes. This is necessary so the test site can work with the new version, but old data is preserved for the happiness of the testers. This is quite simple using TFS and Database project. The situation is this one

Visual Studio 2012 running slow

·2 mins
Three months in and my Visual Studio 2012 is running slow, I’ll even go as far as saying it is freezing up some times, so I loaded up SysInternals Process Monitor and set a filter on Visual Studio and to my complete and utter amazement I found PerfWatson running wild in the system

SQL71566 when upgrading to VS12

·1 min
In VS 2012 I receive the following error message (one for each table) when trying to build a database project. SQL71566: Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlFilegroup cannot not be set on both the Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlTable and the clustered Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlPrimaryKeyConstraint. For reference here is script associated with this error.

Setting up StyleCop

·4 mins
How to get StyleCop working and running in Visual Studio 2012 First download the latest StyleCop from Codeplex, and install. If you now load up Visual Studio and create a new project, how you’ll find lots of underlined code that need attention