Using CROSS APPLY instead of a calculated variable

Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working...

Speaking at PASS Summit 2013

I’m happy to announce that I have been selected to present

at the SQL PASS Summit in Charlotte, North Carolina this...

Cumulative Update – 11 for SQL Server 2008 SP3 Is Now Available !

The 11th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 11 contains all...

Wildcards and Indexes

I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...

Connecting a service between Publishing and Consuming SharePoint 2010 farm

Hello Friends,

As discussed in my previous blog the new architecture of Service Application in 2010. Let’s today discuss about connecting...

Do you check to see if an SSIS package has been modified?

Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...

SSAS Event Type Calculation Dimension

Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube.  For...

Blocking – Capturing and Monitoring

If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....

SSIS 2012 Deployment Fail

(Update: Part 2 focuses on clearing out the SSISDB by creating new stored proc based on the one used by the maintenance job. If your Maintenance Job is taking...

Digby’s Top 10 reasons you need a DBA

Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.

They can handle unexpected database growth...