I have tried to automate parts of the deployment. When deploying the current version, there is no way to upgrade from an existing deployment. In
SQL Server Opertional Dasbhoard
I am releasing a solution that I have worked on for on-and-off for many years for many different customers. The solution is combination of the
Forgotten Blog / Busy Life
I’ve been guilty of abandoning this blog for quite a while. Not because I haven’t been doing new or interesting things. In fact, I’ve probably
SQLOpsDB Reports: Security Lookup
Ever had a person leave the organization or your team and wanting to know where do they have access? What explicit permissions, logins, or database
SQLOpsDB Reports: Application
The SQLOpsDB data collection can help build an inventory of applications and their respective owners. For each database introduce the following extended properties on the
SQLOpsDB Reports: Dashboard – Drill Through
As stated in previous reports, all the dashboard elements offer drill through. To investigate the additional details behind the summary data. The summary layout is
SQLOpsDB Reports: Dashboard
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
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
SQL Canada (SQLCAN) 