Shawn Melton

How do you define default directory paths?

Are you saying a config for each so you can run a check to find databases that are not in those paths? That does not make much sense to me...

@TheRockStarDBA so you are referring to a standard drive letter being mapped to your mount point across all servers in order to check the path of data files? If we...

The example/situation in that post applies to any object in SQL Server...especially databases and SQL Agent jobs. If the login that owns the object is dropped then access to that...

Well in most cases you cannot set the owner to `sa` for the AG because you have to create it under that account. I don't use `sa` in client environments...

@TheRockStarDBA that still goes to my main point, it applies to any object in SQL Server. As well, it will rarely ever be the `sa` login that owns anything in...

So basically: a job in dbareports that could look at a folder location to import data you send to the monitor server and import into the dbareports database?

> For me dbachecks is not a tool for spot checks I don't see that as the norm. If I've run the whole dbachecks against my enterprise and I've gone...

Why would you be looking or parsing the definition of an view to see if it contained specific text? You can hit `Get-DbaDatabaseView` and [check ](https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.view.aspx)`IsSchemaBound`  ```sql USE [dbatoolsci_lildb]...

[STIG_SQLServer2014_v1r5.pdf](https://github.com/potatoqualitee/dbachecks/files/1587650/STIG_SQLServer2014_v1r5.pdf)