April 2005 - Posts

Deploying SQL Express with ASP.NET 2.0 Providers

posted Friday, April 29, 2005 8:06 AM by jgaylord
If you plan on keeping your SQL Express data when you deploy an ASP.NET 2.0 application that you add the applicationName attribute to each of your providers under each special ASP.NET configuration section (ie: Membership). If you do not, ASP.NET 2.0 will look to see if the app was run under a different application or not. If it was, it will create a new application entry in the database and none of your users and profiles will be associated.
with 0 Comments

SqlExpress 2005 Capabilities

posted Thursday, April 28, 2005 8:58 AM by jgaylord
I posted a question to the ASPAdvice.com forums regarding the limitations of SqlExpress 2005. I already knew that there was no limitation on connections. However, Scott Forsyth was able to provide me with additional info. Here you go directly from the post: The database size limit is 4GB. There is also a memory limit of 1GB of RAM and a limit of 1 CPU. You can install it on machines with more than 1 CPU, but it only utilizes a max of one. There is a tool to manage SQL Express that can be downloaded from http://lab.msdn.microsoft.com/express/sql/.
with 0 Comments

SQL Talks at MSDN Code Camp

posted Tuesday, April 19, 2005 6:21 AM by jgaylord
The .NET Valley User Group will participate with other User Groups in the Greater PA region in attending the Greater PA MSDN Code Camp in Philadelphia this Saturday and Sunday (April 23 and 24). We look forward to meeting the various attendees of this event. If you have not signed up as of yet, I believe there are still some spots available. Be sure to visit the .NET Valley website for more information.

This event will feature 15 SQL and Data Access talks from some of the top SQL professionals including some Microsoft MVPs. The event will also host many other talks including ASP.NET and Windows Forms presentations. It will be chilly this weekend so you might as well come on out!
with 0 Comments

UPDATED: SQL Server 2005 Uninstallation Issues

posted Monday, April 18, 2005 1:42 PM by jgaylord
A little while ago, I blogged about some issues with uninstalling SQL 2005. Finally, Microsoft has published an uninstallation "script." Find out more by visiting http://lab.msdn.microsoft.com/vs2005/uninstall/.
with 0 Comments