Wednesday, February 27, 2013

Understanding Roles, Permissions, Profiler and Data Collection

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

No comments:

Post a Comment