Simplified Automation
Managing Microsoft SQL Server necessitates a significant reliance on PowerShell. This is both a blessing and a curse. PowerShell provides administrators with the flexibility and power necessary to automate many of their processes and policies, but for the non-scripter, the learning curve for PowerShell is significant.

PowerWF makes SQL Server administration easier, by providing the power and flexibility of using a simple drag-and-drop paradigm for script creation.  PowerWF adds additional functionality not available in PowerShell.

Highlights

• Transform existing SQL Server PowerShell scripts into easily understood workflows in seconds.
• Publish frequently used workflows into PowerShell modules or windows applications.
• Combine SQL PowerShell activities with other PowerWF activities.

Automate Your Administrative Tasks

Organizations are increasingly looking to automate administrators’ daily tasks. Microsoft responded with two key technologies: Windows PowerShell, which has become the preferred scripting language for Windows administrators, and Windows Workflow Foundation, a rich visual environment for modeling and defining business rules.

PowerWF combines these technologies into a single easy-to-use development environment that replaces legacy batch files, scripts and custom application development, enabling the complete automation of IT Processes without writing a single line of code.

Greater automation speeds service delivery while reducing the risk of human error – the primary cause of downtime. Automated systems have lower maintenance costs, leaving more resources for new initiatives.