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

Microsoft Lync Through the Web

Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...

Consulting company: Perm/Salaried vs 1099/W2

One of my pet peeves is seeing a top-notch BI architect/developer working as a salaried/perm employee of a consulting company...

Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations

A little more than a year ago while working at Idera, I was consulted on reports from a few clients...

SQL Saturday Atlanta was incredible

This past Saturday I was fortunate enough to present a session at the largest SQL Saturday EVER in Alpharetta GA....

Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller

Development and demo environments can be hard to come by. Over the course of this series you will learn how...