Windows blue screen fix

This is in response to an email I got asking me about how my upgrades went and if I used new hardware.
-----------------------
When we did our big upgrade to 6.3.8, we moved the database to new hardware and then did the upgrade.
We also had a consultant do the conversion because we moved from Oracle to SQL server.
The conversion went fine. I move copies of the database to my test server all the time. Moving the databases around is no problem since there is no software tied to it directly on the DB server.
I use Microsoft DFS that comes with Server 2003 R2 and beyond to create DFS shares for my visual files. That way I can move servers around and it will not ever break Visual on the desktop.
So my Visual binary files are always loaded from v: and the custom reports from o:.
I also have 3 sites with a WAN, so I use thin clients at the remote sites and a terminal server here connected to my DB server with a Gigabit line. It works great. Much better than running over the wan with just the Visual client.
Even my planners at remote sites use Remote Desktop to run Visual.

Back to the install…
It much easier to do smaller upgrades, so I have done the last 2 by myself.
Like from 6.3.8 to 6.4.1 and then I went from 6.4.1 to 6.5.1.
I upgrade Visual about once a year.
Both upgrades were very simple and the database changes were done in like 15 minutes or less.
I used to use Microsoft SMS 2003 (System Management Server 2003) to push out the software to the desktops, but it was just getting out of hand, so now I run everything from a network share and it seems to be fine.
We have about 50 concurrent Visual users and about 20 barcode stations.

I hate SQLbase. I have to use it for my some of my timekeeping software.
I use Microsoft SQL server 2005 now and it comes with Reporting services free and we use it for lots of custom web based reports. I love it.
The only thing I didnt like was that I had to re-create all my 100 users when I upgraded from SQL2000 to SQL2005. This also happens when you change servers, so I did both things at the same time, so that I would only have to re-create everyone once.

I recently updated to Visual Studio 2012 Ultimate.
When i tried to open an existing SQL Server SQLCLR Project (*.sqlproj), it says that the sqlproj is incompatible with the version I am running.

How-i-fixed-it:
I installed the SQL Server Data Tools from http://msdn.microsoft.com/en-us/data/tools.aspx.

I found the solution here:

http://stackoverflow.com/questions/11906691/visual-studio-2012-csproj-and-sqlproj

and here:
http://www.comoke.com/index.php/2012/10/visual-studio-2012-database-project-sqlproj-project-type-not-supported/

and here:
http://blog.tentaclesoftware.com/archive/2013/02/11/visual-studio-2010-and-2012-sqlproj-interoperability.aspx

I have not been working with the Linq to SQL tool before and had to make some changes to an existing Visual Studio 2012 project. Some new colums were added to a database table and i needed to update the corresponding dbml file in the Visual Studio project.

How-i-fixed-it:
I found the solution here: http://stackoverflow.com/questions/1110171/how-to-update-linq-to-sql-dbml-file

Delete the modified tables from the designer, and drag them back onto the designer surface from the Database Explorer. I have found that, for this to work reliably, you have to:
a. Refresh the database schema in the Database Explorer (right-click, refresh)
b. Save the designer after deleting the tables
c. Save again after dragging the tables back.

Today we started an ASP.NET C# Project under VisualStudio 2012 using Team Foundation Server. We ran into the problem that we need to store some local path settings in the web.config file, but they are different on every developers computer.

How-I-fixed-it:
The solution is, to split the web.config up into several files and just reference the files using the configSource="sectionName.config" Attribute in the corresponding section in the web.config. Dont add these local files to the project, to not get them overwritten by each other.

Heres a sample:

web.config:
<applicationSettings>

<KCM.Properties.Settings configSource="KCM.Properties.Settings.config" />

</applicationSettings>

KCM.Properties.Settings.config:

xml version="1.0" encoding="utf-8" ?>

<KCM.Properties.Settings>

<setting name="DataStoragePath" serializeAs="String">

<value>D:inetpubftproot</value>

</setting>

</KCM.Properties.Settings>
Here i found the right information to get the solution: