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 ...

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.

As a SQL Server administrator, you have a lot on your plate. There's server configuration, database design, performance tuning, troubleshooting, security and a host of other tasks all vying for ...

Microsoft continues to make positive strides in the world of open source. The company once considered open source software to be an anathema, but now it's common for Microsoft to pull software ...