Results 1 to 5 of 5

Thread: Microsoft SQL Tools

  1. #1

    Default Microsoft SQL Tools

    Hello everyone,

    Before you start telling me about how much cooler mysql is, I agree with YOU. However, I've been told I need to learn more about sql and queries and views and blah blah blah. Please note the boss said SQL from Microsoft, this is what runs as part of our paid for app that we use heavily. I was wondering if there were any tools someone could recommend for me to run in my SuSE install so that I can "Manage" a Microsoft SQL database. any suggestions?

    Keep in mind, I don't really have any idea about databases and such and am learning as I go. Newbie

  2. #2
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    24,851

    Default Re: Microsoft SQL Tools

    As SQL is rather standardised you could go to MySQL's website MySQL :: MySQL Documentation: MySQL Reference Manuals . There is a lot of docs there, also General and Tutorials. You could combine this with installing MySQL from the standard repos for trial and error.
    Henk van Velden

  3. #3

    Default Re: Microsoft SQL Tools

    Cool thanks for the quick reply.

  4. #4

    Default Re: Microsoft SQL Tools

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    JDBC-based tools are also available for use with any old database. I use
    DB Visualizer (the free version) on my Linux box to connect to every RDBMS
    I've ever seen. It does not always give you as much functionality with
    some non-SQL-based administrative tasks as a native tool but it will give
    you better database skills in general and a consistent view across
    platforms (one tool instead of dozens). With really good databases that
    let you do everything via SQL (MySQL, Oracle, etc.) you can do just about
    everything via SQL. mssql has not been as friendly for me but that seems
    to mostly be tied to the requirement for GUI tools.

    Good luck.





    On 05/06/2010 10:16 AM, danrche wrote:
    >
    > Cool thanks for the quick reply.
    >
    >

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.12 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

    iQIcBAEBAgAGBQJL4vR2AAoJEF+XTK08PnB5fLwQAITJC/PffCT6E/qrS7pBzlxP
    k/Er6lHJaZCQQixo0PQlxhE35+r2xf1DhuXytG64WBzEZEwHXEOeUJUR8RgAEd1g
    bpOPamVscmxBhvqu9CV7kqx34y861S14IAyq2UkJ6w2M2oyYgL3m7bonuXDpBHQX
    7alQV59Y26imguzy4L38H4IQA01PtZsOocVUD0sTs/AKGCQvUhfSAL/KhCX1hQ1O
    pv7/MXKP/CIiXi94NtXFz5jb8pR202mTOfFcxkv0+CNwNavV1cqrHziZwJ06IpOW
    6jZU3udm6K4GqXbOB+kEfif0VeZuqwCAoDqKHcpRuSbNVnMUS+5QzjHhFeQA6FRL
    e1Doartq2USIOuC94X+cgAI379ovNWgnEfNpkcqbeWq1sbQ95EF2ZAEc2G3zL/zB
    J41860vJwL3Fk+gL76uLmZcx9hCl/ljtTk3PfBXev0Q7rpqaCD9st42Dy0GZri0Q
    g7oa7FtCdxSkEp/JleH8pQAlo0AnJEgbYBILy62vPA9M43daK23Kr3tlBmimkalu
    Gwn0lLzWQpMnwao62xd4FL7goaxCColIi3DMEr39tuWlNvY0chwp6/Ze1tphhLhB
    PPaDOCwZ3c7qDywO+l0XXHxuPjvWq8PHcYk23clo+clS6iT5GohJTFap63Lyqa+z
    E25svFNWuoow7aFffxAw
    =czhp
    -----END PGP SIGNATURE-----

  5. #5
    Will Honea NNTP User

    Default Re: Microsoft SQL Tools

    danrche wrote:

    >
    > Hello everyone,
    >
    > Before you start telling me about how much cooler mysql is, I agree
    > with YOU. However, I've been told I need to learn more about sql and
    > queries and views and blah blah blah. Please note the boss said SQL from
    > Microsoft, this is what runs as part of our paid for app that we use
    > heavily. I was wondering if there were any tools someone could recommend
    > for me to run in my SuSE install so that I can "Manage" a Microsoft SQL
    > database. any suggestions?
    >
    > Keep in mind, I don't really have any idea about databases and such and
    > am learning as I go. Newbie


    You'll need a printed copy to mark up and refer to. It's hard to beat
    O'Reilly's "SQL in a Nutshell" for an general SQL reference. The bonus is
    that it includes a good reference to the differences in the dialects of
    most popular RDMS out there which helps extend what you might already know
    on one database to others.

    That said, the admin side of any database is a whole other ball of wax - and
    a career field of own. User management, storage design, and performance
    tuning are unique to each system. One of the better bets is to find a
    friendly forum - maybe comp.database.ms-sqlserver might be a good start
    although I have never used it. I know that the DB2 and Oracle forums in
    that group are both pretty useful.

    Good luck - the DBA field is can be rewarding but don't think it's going to
    be a picnic or part-time job ;-). You will be dealing with the most
    obnoxious clientele possible: users.

    --
    Will Honea

Posting Permissions

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