Welcome to Sign in | Join | Help
in
Home Forums Photos Downloads

Ultima Tutorials

Last post 11-07-2006, 1:44 AM by Ultima Mark. 18 replies.
Page 1 of 2 (19 items)   1 2 Next >
Sort Posts: Previous Next
  •  10-27-2006, 12:08 AM 172

    Ultima Tutorials

    It would be nice to have a few step by step tutorials, not for general web development, but for developing specifically on the Ultima hosts environment. I've already seen a couple of scattered things in the forums concerning specific setup tutorials etc, and I think it would be great to have more of them, in a central area. The reason for this is that every host has their own quirks, and many of the quirks aren't adequately explained. For example, I feel kind of lost on some things concerning how we are supposed to connect to a SQL 05 DB (i.e. must all of the DBs I make on my computer end with _data and _log before I upload them?).

     Tutorials inherently eliminate ambiguity through the idea of "example." Sure, it's nice to see a knowledge base article that says:

    Your connection string should look like this:
    <connectionStrings>
        <clear />
        <add name="CommerceTemplate" connectionString="Data Source=69.16.210.14; initial catalog=[database name]; user ID=[username]; password=[password];" providerName="System.Data.SqlClient" />

        <add name="LocalSqlServer" connectionString="Data Source=69.16.210.14; initial catalog=[database name]; user ID=[username]; password=[password];" providerName="System.Data.SqlClient" />
      </connectionStrings>
     
    But seeing an actual short tutorial, that says the following, would tell me that I don't need to tell which directory my DB is in, make sure it ends with _data, ETC.:

    Write the connection string as follows for your pencil factory database: 

    <connectionStrings>
        <clear />
        <add name="AllPencils" connectionString="Data Source=69.16.210.14; initial catalog=pencilsdb_data.mdf; user ID=walter; password=abcd;" providerName="System.Data.SqlClient" />
    .
    ..
     


    I like to dab in web design a little:
    http://www.dayinblackhistory.com
    http://www.studentorg.vcu.edu/asuasu
  •  10-27-2006, 8:53 AM 176 in reply to 172

    Re: Ultima Tutorials

    I have the ability to create these sorts of videos (its not hard really) -- are you thinking of something along the lines of this?http://rileytech.net/Videos.aspx.  It's sort of boring @ first, but it has some REALLY good info in it (no, it does, seriously!) or just a web page showing "ok, here's how to do ____________"?

     


    RileyTech.net
    Trainer video maker guy
    "Where did you find that?" code man

    Yes, I have and frequently wear a fedora :-P
    Filed under:
  •  10-27-2006, 6:48 PM 179 in reply to 176

    Re: Ultima Tutorials

    That would be fantastic--however, for some reason I only hear sound in your videos in IE. for Firefox, nothing happens when I click on the video link at all. I'm assuming it's something like this:

    http://www.blender.org/cms/Miscellaneous.477.0.html

     
    That above tutorial is interesting (it's actual a tutorial about making these kinds of video tutorials). Ideally, these kinds of tutorials would be great. However, even something like how http://www.flashkit.com/tutorials/ does it well...as long as it is a concrete, working example.
     


    I like to dab in web design a little:
    http://www.dayinblackhistory.com
    http://www.studentorg.vcu.edu/asuasu
  •  10-28-2006, 9:41 AM 188 in reply to 179

    Re: Ultima Tutorials

    Hi there,

    These are great ideas and I have always been a big fan of live tutorials. We may even come up with a bonus scheme for anyone who wants to create a tutorial for the features of our hosting service. If you are good at it you can become the offical tutorial maker and we would throw some really nice goodies at you.

    Cheers,

    Mark

     


    System Administrator
  •  10-30-2006, 1:42 PM 209 in reply to 179

    Re: Ultima Tutorials

    oooshola:
    however, for some reason I only hear sound in your videos in IE. for Firefox, nothing happens when I click on the video link at all.

    Site uses an object to load media player thats probably not supported by firefox.  And it being encoded using windows encoder doesn't help either I'm sure :).  I'll add a download link for fun.

    Anyway, as for the making of tutorials -- I've made about 50 of them in various media (some printed, some videos, some class room style, documentation) in the past year so I'd be up for it.  I've never programmed in flash, but I'm sure I could figure it out if thats what Ultimahosts would want.  It's up to you Mark, but I'd be happy to do it if you could stand my voice on these things :-x


    RileyTech.net
    Trainer video maker guy
    "Where did you find that?" code man

    Yes, I have and frequently wear a fedora :-P
    Filed under:
  •  10-31-2006, 1:14 AM 211 in reply to 209

    Re: Ultima Tutorials

    Hi RT,

    I watched  the password video transfixed. You had me at H3L0 :)

    Doing the video in Windows Media player would be fine. We can even copyright protect them by using our streaming media services. If I put a list here and then put a reward next to it would that cause a pavlovian reaction?

    The first one would be to demonstrate how someone takes a SQL Express database (from a local starter kit) and then attaches this to a local SQL Express Server (perhaps the advanced services SP1 edition) and then creates a bak file. Uploads this to their hosting space. Makes an empty database and then restores from the bak file. Goes into either VWD or our File Manager and adjusts the connection string to suit the new database values - plus make sure the application is running in the video. If you can do that with one of the starter kits of your choice then I would say that a free ecommerce.net plan would be the reward :) The video would remain your property.

    If you really get keen on this make some videos of how to use dot net panel [maybe wait for version 2.0 to come out] and then we can help you sell them via the dot net panel forums. 

    Cheers,

    Mark

     

     


    System Administrator
  •  10-31-2006, 2:44 AM 212 in reply to 211

    Re: Ultima Tutorials

    This sounds great to me...I've especially been waiting for your first challenge Mark--the SQL 05 tutorial (to follow it, not to make it). I'm glad this post is getting as much attention as it is.  I hope that now you've provided an incentive, it will have much much more attention.

    I like to dab in web design a little:
    http://www.dayinblackhistory.com
    http://www.studentorg.vcu.edu/asuasu
  •  10-31-2006, 6:46 AM 213 in reply to 211

    Re: Ultima Tutorials

    Mark,

     
    I have a tidbit I had to work out myself using DNP, ill write it up for you if you wish and shove it on my site, feel free to steal it :) (iv only spent the last month writing documentation in the office, I started up visual studio for the first time in 3 weeks today, its quite wierd)

     

    Monty 


    Senior C#.net Developer
  •  10-31-2006, 6:58 AM 214 in reply to 213

    Re: Ultima Tutorials

    Hi Monty,

    That would be great. We'll be sure to push something back to your hosting plan as a return favor.

    Cheers,

    Mark 

     


    System Administrator
  •  10-31-2006, 11:08 AM 215 in reply to 211

    Re: Ultima Tutorials

    Ultima Mark:
    The first one would be to demonstrate how someone takes a SQL Express database (from a local starter kit) and then attaches this to a local SQL Express Server (perhaps the advanced services SP1 edition) and then creates a bak file. Uploads this to their hosting space. Makes an empty database and then restores from the bak file. Goes into either VWD or our File Manager and adjusts the connection string to suit the new database values - plus make sure the application is running in the video.

    Ok so you'd like to see a starter kit that starts out local moved up to the host using

    VWD 2k5 express
    SQL Express 2005
    SQL Server Management Studio /w adv services

    And run though the process of creating the site and migrating it to the web using said tools.  I think I can do that, might even be able to do that this evening.  I'll start making notes and make sure I've got an all inclusive how-to -- maybe even a suppliment document for reference.  Shouldn't be a problem at all.


    RileyTech.net
    Trainer video maker guy
    "Where did you find that?" code man

    Yes, I have and frequently wear a fedora :-P
    Filed under:
  •  10-31-2006, 11:25 AM 216 in reply to 215

    Re: Ultima Tutorials

    Hi RT,

    That would be great. Use all the free tools if you can as this keeps it user friendly for beginners. You can even just start with how to get a flat db file to a bak and then how to restore this (better to upload for restore) to an empty database - you can confirm the  restore via managemet studio or the web interface.

    The next video (just splitting them up so that they not too long for you) would be looking at what values to put into a connection string when a bak file has been restored and the person has the original sql express connection string in their web config.

    So in general break each video down into segments that can be performed on their own.

    Look forward to seeing the first one - look forward to your reward.

    Cheers,

    Mark 

     


    System Administrator
  •  11-01-2006, 11:49 AM 220 in reply to 216

    Re: Ultima Tutorials

    Ok, I've discovered that doing this thing in a virtual machine was a bad idea but I have the concept flow down pat and know what/how I am going to cover the connection string explination -- just need to polish it up and use something that is ...well, faster (can I borrow a dual core 2 duo system with ...mmmm, 1gb+ of mem? ...anyone?).  Tonight I hope to put it all together -- all depends on the concrete guy (don't ask, I <3 home ownership).


    RileyTech.net
    Trainer video maker guy
    "Where did you find that?" code man

    Yes, I have and frequently wear a fedora :-P
  •  11-03-2006, 6:52 AM 234 in reply to 220

    Re: Ultima Tutorials

    Dear Mark,

    I appreciate your enthusiastic nature to help the hosting clients. Its a great move from your side.

    Let me focus some serious points, which you might missout due to extra pressure on your head.

    (1) Having a .bak file is a nice idea, one can create from sql2000 easily.

    Now the main thing starts....

    How would one use this .bak file after having it as a backup on local machine.
    The new .bak file is in sql2005, while the created ( restored ) one was with sql2000.

    Not every one could afford a full fledged sql2005 for local machine.

    Your tutorial should also include, how to convert the backup file  on the local machine to .mdf and get it work on Visual Web Developer.
    without this, the backup available on local machine will make no sense. It would just be used to restore. There should be some way to view newly backed up files locally also.

    Plus... you should also think of a possibility to attach .mdf file ( just as VWDHosting does ). This would ease lots of burden
    Do you know what dotnet panel, version 2 has to offer in future

    It would be great if they think of this .mdf attachment option also.

    Hello, I am just sharing my views. I am not asking it in any way buddy.

    Thanks

     

    SoftMind. 

  •  11-03-2006, 7:07 AM 235 in reply to 234

    Re: Ultima Tutorials

    Hi SoftMind,

    You can download SQL Express 2005 Advanced Services for free which will allow you to attach, backup and restore locally. You can also take any SQL 2000 database and put it straight on SQL 2005 server via attach etc.

    We have a tool that did attach databases (it used to be me :) but found that it didn't work in 99% of cases. The .bak method seems to work fine on dot net panel when it is done from the hosting space. Plus you can retrieve your database at any time via the same method.

    I am not sure if attach is going to be in Dot Net Panel 2.0 but I can find out and let you know.

    Cheers,

    Mark

     

     


    System Administrator
  •  11-04-2006, 2:46 PM 253 in reply to 235

    Re: Ultima Tutorials

    Ok, I got a pair of them done, Mark is going to look them over before giving them the thumbs up :-)
    RileyTech.net
    Trainer video maker guy
    "Where did you find that?" code man

    Yes, I have and frequently wear a fedora :-P
    Filed under:
Page 1 of 2 (19 items)   1 2 Next >
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems