Reporting Services 2008–Books

I have had a few people ask me recently about books that I would recommend to help further develop your...

Restoring a Certificate

I have written about creating a certificate and backing up a certificate, and the next step is the restoration of...

RYO Maintenance Plan – Index Maintenance

It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been...

SQL Server 2012 (“Denali”): Details on the next version of SSRS

SQL Server 2012 contains six new features for SSRS:
Excel Renderer for Microsoft Excel 2003, 2007 & 2010 - Excel renderer will support the Excel...

What Does a Database Administrator Actually Do?

Most people in your organisation, never mind everyone else, have no real clue as to what it is you do.
It’s...

Why We Follow Best Practices

Why We Follow Best Practices
Best Practices

There are many reasons why we follow best practices. My own reasons have changed over...

CPU-Z 1.60 Released

Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...

I'm presenting at 24 Hours of Pass!!

Woohoo!  I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass.  I am...

New upcoming events across Europe

I'm very happy today to announce 4 new upcoming SQL Server workshops across Europe
within the next months:

SQL Server Configuration...

Oracle Tips for MSBI Devs #1: Executing an Oracle Stored Proc with No Parameters in SSIS Execute SQL Task

Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...