Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
     
SQL Server Training Videos             * SSIS Training Videos
* SQL Programming Tutorials
* More Videobooks...
Email
Password
Register
LearnSqlServer.com Subscriber Videos
Security for SQL Server: Logins, Users, Roles and More - Video Category (all video categories)
Video Image Learn everything about authentication modes, server roles, what the term "fixed" means when discussing fixed server and fixed database roles, how users and schemas work and much more in this excellent set of videos on SQL Server security. This category of videos is designed to teach you all about principals, credentials, proxies and proxy accounts as well as Best Practices for SQL Server security.

Also in this category are discussions on SQL Injection and how hackers can attempt to attack your server.

Versions/Editions Covered: SQL Server 2000
Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (2 videos) - Cross Database Ownership Chaining   300 (Click for Videos) 19 mins.
Series (2 videos) - How to View Windows Logins in a Windows Group for a SQL Serv...   400 (Click for Videos) 19 mins.
Creating SQL Server Authentication Logins in the Enterprise Manager   200 Download 14 mins.
Peculiarities of the Database Role ddl_admin   400 Download 14 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Book You Should Probably Own: Rob Viera's "Professional SQL Server 2000 Programming"
You can disable the "sa" account by setting your SQL Server security mode to Windows Authentication Only. You will still have an "sa" account but it will not be able to log in to your SQL Server
User-defined data types are handy ways to create shortcuts to commonly used data type conventions. You could, for example, create the user-defined data type "Emails" to use as the data type for any column that stores email addresses
Company News
Visual Basic 2005/2008 Tutorials
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.
7/23/2008 10:02:28 PM