MS SQL Server DBA Classroom Training and Certification Classes

SQL Profiler in the SQL Server Utility can be used to trace the traffic hitting SQL Server.

It serves as a template for all databases created on the same instance. Modifying the model database will automatically bring the changes in all subsequent databases created on that instance.

•  Snapshot
• Merge
• Transaction

It is a job scheduling mechanism in SQL Server that allows jobs to run at a pre-determined mind. Most commonly SQL Agent is used to schedule administrative jobs such as backups.

DBCC statements are Database Console Commands and it is of four types

• Maintenance
• Informational
• Validation
• Miscellaneous

•  SQL Server supports Windows Authentication and mixed-mode.
• Name few native SQL Server performance monitoring and tuning tools
• System objects
• Profiler
• Perfmon/System Monitor
• Dynamic Management Views and Functions
• SQL Server Management Studio Built-in Performance Reports
• TYPEPERF.EXE

•  CREATE INDEX with DROP_EXISTING
• DROP INDEX and CREATE INDEX
• ALTER INDEX