It is possible to use the SQL Server Agent to execute PowerShell scripts. If you've worked with the SQL Server Agent to run jobs on your server, you already know that whenever you define a job step, ...

We've been looking at ways you can leverage and extend all the PowerShell knowledge you've gleaned over the course of this column. I want to wrap up with a peek at what you can do with SQL Server 2008 ...

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

If you are an old hand at Microsoft SQL Server, you have probably used the SQL Server Agent (i.e., SQL Agent) service and MSDB database for the last 20 years. With a humble and largely unchanged ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. We may earn ...

Microsoft shipped SQL Server Management Studio 22.7.0 on Wednesday, June 10, 2026, in what the team called one of the bigger point releases in the 22.x cycle. Database developers who have spent years ...