Thanks for showing what is available in the mssql VSCode-extension

Doesn't that show up in timesheets? Time spent actual work : 6 hours, Time spent administration/meetings 34h

Hmm, you may find the range with cross apply

Perhaps you can get lucky with windows functions

/*pseudocode as there is no copy paste sample data*/
with payments

(

select current.key currentpayment,...

Windows functions / CTE: ease of querying

Extended events for finding specific occurences

Query Store: what queries are likely the culprit

SSRS / SSAS albeit getting outdated

Read committed snapshot isolation: similar like Oracle,...

Wow, luckily you got that camping trip

Most run on standard edition, only BI has enterprise due bundle with powerbi report server

Hmm, the newletters url's point to the same article of Koen

Post with links to those articles got automatically removed

Jasona, I would go camping, as you said time with family is valuable

What do you do when business wants an on-premises "backup" just in case the cloud would vanish or become unavailable. (We would have other problems, but let start with this)

Creating...

1.

You can probably disable step 3 "Reorganize index" in this modern world, saving a lot of io/time for minimal gains

Step 4 "Update statistics" is usually sufficient to get the best...

For SSIS, there is a property "Clean logs periodically" with retention days. This probably creates an "SSIS Server Maintenance Job" sql agent job.

For maintenance plans you can create a new...

Can you refine the logic with some sample data / wanted output?

select *
from A
where not exists (select * from b where a.server=b.server and a.login=b.login )

or 

select *
from...

At first glance you use a lot of user defined functions. That makes it difficult for the SQL Server to optimize the execution as it is hidden in function logic.

Have...

Indeed, was for a different post. Your answer should work. My usual culprit is a monitoring tool