On January 15 th , 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 able to make the full day sessions, but I will have an opportunity to get in front of you all to talk about SQL Server Reporting Services 2008. Although I am unsure what time that I will be presenting, here is the abstract that I submitted for m...
Read More
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 thing is for sure… if Pragmatic Works becomes the place for you…you’ll push yourself harder than you’ve ever been pushed. Many moons ago, I enjoyed being one of the Few, the Proud, the Marines. An...
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 using two digit years a query. In his video, Andy Warren ( BLOG | TWITTER ) gave a good idea to check for the value of this using sp_configure 'two digit year cutoff' if you are using a two digit year in your queries. Now I particularly woul...
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 entire project. Some of my blogs include the sample that I created for the blog. I don’t include the whole project, because I have assumed that one would know how to create a reporting services project and then add my report d...
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 is located on the internet. All you have to do is add a picture to your report design surface. Then set the Source to be “External” and the Value property of the image to the location of them image on the web. For example, in my example below,...
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 then run it from within an SSIS package. If you followed along in my last post, I will pick up on step number 4 where I updated the Processing Option to “Process Index”. Step 4 - Continued: Change Processing Options to “Process Index” Update the...
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 the index of a sample cube built using the AdventureWorksDW2008R2 database. Step 1: Connect up to your Analysis Services using SSMS So, let’s fire up SQL Server Management Studio and bet started. ...