PASS 2011 Countdown – 3 Weeks To Go

Another week down and there are now 3-weeks until this year’s PASS Summit.  Take a moment and register now if...

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

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

CU 16 for SQL Server 2008 SP1

 
Microsoft has recently released a Cumulative Update (CU) # 16 for SQL Server 2008 SP1 which contains hotfixes which were resolved...

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

SSIS version in SQL Server

Integration Services is the management interface for  SSIS packages. SQL Server uses  the “MsDtsSrvr.exe”  for executing packages
To highlight the point,...

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

Replacing a SQL Cursor with SSIS

On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...

SQLSaturday #85 - Orlando, Florida - September 24, 2011

Fortunately, SQLSaturday#85 stands in a class by itself - it's the only SQLSaturday scheduled this upcoming weekend in sunny Orlando, Florida.
Home...

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