Dave Noderer's Blog

May 2010 Entries

Microsoft Report Viewer 2010 Redistributable…

Ok, honestly, I’m posting this so I can find it when I need it but Visual Studio 2010 uses a new report viewer that is compatible with .net 4.0.

http://www.microsoft.com/downloads/details.aspx?familyid=A941C6B2-64DD-4D03-9CA7-4017A0D164FD&displaylang=en

Bill McCarthy has some complaints (and a work around): http://msmvps.com/blogs/bill/archive/2010/04/19/upgrading-report-applications-to-4-0.aspx

US Government moving to the cloud and saving $

Good to see that government is getting more responsive to current technology.

This is a good article by Vivek Kundra, US Chief Information Officer and some examples of how the government is using cloud services.

http://www.whitehouse.gov/blog/2010/05/13/moving-cloud

javascript getMonth() gets me!

I’ve been working a lot with Microsoft CRM over the past few months and much of the screen level customization uses javascript.

One thing I discovered today while breaking apart some dates was that the javascript getDate() returns the day of the month 1-31 as you would expect but the getMonth() returns 0-11… definitely not what I expected!!

Scribe Workbench Update Source

I’ve been working with a program Scribe, similar in function to SSIS although I’m still an SSIS fanboy!!

The main feature my customer has Scribe for is to load data into Microsoft CRM 4.0.

A lot of what I’ve been doing is loading campaigns into CRM which are staged in SQL Server but I need to mark each one as imported so it will not get imported again.

The screen shot below shows how to setup the Source update. One important thing is that the source SQL table has to have a primary key defined (this was a staging table and I did not do that at first)

 

image

SQL Auto Close Options

Found an interesting thing that others have run across but it is the first time I’ve seen it.

A customer emailed to say that the SQL 2008 db that I had helped him with seemed to be going into recovery mode on a regular basis while watching the SQL Management Studio screen.

Needless to say he was a bit nervous and about to take some drastic steps. Eventually he found that the Auto Close option was set to true.

When this is set to true, the database automatically closes all connections and unlocks the mdf file after 300 milliseconds. When a new connection is made it spins backup… Great for xcopy deployment on a client machine but not a multi-user server based application.

So the warning… if you have started a database with SQL express and then move it to a production SQL server, make sure you check that the Auto Close option is set to false.

See options screen below:

image