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

Resource Governor Configuration

Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...

SQL Server – How to troubleshoot query timeouts

Common reasons for query time-outs are :
1)     The application starts using a query not optimal for the index
2)     Hardware changes\...

A Script A Day Finished!

Well that's it, my "A Script A Day" series is finished.  I hope you found the scripts I provided useful, I've used...