Links for VSTS Database Professional Edition

Resources

Team Site
http://msdn2.microsoft.com/en-us/teamsystem/aa718764.aspx

Product Forum
http://forums.microsoft.com/msdn/showforum.aspx?forumid=725&siteid=1

Good Blogs
http://blogs.msdn.com/camerons
http://blogs.msdn.com/sachinre

 

Downloads

Service Release 1
http://support.microsoft.com/kb/936612/

PowerTools
http://go.microsoft.com/fwlink/?LinkId=88852

Posted: Tuesday, September 25, 2007 5:00:06 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback
Visual Studio | VSTS

Day of .Net in Ann Arbor, MI

Registration is now open for Day of .Net in Ann Arbor on October 20th, 2007 at Washtenaw Community College in Ann Arbor, MI. Register here for this completely-free, all day learning event. Start planning now to take advantage of this event!

Day of .Net October 20, 2007 - See You there!

Posted: Tuesday, September 11, 2007 3:40:49 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback

Use RunAs to Connect to SQL Servers in Another Domain

Doh! Another simple thing I wish I knew (or thought of) previously: Using RunAs to connect to SQL Servers in other domains

Posted: Friday, September 07, 2007 4:31:07 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback
SQL Server

ASP.NET 404 Errors on the Default.aspx Page

On a new server install, you can copy over the files for your web app and mysteriously get 404 errors. It's a simple configuration in IIS. By default the server is configured not to allow ASP.NET. You simply need to enable this in the IIS management console:

Posted: Wednesday, August 29, 2007 11:36:10 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback
ASP.NET | IIS

Caching Images in IIS 6.0

Yahoo posted a list of rules for improving the performance of your web site, along with a new FireFox-based tool for diagnosing your site's performance, called YSlow.

Their number one rule is to reduce the number of HTTP requests, and this only makes sense. I'll bet most of us ASP.NET developers are well aware of output caching, and how to do this in code. But what about those static files, like images and scripts? Well, there is an IIS setting for that. It's easy to do, and the payoff can be big if you have a very graphic-intense site. Here's what you do for IIS 6:

  1. Open the IIS Management console
  2. Find the directory containing your images (static content only)
  3. Right click the directory, and choose Properties.
  4. Click the HTTP Headers tab.
  5. Check the Enable Content Expiration check box.
  6. Click the Expire After radio button, and choose an interval.
  7. Click the OK button. Done!

The downside is that you won't get the payoff for the first time a user visits the site, but other pages using the same resources will be much snappier. Be aware that caching dynamically created content this way can cause some strange issues, so take care as to what you cache. As always, test it well before you release it and you will be rewarded.

Posted: Monday, August 20, 2007 4:11:05 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback
IIS | Performance

Speaking at West Michigan Dot Net User Group - WCF

I will be speaking on July 17th on Windows Communication Foundation. See the West Michigan .NET Users Group site for details.

Posted: Saturday, July 07, 2007 9:59:20 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback
.Net 3.0 | Speaking | WCF

Web Services Authentication Gotcha

We had code in an ASP.NET page trying to call the Commerce Server Profiles web service that resides on the same physical box. The credentials we used were appropriately configured for Commerce Server using AzMan. For some reason, the code was failing with a 401: Unauthorized error. No matter what credentials we used, no luck. But if you ran the code from another box, it worked fine. Same credentials pointing to the service on that box, no errors.

Turns out the hosts file had an entry for the DNS name we were using, and mapped that name to 127.0.0.1, the loopback address. This was the gotcha. Apparently there is a loopback security feature that causes this behavior. There is a support article describing the effect. Essentially it is a security check to keep certain kinds of attacks at bay. The article suggests registry changes to disable it, but we took a different route.  In the short term, if the calling code accessed the web service via IP address (NOT 127.0.0.1) instead of DNS name the problem was circumvented. Meanwhile the network guru is working to get the actual DNS resolution to work.

Posted: Tuesday, July 03, 2007 11:45:21 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback
ASP.NET | Commerce Server | Security

Sql Server Fix Logins

Sometimes when copying databases, for instance from production down to development, the user accounts become dysfunctional. The database login no longer matches the overall server login. To re-synchronize them use:

exec sp_change_users_login auto_fix, 'someusername'

Posted: Tuesday, June 05, 2007 10:12:17 PM (Eastern Standard Time, UTC-05:00)  #    Comments - Trackback
SQL Server