What's New In Denali for SSRS

I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...

PASS, Keynotes and Tweeting

I have never had the opportunity to go to PASS before, but even though I was unable to attend this...

It's an Opportunity! Not an Obstacle!

Write this down… No really… Write it, print it, send it to all of your friends and loved ones. J...

My Fat Finger and the Target Invocation Exception

I was creating an SSIS package recently and ran into the “TargetInvocationException: Exception has been thrown by the target of...

Appending Date to End of Report Name in Reporting Services Subscription

Recently, a friend of mine asked me how he could have the date appended to the end of a file...

Blogging and Saving Money at the Same Time

I enjoy blogging. I enjoy passing on the information that I have gathered over the years. I also enjoy doing...

Windows 7 in GodMode

I recently became aware of a special hack in Windows 7. It is called GodMode and can very simply be...

SQLBIGeek’s Function Friday – Return First Date of Month

Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald

Welcome to the third post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...

SQLBIGeek’s Function Friday – Return Last Date of the Prior Month

Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
 
Welcome to the fourth post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...

How Stale Are My Statistics?

Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...