When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.

Data Compression Double Take

by Tony Davis

SQLServerCentral

Editorial

A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.

SQL Saturday #110 - Tampa

by Press Release

SQLServerCentral.com

SQL Saturday

Come to a free day of SQL Server training in Tampa, FL on Mar 10, 2012.

The Road to Professional Database Development: Set-Based Thinking

by Additional Articles

SimpleTalk

Set Based

Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his secrets.

Eliminating Duplicate Rows using The PARTITION BY clause

by Suresh Maganti

SQLServerCentral.com

T-SQL

The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.

High Availability Upgrades

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones has a poll about the new AlwaysOn feature in SQL Server 2012. Is it worth the upgrade for your company?

Stairway to SQL Server Replication - Level 8: Merge Replication – How it works

by Sebastian-Meine

SQLServerCentral.com

How merge replication works, including the impact on the published database. The merge agent, different conflict situations and their resolutions are introduced.

Exploring SSIS Architecture and Execution History Through Scripting

by Additional Articles

SimpleTalk

Integration Services (SSIS)

When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in T-SQL as Feodor Georgiev explains.