by
Abdul Majeed Asif Abdul , IT MANAGER / IT IN-CHARGE , ZAREE FACTORY FOR JEWELLERY-Riyadh Saudi Arabia
As per my experience Ms Access is out dated small database and no security as per compression MS SQL is most power full huge database and more secure, now a days every Ms Software is supported to MS SQL. if you have small or big organization you can connected with LAN, WAN or MAN and it's not possible to other Microsoft database and which person handle the MS SQL that per called MS SQL server database Administrator you can find where is MS SQL server.
Dana,
If you are looking for SSMS (SQL Server Management Studio) where you can write SQL queries, Frist, you have to install SQL Server on your computer. then open SSMS and you will get the window to write your queries.
If that doesn't answer your question, please be more specific in your question or elaborate the question.
Thank you.
if you want to learn SQL server you can get some from here :
if you are searching for the MS SQL Server software
you can download it from here
last one
[]ie
Well, DBA is Database Administrator as i guess you already know this and it is not a part of the tool rather he/she is someone with the most powerful rights of your database.
The Microsoft SQL Server Data Base Administrator (DBA) is responsible for:
Providing technical support for the database environment including:
- Overseeing the development and organization of the databases.
- Assessment and implementation of new technologies
- Providing IT Management with a long-term perspective on the relationship of database technology to the business opportunities facing the company.
The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.