SSRS and Multi-Subnet Failover: The Connection String That Doesn’t Exist
SSRS has no way to specify MultiSubnetFailover=True in its ReportServer database connection. Here’s how to automate SSRS reconfiguration after an AG failover across subnets using rsconfig.exe, sp_update_jobstep, and a SQL Agent alert.
Statistics update job
SQL Server statistics are extremely important for good query performance since they provide invaluable guidelines that allow the query optimizer to pick an optimal plan. Out-of-date or non-existent statistics objects can cause excessive I/O, poor…
SQL Server Agent Job Activity
SQL Server Agent provides a graphical user interface to inspect the status of agent jobs. The Job Activity Monitor looks like: However, if you want to programmatically obtain the detail about running jobs, including details…