Symptom: If you're seeing random, periodic extremely slow page refreshes on your iMIS app server (full or public view, either one), check the first section of this Howto for the ASP.Net "idle worker process timeout" setting.
The issue is that by default, IIS kills the ASP.Net worker process after 20 minutes of inactivity, causing the next page access to restart the appdomain (leading to that annoying "first hit" slowdown as all the business objects are loaded, iBO initialized, etc).
Microsoft released the latest version of their Remote Desktop client yesterday. Those of you who like to RDP into multi-monitor setups will be happy to note that this release supports monitor spanning. (Note that enabling this feature requires starting the client with the command line "mstsc /span".)
Red Gate Software has made their SQL Prompt software, which adds Intellisense code completion to SQL queries, available for free download until September 1. The free download version is not timebombed or limited in any way.
From the Product information page:
SQL Prompt simply sits behind the scenes and provides unobtrusive help when you press Ctrl-Space or when you type "." after a table/view/alias name.
Sometimes, for some reason, VS 2005 seems to lose or corrupt source control bindings for projects. In those cases the project will appear not to be under source control; you may also receive error dialogs about source control providers not being available, etc.
The process for reassociating a project with its TFS binding is as follows:
Much of the .Net code we ship (or will at some point ship) depends on sensitive values that are stored in web.config files. This sensitive information includes database usernames and passwords as well as application login names and passwords.
One way to protect this information is by using file permissions; obviously, if a user doesn't have read access to a .config file, they won't be able to open it and read the information. Unfortunately this isn't always practical.
I will be sharing a presentation at this year's iNNOVATION conference. The presentation's topic will be "How to Maximize the Value of IQA". My co-presenter will be running through a start-to-finish real-life example of creating a complex fundraising report, from several SQL Views to a new Business Object and finally into IQA to create the necessary queries.
My segment will be more focused on the specific new features in 10.6, so I'm just thinking out loud (and welcoming comments) on things I should focus on. I have 15 minutes or less, so I really want to do this efficiently without missing anything important.
Microsoft has released the MSSCCI provider for TFS, which enables using TFS source control from the following:
VS.Net 2003
VC++ 6 SP6
VB6 SP6
VFP9 SP1
Access 2003 SP2
SQL Server 2005 Management Studio
Get it here.
Scott Guthrie, the program manager for ASP.Net, has a new blog post regarding upcoming April releases for ASP.Net.
These include the VS 2005 Web Application Project, some Atlas goodies, an RSS Tool-Kit update, and CSS Control Adapters. It looks like April will be a good month--and he promises that May will be even more exciting, though he won't say why. :)
Now that we're using SQL Server 2005 as our "default" database (while, of course, maintaining SQL Server 2000 compatibility), we can start looking into the new capabilities Microsoft has provided. One of these capabilities are the new SQL Server Management Objects (SMO), which are a .Net-based management API for SQL Server. There's an interesting post about scripting SQL objects over on SQLTeam.com that highlights some of the basic capabilities.
One of the places I think this could be a great fit for us is automatically scripting database objects, for instance as part of the nightly build, in order to provide two things:
