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

Archives: December 2010

SQL Saturday 62 – Tampa FL – January 15th 2011

 

On January 15th, 2011, SQL Saturday is once again coming to Tampa Florida. This is going to be a tremendous event and you don’t want to miss it. There are also two all day sessions by Denny Cherry and Stacia Misner the day before. Regrettably, I am not… Read more

3 comments, 506 reads

Posted in BrianKMcDonald on 18 December 2010

Pragmatic Works Seeking Employment Candidates

If you’re anything like me, you enjoy constantly striving to new levels of knowledge. This new level of knowledge brings satisfaction, which in turn breeds new goals and objectives to meet. This always moving forward mentality can be very difficult, but the satisfaction gained can be well worth it. One… Read more

2 comments, 160 reads

Posted in BrianKMcDonald on 18 December 2010

Two Digit Year Cutoff

I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link from SQL Share regarding converting and the two digit year cutoff. It has been a long time since I had heard about this potentially critical issue when…

Read more

2 comments, 590 reads

Posted in BrianKMcDonald on 15 December 2010

Group Level Page Numbering using Reporting Services 2008 R2

Using SQL Server Reporting Services, we have always had the ability to use the built in fields (the Globals collection) to display page number and total pages for a report. One thing that was often desired (and extremely difficult and not reliable) was the capability to show page numbers within… Read more

3 comments, 5,326 reads

Posted in BrianKMcDonald on 14 December 2010

Adding Existing Reports to Reporting Services Solution

 

If you’re anything like me, you create a ton of objects and have them in various projects. And sometimes, you may want to include one of those objects in another project. This is often the case when you download an example from the web somewhere, but it doesn’t include the… Read more

1 comments, 184 reads

Posted in BrianKMcDonald on 13 December 2010

URL Based Images using SSRS

 

For header images, I typically embed an image into the report. However, there may be times when you need to create a report that makes use images from an external location. In this quick and simple post, I am going to show you how to point to an image that… Read more

2 comments, 313 reads

Posted in BrianKMcDonald on 13 December 2010

Automating the Processing of a Measure Groups Index Using SSIS

In a recent post (Processing a Measure Groups Index Using SSMS), I showed you how to utilize SQL Server Management Studio to process just the index of a measure group. In this post, I am going to show you how you can script the processing index out and… Read more

1 comments, 445 reads

Posted in BrianKMcDonald on 7 December 2010

Processing a Measure Groups Index Using SSMS

 

As I had mentioned in a previous blog (Creating and processing an Analysis Services partition), instead of processing an entire partition, you can process just the indexes. Processing measure group indexes will improve performance of your cubes! In this blog, I am going to walk you through processing… Read more

0 comments, 517 reads

Posted in BrianKMcDonald on 2 December 2010