new to sql server and have a couple of questions 1

[benedictbutlin]

I'm not familiar with microsoft sql server, and have a few questions...

- i'm guessing MSSQL sits on a windows OS server only, and the application is not cross compatible with other OS's? Is there a linux version?

- is it possible to remote access MSSQL from an sql client? for example, an SQL client working on OS X?

- or in general, is it possible to use a variance of remote connections, or is MSSQL limited, does it have many blockages or challenges compared to other DB apps we all know and love?

- looking at the MSSQL screen shots it looks very cumbersome... is it mostly configurable via it's GUI interface, or can we interface, manage and send queries to it using the traditional SQL client or SSH methods?

 

[yelworcm]

You are correct. MSSQL only runs on a windows platform. No linux version exists.

MSSQL is accessible through most of the same protocols that other database server software can be accessed with. JDBC will likely be how you connect from OS X. There may be ways to connect via ODBC as well, so check the documentation for the language you are using.

All database software will have its quirks that you will have to get used to. Unless you are secretly a fan of another RDBMS, you would not find more or less problems with MSSQL.

MSSQL can be mostly configured with SQL commands. There are a few things that end up in the registry, but you never hit them that often. Typically, you set a thing up once, and the server runs like that for the rest of its life.

 

[benedictbutlin]

cheers yelworcm!