D-Bart – Blog

Streamlining SQL Server management in larger environments.

April 26, 2025 / bart / DBA, SQLServer, TeamEfficiency

When you’re managing just a few SQL-Server instances or databases, a structured approach might be unnecessary. However, as the number of databases and SQL-Servers increases, complexity grows exponentially. Without standardization and automation, managing a growing number of databases will lead to increased operational risks and necessitate a larger DBA-team than initially planned. Implementing standardized processes […]

Streamlining SQL Server management in larger environments. Read More »

Extract SQL Server query parameters from execution plans using PowerShell

April 22, 2025 / bart / PowerShell, QueryPlan

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 »

Bypass slow Query Store interface with T-SQL query

September 10, 2024 / bart / Query store

The Query Store in SSMS is a powerful tool for tracking query performance, but its graphical interface can become a bottleneck, particularly when dealing with large datasets or complex environments.

Bypass slow Query Store interface with T-SQL query Read More »