SQL Server provides server-level roles to help you manage the permissions in Securing the SQLServer.
SQL Server Profiler is a nice interface to create and manage traces and analyze and replay trace results to diagnose a problem
See the below video tutorials to learn about Roles, Permissions, Profiler and Data Collection
Understanding Permissions in SQL Server
Understanding Roles in SQL Server
Fixed Server-Level Roles in SQL Server
Database Level Roles in SQL Server
Authentication Modes in SQL Server
Principals and Securables in SQL Server
Principal and Securable Hierarchy in SQL Server
Securing SQL Server
SQL Server Profiler part 1
SQL Server Profiler part 2
Pages and Extents in SQL Server
Understanding FillFactor in SQL Server
Linked Server vs Openrowset in SQL Server
Data Collector in SQL Server
SQL Server Standard Reports
SQL Server Best Practice Analyzer
Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment