Cláudio Silva
Cláudio Silva
hi @Franky1522 do you have more than one NIC on that server? Can you check on the error message if the IP of the "Could not connect because...[CLIENT: **XXX.XXX.XXX.XXX**]" entry...
I think this would make sense @potatoqualitee. Maybe a `Test` command. `Test-DbaLoginUnused` ? or something like that. @ddraillantclark do you want to give it a try? 😃 Also, I think...
When I do analysis of indexes that is something I have in mind. Key Columns + Include Columns also the compression type. That said, having this extra info can be...
Our checks, most of the time, just return a scalar value, right? It's an aggregated value like MAX, MIN, COUNT, etc. I think we can create a `SELECT` statement that...
As far as I know, in case of any kind of error on the sql side (syntax, not existing object, etc) the whole query will fail so we won't have...
Agree. But, assuming that we are using the T-SQL queries that dbatools does, that should cover us from things like 'this dmv only appeared on SQL XXXX' and therefore return...
Hi folks, We are still below the 700 mark. We have: 694 (Functions (692) + CmdLet (2)) And: 13 Alias
Hi @pradeep14333 , I have re-tested this: - Connect to Azure SQL Database - Copy the whole content of https://github.com/amachanic/sp_whoisactive/blob/master/sp_WhoIsActive.sql - Run it. Works without errors - Run `EXEC sp_WhoIsActive`...
HI @ZenoArrow, tldr; You can run either. To answer your question, please check this thread https://github.com/amachanic/sp_whoisactive/issues/4
@sanderstad do you have time to take a look? Thanks!