In case you didn’t see the email come through for PASS this week the SQL Rally schedule is now available. The event will be in Dallas May 10-11 with lots of great session so be sure to check it out. Here’s a link to the PDF or I’ve included screenshots here… Read more
This month I’ll be out and about quite a bit with speaking events. Thought I’d detail them quickly in case you’re in Florida or interested in attending a free webinar. Most topics on reporting of some nature this month.
SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released the schedule for the event. We have a great line up of speakers with a variety of topics for both DBAs and Business Intelligence developers. You can register to attend… Read more
If you’ve followed this blog series from the beginning then you may have started thinking about which tools would be best for your environment. If so that’s great and I’m glad I got you thinking, but I encourage you to keep an open mind as we go through the last… Read more
Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your reporting needs. So far I’ve discussed in previous posts:
You learned how these two tools are almost opposites of… Read more
Another release that went without much trumpeting was the SQL Server 2012
Data Mining add-in for Excel 2010. This has been a much awaited release for
those vested in Data Mining.
The current release was only available for Excel 2007 and if you tried to use
it in Excel 2010… Read more
Somewhat overshadowed, for obvious reasons, by the big RTM release of SQL Server 2012 was the RTM release of PowerPivot 2012. You can go download the much improved version of PowerPivot for Excel here.
To give you a fair warning there are some prerequisites to installing that were not… Read more
This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools purpose and when you should choose each for your reporting solution. The decision to pick the appropriate tool is difficult but so very important as I detailed in part one Read more
As Business Intelligence has evolved over the years the number of tools we have to choose from for presenting data has advanced drastically. With so many tools to choose from it can be rather confusing (especially when your company is just getting their feet wet in BI) to determine which… Read more
Reporting Services performance problems can often be narrowed down to report design or resource constraints and sometimes a combination of the two. In this post I’ll review the process of scaling-out Reporting Services so server resource constraints can be shared across multiple servers instead of relying on a single server… Read more
Have you ever experienced this?
You have developed a set of Reporting Services report that your users love and they often show them off. The most common way users show off the reports is by taking screenshot images of the reports and embedding those images in a PowerPoint slide deck… Read more
|Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you. Prepare for Marketing email…|
I’m so excited to tell you about SQL Saturday 130 in Jacksonville coming April 28th. This is the 5th year SQL Saturday has been held in Jacksonville and we have some exciting news about the event this year.
If you have never attended a SQL Saturday before… WHERE HAVE YOU… Read more
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They give you the ability to monitor Analysis Services usage and metadata.
MSDN articles on SSAS DMVs – http://msdn.microsoft.com/en-us/library/ms126079.aspx
Good post on using SSAS DMVs – http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/
A report developer could… Read more
In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting Services. This week I will show you another method of using custom code but this time with external assemblies. Ideally when using custom code you would choose to do so… Read more
This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but seeing that I know I’ll only get to a third of these thought I would post these for everyone. If you’re seeing this late the sessions are recorded and can… Read more
It has been a quiet past few months while my family has adjusted to having
two new additions (twins!), but I have slowly been working my way back into
several speaking events. Having said that January is a busy month of events and
I thought I would share them in… Read more
When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting dynamic. The expression
language can do a lot to within Reporting Services but any gaps in functionality
that it has can be filled with custom code.
There are two ways… Read more
Display folders are an often used tool in Analysis Services to help end users navigate through a cube or dimension they could find what they need to build a report. Imagine you develop a cube that has dozens of measures. For an end user to find what they need they… Read more
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your environment. Often I see developers deploy directly from BIDS to all Development, QA, and Production environment by changing the project properties to the different instances. For multiple reasons this is… Read more