I am familiar with SQL and have created queries.
With TSQL the problem I'm having is I'm not sure which SQL Server system tables to look in for the data I need (there are a lot of tables to browse through....)
Is there a reference guide on the internet which could guide me to look at certain system tables for certain tasks. For example for backups look in msdb.dbo.backupset table, for monitoring replication look in msdb.dbo.sysreplicationalerts and msdb.dbo.sysalerts tables etc. etc.
I know how to query but when given a new task I'm a bit lost as to where to find my data, from which SQL server system tables.