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

SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

I'm not much of a BATCH scripter (More of a BASH scripter) but I have an issue I need to work out and would like some help (Though I've probably already hexed myself by admitting I work in Linux). I'm ...

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

As today’s database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...

I want to enable notifications for SQL Agent for my backup jobs.<BR><BR>I configured database mail and that works, it sent me a test message.<BR><BR>However, when I go to tell the SQL Agent to use it, ...