In a previous tip on Backup and Restore SQL Server databases programmatically with SMO, you've seen how you can use Windows PowerShell to backup and restore SQL Server databases. In this tip, I will cover how to use Windows PowerShell to generate SQL Server backups  Read more...

Describes a process to create a consolidated space forecasting report, which focuses on a "days remaining" metric.  Read more...

In a previous tip on SQL Script Generation Programmatically with SMO, you've seen how you can use SMO to generate SQL scripts programmatically. In this tip I will cover how to generate scripts using Windows PowerShell.  Read more...

In my last blog post, I discussed how to get PowerShell and SQLPS up and running on your machine(s). And...  Read more...

Many DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You...  Read more...

Using PowerShell and a little bit of .NET Framework and XML knowledge, it is possible to delve a little deeper into the information which is potentially available to you from Twitter. Jonathan explains about Twitter and shows how to use Powershell to access twitter automatically.  Read more...

Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?  Read more...

I would like to translate some of the Transact-SQL scripts that I use every day, starting with the simple ones like retrieving a list of databases and their properties for auditing purposes.  Read more...

Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.   Read more...

I want to know how Windows PowerShell can help me as a SQL Server DBA.  Read more...

This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.  Read more...

Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.  Read more...

Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...  Read more...

Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring automation scripts in powershell was that there is no simple way to get the SQL Server's fully qualified domain name. I didn't want to...  Read more...

This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.  Read more...

To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.  Read more...

Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.  Read more...

Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.  Read more...

I have been hearing about Microsoft's scripting language called Windows PowerShell which is extensively used nowdays for administering and managing Windows servers and workstations. Exchange Server 2007 and Windows Server 2008 are just two of the Microsoft server products that have included this as part of their administrative tools. I want to know how Windows PowerShell can help me as a SQL Server DBA.  Read more...

Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.  Read more...

Describes a process to create a consolidated space forecasting report, which focuses on a "days remaining" metric.  Read more...

Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.   Read more...

Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.  Read more...