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

Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9

Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...

PASS for Today (and Tomorrow)

I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...

Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then possibly a manager or client.  Usually this comes up...