Performance Monitor Counters for SQL Server performance testing

I posted  “Window Perfmon scripting, SQL Server perfmon and how to perfmon” which refers to a performance monitor counters.
The  perfmon counters...

PerformancePoint – Using SSAS Actions

The latest project I worked on had a heavy dose of PerformancePoint and one of the requirements was to launch...

Re-blog – September 16 – September 22

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...

SQL Saturday 89 has come and gone!

All the planning, stressing, and freaking out about SQL Saturday #89 came to and end this past weekend.  We had...

SQLSaturday #85 is Tomorrow!

It’s 7am on Friday and I can’t wait for the day to end, head home to change and then go...

SQLSaturday Orlando Is Tomorrow!

Tomorrow marks the 4th annual SQLSaturday Orlando, held at Seminole State College in Sanford. We've got 46 sessions by 40+...

This field is missing from the returned result set from the data source.

This warning
The dataset ‘dataset1' contains a definition for the Field ‘column1'. This field is missing from the returned result set...

Using Unary Operators to control Analysis Services hierarchy aggregations

Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that...

Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL...

Miss 24 Hours of PASS ? No problem, all videos are online

All the videos for the sessions at 24 Hours of PASS are available for free.  Check the session schedule for...