Here’s an article by Mark Kromer (SQL Magazine – SQL Server BI Blog) on his views on the Old BI (traditional ETL/DW) vs. New BI (Big Data Hadoop) paradigms, and how a hybrid approach of traditional ETL/DW with Hadoop and MPP is emerging.
Over the last 3 years I have developed a range of major PowerShell scripts to deploy/configure Replication, SQL Server clustering onto multiple nodes and to perform Database Maintenance tasks (think Ola Hallengren SQL maintenance solution but in PowerShell).
I recently had the requirement to configure log shipping in a SQL 2008 R2 Standard Edition environment. In my scenario, we needed to move a two node cluster to another floor but also attach it to a new SAN, have minimal downtime, no data loss and use the current server hardware.