Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2010

SQL Server Magazine’s Favorite Go-To Websites for SQL Server Solutions

While flipping through this month’s SQL Server Magazine (December 2010), I came across what I thought was a very interesting top 10 list of “Favorite Go-To Websites for SQL Server Solutions”. I could not find the list on the website, but if you have the December… Read more

3 comments, 1,848 reads

Posted in BrianKMcDonald on 30 November 2010

SSIS Package Annotation in Denali

If you are anything like me, you document your SSIS packages for those who may have to maintain them after you move on to other projects. One thing that have disliked is how annotations worked in SSIS. There is no word wrap setting to automatically wrap to the next line,… Read more

12 comments, 1,918 reads

Posted in BrianKMcDonald on 30 November 2010

Column Based Indexing in Denali

Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had seen a session about column based indexing. The client was really eager to begin testing in their environment to see what kind of performance boosts they would gain. As an… Read more

3 comments, 502 reads

Posted in BrianKMcDonald on 24 November 2010

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 almost immediately went to download it and then I looked for what was new. J Unfortunately though, in the CTP that was released, there are no changes to Reporting Services.… Read more

3 comments, 236 reads

Posted in BrianKMcDonald on 23 November 2010

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 almost immediately went to download it and then I looked for what was new. J Unfortunately though, in the CTP that was released, there are no changes to Reporting Services.… Read more

1 comments, 253 reads

Posted in BrianKMcDonald on 16 November 2010

PASS, Keynotes and Tweeting

I have never had the opportunity to go to PASS before, but even though I was unable to attend this year, I sort of felt like I did! J The reason that I felt like I was there is because I was able to watch recordings of the keynotes and… Read more

0 comments, 129 reads

Posted in BrianKMcDonald on 15 November 2010

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 All kidding aside, I believe this to be a good quote to remember! There are many variations out there of this saying, but this is one version that I really… Read more

0 comments, 149 reads

Posted in BrianKMcDonald on 15 November 2010

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 an invocation” error as shown in figure 1 below.

 

Figure 1: Target Invocation Error

 

This happened to me a year or so ago, but I think my resolution was to… Read more

1 comments, 250 reads

Posted in BrianKMcDonald on 12 November 2010

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 name when creating a standard subscription in Reporting Services. At first the requirement was straight forward as it only needed date and it would need to be saved to a… Read more

2 comments, 1,008 reads

Posted in BrianKMcDonald on 9 November 2010

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 this while watching television. Currently I subscribe to Directv, but that is all about to change. This blog is about blogging in general, but more importantly it is about blogging… Read more

1 comments, 153 reads

Posted in BrianKMcDonald on 9 November 2010

Windows 7 in GodMode

I recently became aware of a special hack in Windows 7. It is called GodMode and can very simply be one of the easiest hacks that I’ve ever seen. I guess technically it’s not a hack because it is more or less a hidden feature. A feature which allows you… Read more

3 comments, 230 reads

Posted in BrianKMcDonald on 9 November 2010

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 hoping that I can provide some of the details about functions that I have either found on the internet or something that I had to create…

Read more

0 comments, 231 reads

Posted in BrianKMcDonald on 6 November 2010

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 hoping that I can provide some of the details about functions that I have either found on the internet or something that I had…

Read more

1 comments, 243 reads

Posted in BrianKMcDonald on 5 November 2010

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 frequently! A while ago, I showed you how to find out what indexes were on a table using the GUI. Then, I showed you how to generate a listing…

Read more

12 comments, 3,216 reads

Posted in BrianKMcDonald on 5 November 2010

Expression Based Interactive Sorting using Reporting Services 2008 – Part 2 Dynamic Sort By

In a previous blog written back in June, I showed you how to use the interactive sort option on a table header text box using values returned from a data set. I also wrote this back in June, but it got lost in my “blogpile”. J At any rate, in… Read more

1 comments, 1,174 reads

Posted in BrianKMcDonald on 4 November 2010

Help! I Can’t Connect to Analysis Services in SSMS

A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well. While playing around with SSAS, I tried to open up SQL Server Management Studio (SSMS) and connect up to Analysis Services. The screenshot below shows how I tried to connect. Read more

0 comments, 747 reads

Posted in BrianKMcDonald on 2 November 2010