SQLOpsDB Dashboard is primary report where all investigation starts for data collection. The database dataset is generated at the end of execution of the SQLOpsDB_DataCollection.ps1
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
SQLOpsDB PowerShell Module
The PowerShell model is the primary code for collecting and updating the information. The command-lets in this module are broken into three categories. I have
Windows Task Scheduler for SQLOpsDB
The Windows Task Scheduler executes the PowerShell script for data collection for both SQLOpsDB data collection and configuration health. These collections can be completed via
SQLOpsDB Reports
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
SQL Canada (SQLCAN) 