jesscoburn.com

Tidbits and thoughts on webhosting, web applications and just general cool geek crap.


The past week was a big week for Applied Innovations, the ASP.NET team finally set ASP.NET AJAX (formerly Atlas) as RTM and as a result we released full support for it.

I’ve been a big fan of AJAX for a long time and in fact, it’s used in my blog theme here with the search box. Ofcourse my blog is done in PHP but the concepts are the same.

You can see our Press Release on ASP.NET AJAX hosting over at PRweb: http://www.emediawire.com/releases/2007/2/emw502149.htm

I point out emediawire because some many of the other news sources chop up the PR into what fits best. What’s so great about AppliedI offering ASP.NET AJAX hosting? It’s the great hosting promotion we’re offering with it. We’re including 3 free months of hosting and a FREE SQL2005 database with new signups.  Pretty nice offer honestly.

You can learn more about asp.net ajax from our site at http://www.appliedi.net/aspnet-hosting/ajax-hosting.html (and also get details on the promotion).

Looks like Brad Abrams picked up on our offering of AJAX support too.

In fact, looks like we’ve created quite a buzz around our offering.

  • 1 Comment
  • Filed under: ASP.net

  • SDN has a a new thing they've been doing for the past couple months called Source Force. Promoting a series of *FREE*, have you noticed I really like free, this blog should be renamed to "Jess's list of free and cool tools", Anyway a series of Free Virtual Labs on the MSDN site at http://msdn.microsoft.com/virtuallabs/. What's better than getting free training? Free toys! If you do a couple labs and submit evaluations you'll get a free limited edition action figure (I suspect there's some office in Redmond right now with a thousand of these little guys all lined up battling).So I can highly recommend the Training labs from Fritz Onion. I picked up one of Fritz's books on ASP.net and C# a couple years ago and find it one of my best most targetted and straight to the point books. His training is quite good and he really follows through with it including follow up items on his blog. Just one thing on the free toys, they're only available for the Months of Jan, Feb, Mar and Apr so better hurry while you can.

  • 0 Comments
  • Filed under: ASP.net, Cool Stuff

  • Microsoft, Dr. Dobbs and O'REILLY are offering Free ASP.net 2.0 training with courses for JSP, PHP and Coldfusion developers looking to migrate over to the dark side.  To sweeten the pie you also get a nice pack of freebies, including a copy of Visual Studio 2005 Standard Edition, a 50% discount on a MCP exam and some other goodies. Regardless it's a good deal and the training sessions are awesome. Many of them are by Fritz Onion who is an awesome trainer and book author. http://www.learn2asp.net/Campaign.aspx has all the goodies.

    SQL2005 Express Edition is Microsoft's follow up to MSDE2000. MSDE picked up tons of following and has been in use all over the place. Unfortunately for a web application it really didn't cut it and would be quickly outgrown. SQL2005 EE will replace MSDE and doesn't have the same 20 concurrent connections limitation that MSDE had. Here's the new limitations for SQL2005 Express Edition: - No query or workload governor (this is a big plus) - Limited to 1GB of RAM, it doesn't sound like alot but it's more than enough for most servers - Database sizes limited to 4GB in size.  Again this is HUGE for databases most databases never make it over 20MB. - No Clustering (not an issue for most) - No Mirroring (not an issue for most) - No DTS (okay maybe a problem for some, but most don't use it) - No Full Text Search (okay, this is kind of bad, you won't be running sharepoing on express and probably most forums use full text for their search now too) - No Notification Services (what you don't get enough pages already?) - Replication as a subscriber only, still makes it a worthy backup server solution - No Analysis Services (no comment) - Service Broker, subscriber only - No Built in SQL Server Management Studio (SSMS) but you can download this from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en - No Reporting Services, that's a tiny ouch. - No backup/restore utility, this can be fixed via http://www.sqldbatips.com/showarticle.asp?ID=27 - No job scheduling (aka SQL Agent service) I think that's all of them but I'm not SQL expert so I probably missed some of them.  I think the big limiting factor here is going to be no backup and restore utility. I'm off to install SQL express myself now though and see how she does…

    SQL data types


    Date types are pretty important but often overlooked (especially from a hack of a programmer like me) so to save myself a ton of headaches I've copied a table I found elsewhere on the internet for myself. The table came from: http://www.databasejournal.com/features/mssql/article.phpr/2212141

    bigint Integer data from -2^63 through 2^63-1
    int Integer data from -2^31 through 2^31 - 1
    smallint Integer data from -2^15 through 2^15 - 1
    tinyint Integer data from 0 through 255
    bit Integer data with either a 1 or 0 value
    decimal Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
    numeric Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
    money Monetary data values from -2^63 through 2^63 - 1
    smallmoney Monetary data values from -214,748.3648 through +214,748.3647
    float Floating precision number data from -1.79E + 308 through 1.79E + 308
    real Floating precision number data from -3.40E + 38 through 3.40E + 38
    datetime Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of 3.33 milliseconds
    smalldatetime Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute
    char Fixed-length character data with a maximum length of 8,000 characters
    varchar Variable-length data with a maximum of 8,000 characters
    text Variable-length data with a maximum length of 2^31 - 1 characters
    nchar Fixed-length Unicode data with a maximum length of 4,000 characters
    nvarchar Variable-length Unicode data with a maximum length of 4,000 characters
    ntext Variable-length Unicode data with a maximum length of 2^30 - 1 characters
    binary Fixed-length binary data with a maximum length of 8,000 bytes
    varbinary Variable-length binary data with a maximum length of 8,000 bytes
    image Variable-length binary data with a maximum length of 2^31 - 1 bytes
    cursor A reference to a cursor
    sql_variant A data type that stores values of various data types, except text, ntext, timestamp, and sql_variant
    table A special data type used to store a result set for later processing
    timestamp A database-wide unique number that gets updated every time a row gets updated
    uniqueidentifier A globally unique identifier