Microsoft Releases SQL Server 2008 SP3 Cumulative Update 4

Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes...

Spring DevConnections 2012

Hello Dear Reader, this week finds me in beautiful Miami FL.  Next week I’ll be in Vegas, for one night...

Wish you were here

When I was growing up, we used to sit round the t.v. (families only had one in those days) and...

Speaking at SQL Saturday Houston

It’s SQL Saturday season again!  I found out this morning that I’ll be speaking at next month’s SQL Saturday event...

STOP! Consolidate and Listen

I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance,...

Comparing users and role memberships between two databases

The other day I was asked to restore a production database into a development environment and then check the database...

Choosing the Right Microsoft Reporting Technology Part 4: PerformancePoint

If you’ve followed this blog series from the beginning then you may have started thinking about which tools would be...

Whitepaper: Demystify Tempdb Performance & Management

Whitepaper: Demystify Tempdb Performance & Management
Demystify Tempdb Performance & Management

There are many misconceptions and myths about tempdb and purported best practices are...

Error: Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'.

To create a PowerView report first we need to create a BI Semantic Model Connection,

but If we did not deploy...

SSIS: Script Component Asynchronous Transformation

The SSIS script component can be configured to use synchronous or asynchronous outputs.  If the script component is configured for...