All the report files are accessible directly or indirectly from the primary report “SQLOpDB Dashboard.” I would recommend after deployment to hide all the reports
SQL Server Policies for SQLOpsDB
The SQL Server policies are part of collection from Microsoft default best practice policies plus additional policies I have written over the year. The policies
Linked Servers Connection Issue – Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’
Creating a connect to the Linked Server within SQL Server, however it fails with following error. “The linked server has been created but failed a
Central Management Server (CMS) for SQLOpsDB
The CMS is the driver of all the data collection needs. When registering a server in CMS, follow these best practices. Register only the replicas,
SQLOpsDB Requirements
As stated in SQLOpDB Architecture, there are three components to configure, collect data, and do reporting. The requirements are briefly discussed on the GitHub page.
SQLOpsDB Architecture
Over the years I have tried to minimize number of moving parts in the architecture. The overall architecture can be broken down into three primary
SQL Canada (SQLCAN) 