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

There is currently a lease on the blob and no lease ID was specified in the request

I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well,...

Get synonym definitions for all databases in server

If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...

SQL Server Security Webcast Questions – Series Introduction

Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s.  A video...