Link to home
Start Free TrialLog in
Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America

asked on

High-level description of SQL and its security

I have a 2 page description of Working With Sql Server attached (about 380 words).

Could you please do some sanity check on its content to comment as to how I could improve it.

Note: This is bird-eye view and introductory to SQL Serever prepared for person with little programming skills and interest in the subject.
WorkingWithSqlServer2.docx
SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike Eghtebas

ASKER

re:> your security section still not right
I may have many things wrong. What will be helpful is take a sentence or two and write it they way it is right. By just saying it is not right, is not helpful at all.

re:> The analogy with a restaurant still not good.
I intend to keep this analogy but modify it in such a manner that makes sense. You are welcome to help me on that if you can come up with a better way of saying it. Or, make a better analogy.

re:> The authentication methods are two only
Yes, my bad. They are:
1. Windows level.     <-- authentication
2. Sever Level.          <-- authentication
3. Database Level.   <-- what you will name this? permission?  privilege?

What is the a common word (or category) for all three?

re:> definition of a Database Management System?
What about it. What is that you want me focus about this? Do you have a particular point you want me to focus on it?

re:> followed by the definitions of Instance, Database, Login, User and Schema.
The same as above.

re:> when you have these concepts in your mind
I think I have them in my mind hence this write-up. I probably miss some crucial aspects of them but you never give a clue in your post. I just wonder what exactly you mean. It will be helpful to give me something to go by.

I know that is not probably your style, but you are not telling me what is the problem just hinting there is problem.

Regards,

Mike
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Who are the users for this writing are:
- Myself to make sure I understand it.  <<< mainly this
- My college kid and friends.
- Number of my ex-project managers (now friends) who could really use some knowledge about SQL Server.
- All above who also need to use some basic T-SQL.