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
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.
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/
>
> 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.
