Todd Anglin's Code Campground - All Comments

re: Using the LinqDataSource: A practical look

Matt — Wed, 04 Nov 2009 20:06:23 GMT

Good post... how about whereparameters using related table data...

for example, I want to pull all <entity records>

WHERE

entityrecord.[CompanyID]=@companyID

but also WHERE

<relatedtable.statusdescription> != @statusdescription

How would I access this via linqdatasource?

I know in linq, the statement would work

var record = from entitytable in datacontext.companies

join status on entitytable.StatusID = status.statusID

where entitytable.companyId == @companyID && status.description != @statusdescription

select new

{

entitytable.field, entitytable.field2, status.description,

}

re: Azure Cloud Pricing Falls Somewhere Between VPS and Dedicated

Dieter — Sun, 25 Oct 2009 20:04:12 GMT

I seriously consider hosting projects on Azure. I think it'll be a very reliable solution for my projects.

When you compare cloud computing at the msft to a VPS at VPSLand, it's like comparing brand new BMW 7 full leasing car with a second hand Opel car without any warranty :). Not suitable for big commercial projects (in my opinion). After all, I'm a developper, not a system maintainer. A VPS needs maintance, backups, fail over system, etc etc ..

At the same time I do hope they keep some kind of sandbox for developpers for a very low rate (free?) so we can develop / test and demo our products at reasonable cost.

Instalar SQL Server 2008 en equipos con Visual Studio 2008 instalado

El Blog de Fede — Tue, 15 Sep 2009 21:42:01 GMT

  Estimados, como estamos. Bien, les cuento lo que nos pasó… Habíamos instalado todo nuevo una PC

re: Are you a digital pack rat?

Dave — Sun, 06 Sep 2009 17:09:27 GMT

So, if you buy this big 1TB hard drive. What is the plan to back it up? Do you buy 2 1TB drives (one to mirror the other)? This seems like the cheapest way of backing up the 1st drive. However, I am not sure you wan't to store your precious moments on something that could be completely wiped out with one electronic surge.

I have considered offline services such as Mozy however, I am personally in the mode of trying to find a better solution. I am not sure I want to pay yearly for something else (trying to be cost effective and not back myself into a corner with a purchased solution for offline storage).

Ideas?

Twitter Trackbacks for Are you a digital pack rat? - Todd Anglin's Code Campground [asp.net] on Topsy.com

Mon, 31 Aug 2009 20:02:46 GMT

Pingback from Twitter Trackbacks for Are you a digital pack rat? - Todd Anglin's Code Campground [asp.net] on Topsy.com

re: Another Solution for Defeating the SQL Server 2008 Installer with Visual Studio 2008

Kevin P. Rice — Wed, 12 Aug 2009 10:19:20 GMT

Web PI failed for me despite that VS 2008 SP1 is already installed:

Error: "Product 'SQL Server 2008 Express with Advanced Services' is incompatible with product 'Microsoft Visual Studio 2008 RTM. Please install Visual Studio 2008 SP1'.

Next step, I ran the VS 2008 SP1 installer (www.microsoft.com/.../details.aspx). It reported a whole slew of products that would be affected by the SP1 install (perhaps one of these is blocking the SQL 2008 install?):

* Visual C++ 2008 SP1 - x86 Runtime

* Visual C++ 2008 SP1 - x64 Runtime

* Visual C++ 2008 SP1 - IA64 Runtime

* Microsoft Office Standard 2007

* Microsoft Office Visual Web Developer 2007

* Microsoft Visual Studio 2008 Professional Edition - ENU

* Microsoft Visual Studio 2008 Remote Debugger - ENU

* Visual Studio .NET Prerequisites - English

* Visual Studio Tools for the Office system 3.0 Runtime

* Microsoft Windows SDK for Visual Studio 2008 Tools

* Microsoft Windows SDK for Visual Studio 2008 Win32 Tools

* Microsoft Windows SDK for Visual Studio 2008 .NET Framework Tools

* SQL Server System CLR Types

* Microsoft SQL Server Management Objects

* SQL Publishing Wizard 1.3

* Microsoft SQL Server Compact 3.5 SP1 (ENU)

* Microsoft SQL Server Compact 3.5 SP1 Design Tools (ENU)

Now, I already had run the SP1 installer in the past, but maybe some of these other installations were newer and still required the VS 2008 SP1? Couldn't hurt to run the SP1 installer again...

About an hour later (after the very long download install process) the SP1 installer reported success... now back to SQL Server 2008 (that was the goal that I just about forgot at this point).

I reopened Win PI from the Microsoft SQL Server Express download page (selecting the "Runtime with Advanced Services" edition, in my case).

SUCCESS!! Win PI now opens the SQL Server 2008 install with no complaint.

My lesson: Try running the VS 2008 SP1 install again.

re: Azure Cloud Pricing Falls Somewhere Between VPS and Dedicated

tanglin05 — Sun, 19 Jul 2009 17:42:17 GMT

@Kevin - I think VPS hosting pricing is a factor of configuration and "quality." The more powerful the configuration and the more engaged the support staff, the more you pay.

I'm sure there are many VPS providers out there that will sell hosting for $40/month, but there are also many that sell shared hosting for < $5/month.

In my experience, you start to find "tier 1" quality at around $99/month for VPS and $10 - $15/month for shared. And since Azure is being provided by MSFT, I consider it Tier 1 service, too.

In the end, though, VPS priced or not, it's good to hear another perspective on Azure's pricing!

-Todd

re: Azure Cloud Pricing Falls Somewhere Between VPS and Dedicated

aggiekevin — Sat, 18 Jul 2009 17:15:42 GMT

Todd,

Actually, VPS hosting has become incredibly cheap (compared to a few years ago). I use VPSLand.com and pay less than $40/month for a small business level plan. There are other companies out there that offer similarly priced plans as well (1&1 comes to mind).

I hear Azure will be available to students through DreamSpark and small businesses through BizSpark, but there doesn't seem to be anything for hobbyists and bloggers who don't fit into those categories. With pricing what it is, I think I'll stick with my VPS and give Azure another look in a year or two.

--Kevin

re: Another Solution for Defeating the SQL Server 2008 Installer with Visual Studio 2008

tanglin05 — Fri, 10 Jul 2009 13:17:07 GMT

@Paige - Thanks for the extra info! I'm glad your experience went well. I've had similar good experiences with SQL Server 2008 and VS 2008, but for whatever reason, this one went south. I think the key source of trouble is the SQL Tools. If you miss the fact that you can install them from the new WPI, you're headed for my painful journey.

So, key lesson: Try installing the SQL Server 2008 tools from the WPI before taking any other "creative" steps to get them installed!

re: Another Solution for Defeating the SQL Server 2008 Installer with Visual Studio 2008

Paige Cook — Fri, 10 Jul 2009 12:21:36 GMT

Todd,

I also just loaded up the Windows 7 RC this week. I installed VS 2008 (excluded the SQL Express 2005 installs) and then immediately applied VS 2008 SP1.

Then I went out to install SQl Express 2008 and on the download page it suggested that I use the Web Platform installer to install SQL Express 2008. So I took that route and was able to install both SQL Express 2008 SP1 and the Sql Server Management Express 2008 tools.

This worked like a charm, I had no issues and was even able to setup all of my web platform options & settings. (IIS, ASP.NET, etc.)

Overall the Web Platform installer is pretty slick and makes the configuration very easy. I would highly recommend it.

Sorry that you had to go through all of the pain that you did.