Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in ...

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

You've automated the SQL database backup process; now, let's restore in auto mode. Here's how to do it with PowerShell. In my last post, I demonstrated a script that can execute backups for a server.

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

Windows PowerShell has become an essential command-line tool for system administrators and advanced users. With an intuitive user experience, Windows PowerShell automates a wide range of Windows tasks ...