โ Scribed by Edward Whalen, Victor Isakov, Marcilina Garcia, Burzin Patel, Stacia Misner
No coin nor oath required. For personal study only.
It is a big heavy book with lots of screen shots and descriptions of each screen shot with some process description. The CD that comes with it is good to search for topics using key words.
Chapter 31 is good - it explains what each of the management views provide.
However, it does not explain how to accomplish something or what the best practice is.
For Example: How do I set up a user login to have read only access to a specific schema? What do I create first a login, schema, or a role? All the security screens seem to have overlapping inputs. I set up a login user. I setup roles. I setup schemas. I create a View but I still only find the dbo schema? What about the other 2 schemas I created? How do I know the security I am setting up will not lock me out of the database next time I login? What is the highest level adimin security I should set and must have - the "super level" that I should not change so I have access and no one else does. Is it possible to check the wrong thing and lock everyone out of the database?
The book tells me what is in each screen and the things I can check off....
The SQL Server 2005 Pocket Consultant explains more on some of these subjects....
๐ SIMILAR VOLUMES
Those of you who are currently using Microsoft SQL Server 7 might not notice significant changes on the surface when you move to Microsoft SQL Server 2000. You will soon observe, however, that SQL Server 2000 includes many enhancements. One major enhancement is increased support for larger memory mo
This book is very thin on where you need it most. For instance, only the very very basics of SCR is mentioned. They do not even mention how to restore SCR. Try another book. Add-ADPermission, a command that is commonly used in Exchange, is not even found. A thick book, but nothing really covered wel
Get your mission-critical systems up and running quickly with this essential, single-volume guide to administering Windows Small Business Server 2003 R2. This comprehensive reference details operating system features and capabilities, and provides easy-to-follow procedures, practical workarounds, an