PowerShell

New-ScheduledTaskTrigger: limitation and workaround.

Creating a Scheduled Task that runs under a gMSA requires PowerShell.The Task Scheduler GUI insists on a password you don’t have. Problem I wanted to define a specific schedule to run a task: start at 08:00  stop at 15:00 after starting, repeat every 15 minutes only on Monday, Tuesday, and Wednesday At first glance, this […]

New-ScheduledTaskTrigger: limitation and workaround. Read More »

Streamlining SQL Server management: BLUEPRINT

This article covers the second step in the D-BART method, a structured approach to managing SQL Server environments. What’s in it for you? Fewer surprises: Know exactly how servers and databases are supposed to be set up Faster on-boarding: New team members follow defined steps, not guesswork Smoother automation: Standardized processes are easier to script

Streamlining SQL Server management: BLUEPRINT Read More »

Extract SQL Server query parameters from execution plans using PowerShell

Extract SQL Server query parameters from execution plans using PowerShell   When you extract query text from a SQL Server execution plan, you’ll often end up with something like this: Before it executes, you’ll need to declare every single parameter. Sure, you could copy them one by one from the plan… But that’s slow, repetitive

Extract SQL Server query parameters from execution plans using PowerShell Read More »

Scroll to Top