Results 1 to 15 of 15
  1. #1
    Join Date
    Jul 2007
    Posts
    10

    survey of your hardware/software (was "IT Services Consulting Company")

    Hey Folks - We need your help. We were hoping, we could gain from your experience with implementing server virtualization. When should we be using Red Hat Virtualization, Citrix Virtualization, Xen Virtualization, Microsoft Virtualization, Oracle Virtualization and VMWare. I will be very interested in learning from your first hand experince. I will also like to know, under what situations is one virtualization prefered over the other. - Thanks for your help

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Yes, I would like to know too. I've seen feedback both pro and con in regards to SQL Server virtualization. Some state do not do it on any production DB, while others say it is the best thing since sliced bread (sorry for the outdated pun).

  3. #3
    Join Date
    Feb 2007
    Posts
    62
    VMs have a lot of very good applications but we do not virtualise our SQL servers because of the overhead of the VM and how it can limit the use of resources that are actually free. SQL Server can run multiple databases at a time anyway which gives us pretty much what we need.
    The questions I would have for you are
    a) What are your aims in this?
    b) What are the problems you are currently encouterting
    c) What is inadequate about running several databases on one install?

  4. #4
    Join Date
    Jul 2007
    Posts
    10

    survey of your hardware/software (was "IT Services Consulting Company")

    Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If another mod deems another forum more appropriate for the thread please be my guest.

  6. #6
    Join Date
    Jun 2004
    Posts
    115
    Hi

    When budget is a constraint then i prefer
    Centos and Mysql
    When We have a large budget
    Solaris and Oracle or Aix and Db2
    When it comes to departmental databases and we have the budget
    Then its Sqlserver and Windows

    When it comes to business intelligence then
    Sqlserver Analysis service for certain category of departmental users.

    When it comes to Packaged Business Intelligence applications
    Then it would
    Hyperion Cognos and SAS.
    Hyperion and SAS mostly in Marketing and Financial Companies.

    When it comes to Datamarts
    Netezaa and DataAllegro

    regards
    Hrishy

  7. #7
    Join Date
    Jan 2008
    Posts
    3
    It depends on your customers and your niche

  8. #8
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    Do not forget that you can use different instance of SQL SERVER 2005 into the same server. So if your databases uses the same version of SQL, and that you do not want the database to be on the same server (software side), you can use different install which is more optimized than using VMs.

    With MS SQL SERVER 2005, you can install up to 50 instances on the same server.

    Correct me if I'm wrong.

    Regards

    Or Tho
    Less is more.
    How long is now?
    http://www.lesouterrain.com

  9. #9
    Join Date
    Jul 2007
    Posts
    10

    survey of your hardware/software (was "IT Services Consulting Company")

    Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us

  10. #10
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Post Re

    For a "IT Services Consulting company" you have a lot of questions.
    And i think you'll have to specify your location or do you want to consult the whole world? each country has it΄s specific

    Think you have first to go and see whats out there your self, a lot of hear say dosn't make you an specialist your self.

    See what mess, there is out there. See if you can clean a org. with 5 diffrent Databasess ; 3 platforms ; over 5000 users with all kinds of different hardware/software and not mensioning the versions /partial setups /dll's / usersettings/ regional setting (and what so ever) on 5 locations. This is still a minor example.

    see a forum on anny topic, you'll have 1 question 1001 solutions on how to solve it and nobody will say thats the correct one because they will/can all work.

    Still you have 1 million probility whats wrong
    if a pice of code / hardware did work yesterday and won't work the next what's the cause.
    is it an update on the machine or server. did the autorisation change of the user or expire. or did the clean-up crew clean the office and bumped on your network cable and you just have to click it in again.

  11. #11
    Join Date
    Jul 2007
    Posts
    10

    Hardware, Database, Business Intelligence

    Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us

  12. #12
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    john_sm - please can you check your private messages. I believed you should have received one from one of the other moderators.

  13. #13
    Join Date
    Jul 2007
    Posts
    96
    Where I work at we usually buy hardware from HP with a support contract and all the expensive and fancy things that come along with that. The hardware itself varies from project to project.

    In 2008 Oracle will continue to be the database of choice for the majority of the high-end segment. Microsoft SQL Server will prolly increase it's market share with the release of the new products in 2008. Microsoft Customers and End-Clients are hopping that SQL Server 2008 doesn't become the Windows Vista of the Databases.

    A big stake of the customers are eager to unleash decent reporting and analysis for their always increasing data collections, which can boost MS SQL Server implementatios as an out of the box sollution that fullfills the majority of the requirements within the same product. Still on the MS track, sharepoint solutions demand is likely to increase in all levels of demand.

    Sun has a new baby called MySql and it will be interesting to see its strategy to lure enterprise costumers into adopting MySql Dbs, in dispite of commercial versions. This of course preferentially boundled with other sun products and commercial support contracts.

    Linux will continue to be the primary DB OS, pushed by Oracle's market share and strategy. Along with that, end-users and businesses will continue to argue that Vista is not good enough and will keep their efforts with their SaveXp.com campaign.

    That's pretty much how I see things for 2008 =)
    Last edited by Diabolic; 01-18-08 at 08:03.

  14. #14
    Join Date
    Jul 2007
    Posts
    10

    Hardware, Database, Business Intelligence

    Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us

  15. #15
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    threads merged (again)

    spammer banned
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •