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

Throughout this series of posts there have been a number of examples of how to use the SQL Server PowerShell provider. However, these were always in context with a specific task (i.e. automating ...

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

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

SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...