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

SolidQ Journal September Edition

The 13th edition of The SolidQ Journal has just been released with several insightful articles and continued series updates.  In this edition:

  • Fernando G. Guerrero:  editorial deals with Microsoft giving new wings to an entire industry
  • Laurent Martin:  static relational interval trees, an article based on real customer…

Read more

0 comments, 353 reads

Posted in SQL Server BI Blog on 26 September 2011

Come to SQL Saturday 92 in Portland

Are you In Portland, Oregon?

Do you plan to be in Portland on Saturday, October 8th?

Can you be in Portland on October 8th?

…then go to the Oregon SQL Saturday #92. Register right now. Yes, now!

We have dozens of great speakers coming from all over the world. … Read more

0 comments, 191 reads

Posted in SQL Server BI Blog on 9 September 2011

24 Hours of PASS & SQL Saturday(s)

I survived 24 Hours of PASS!  Just wrapped up delivering my presentation for the 24 Hours of PASS (24HOP) on Visual Report Design.  I appreciate the 300+ attendees for showing up.

24HOP is a preview of sessions for the upcoming PASS Global Summit in October.  I did a mini version… Read more

0 comments, 257 reads

Posted in SQL Server BI Blog on 9 September 2011

What Will Be New for Reporting Services in 2012?

Drum roll, please!   We’re in the throws of refreshing the Wrox Professional Series book on Reporting Services and, as we do with every new edition, the authors are paying close attention to differences between the old and new product versions.  I thought it was worth noting what will be new… Read more

5 comments, 695 reads

Posted in SQL Server BI Blog on 21 August 2011

Analysis Services Operations Guide Released

The Analysis Services team has been working overtime lately to provide added community support for the traditional UDM-based OLAP engine (not that any of these people have actually ever worked as little as a 40 hour week in their tenure at Microsoft!)  In light of the team’s focus on project… Read more

1 comments, 408 reads

Posted in SQL Server BI Blog on 3 June 2011

DQ & MDM Book Available to Download

If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2, a new book is available.  My colleagues Dejan Sarka and Davide Mauri at SolidQ have completed their book on DQ & MDM in SQL Server 2008 R2 and it’s available… Read more

0 comments, 503 reads

Posted in SQL Server BI Blog on 1 June 2011

Let’s Get Visual – The Art of Report Design

Paul Turley
Mentor, SolidQ

This article is based on my session at TechEd on May 18th, 2011

Report styles vary depending on the needs of the consumer and purpose of the report. With so many capabilities in current reporting toolsets, report designers are often prone to add graphics, color and… Read more

2 comments, 1,665 reads

Posted in SQL Server BI Blog on 23 May 2011

Correcting Image Distortion in PDF Reports

I’ve seen a  few cases where reports exported or rendered to PDF have distorted charts and images.  We’ve played with fonts and chart properties have sort of accidentally corrected the issue but without really getting to the core problem.  There’ been quite a bit of traffic generated on the MSDN… Read more

2 comments, 666 reads

Posted in SQL Server BI Blog on 5 May 2011

Designing Reports with Custom MDX Queries – part 2

…continued from part 1:

Building a Report

For the remainder of this article, I will demonstrate query and report design techniques by progressively building a report, adding steps and features. The examples will focus on the capabilities of the query and results, rather than the visual design of the…

Read more

0 comments, 780 reads

Posted in SQL Server BI Blog on 4 May 2011

Designing Reports with Custom MDX Queries – part 3

Start at part 1

…continued from part 2:

Handling Parameters

When an MDX query is created using the graphic query designer, parameters can be added automatically along with the datasets needed to drive the parameter list values. In our case, when writing the query manually, it’s necessary to do… Read more

0 comments, 500 reads

Posted in SQL Server BI Blog on 4 May 2011

Gartner BI Magic Quadrant 2011

It’s often true that “a picture is worth a thousands words” but sometimes a picture can be such an effectively communication medium that no more words are necessary.  Such is the case with this year’s Gartner Magic Quadrant rating of leading Business Intelligence vendors.  Gartner is the undisputed authority on… Read more

0 comments, 602 reads

Posted in SQL Server BI Blog on 23 April 2011

Designing Reports with Custom MDX Queries – part 1

This article is the first in a three-part series

On the Microsoft Developer Network (MSDN) forum for Reporting Services and other online discussion resources, I see many report developers asking how to building analytical reports using relational data sources. Some of the most fundamental capabilities often require complex and convoluted…

Read more

0 comments, 651 reads

Posted in SQL Server BI Blog on 27 March 2011

Take-aways from the 2011 Microsoft MVP Summit

Every year, Microsoft brings a couple thousand specialists from every corner of the globe together for a few days to Bellevue and the Microsoft campus in Redmond, Washington.  The Microsoft MVP community represents every discipline and Microsoft product. 

The MVPs are the external advisory committees for each Microsoft product group. … Read more

0 comments, 185 reads

Posted in SQL Server BI Blog on 7 March 2011

Can I Add Controls to a Reporting Services Report?

I see this question on the forums all the time and thought it was worth a repost here.  Just this week, at least two people on the MSDN forum for Reporting Services have asked how to add radio buttons or check boxes to a report. 

Can this be done?
No,… Read more

1 comments, 531 reads

Posted in SQL Server BI Blog on 14 February 2011

StreamInsight: A new way to think about analyzing data

Last night’s Oregon SQL user group meeting was very enlightening.  Mark Simms form the SQLCAT team came down from Redmond to talk about StreamInsight, a substantial new feature in SQL Server 2008 R2 that allows data to be analyzed and aggregated in-memory as it flows through the server.  I’ve read… Read more

1 comments, 597 reads

Posted in SQL Server BI Blog on 11 February 2011

Why Do All Funnel Charts Look The Same?

Something recently occurred to me.  I’ve been researching chart and dashboard design standards for an article I’m working on, and the eventual inclusion in an upcoming book.  Funnel charts are commonly used in the sales and customer relationship management (CRM) industry to visualize the volume of leads at various stages… Read more

0 comments, 250 reads

Posted in SQL Server BI Blog on 12 January 2011

What’s Going On at Microsoft?

Last week Donald Farmer announced that he was leaving his long-time position as Microsoft’s lead BI technology evangelist for QlikTech, a small company from Sweden, now based in Pennsylvania; that pioneered in-memory OLAP and analytics.  Microsoft has invested heavily in their own version of in-memory OLAP with PowerPivot and the… Read more

0 comments, 278 reads

Posted in SQL Server BI Blog on 11 January 2011

Rich Embedded Text Formatting in Reports

I’ve recently come to realize what a truly remarkable feature it is to be able to format report text using simple HTML tags.  This capability was added to Reporting Services in SQL Server 2008.  Prior to this, all of the text in a textbox could be formatted with a font… Read more

0 comments, 270 reads

Posted in SQL Server BI Blog on 11 January 2011

Building Reports and Analytics on Dynamics CRM – Lessons (Being) Learned

In concept, designing reports is such a simple thing… you connect to a data source, write a SQL query, optimize the query so it runs fast and efficiently, build the report UI and deploy it to the server.  Piece of cake, right?  Not always.  Reporting on simple, normalized data structures… Read more

0 comments, 399 reads

Posted in SQL Server BI Blog on 5 January 2011

Blogging on Blogging

So I must confess that my blogging efforts to date have been on the impersonal side – perhaps even a bit sterile.  I really admire bloggers who post daily and weekly, and seem to have interesting things to say about common and simple things.  In the coming year, I’d like… Read more

0 comments, 497 reads

Posted in SQL Server BI Blog on 31 December 2010

Newer posts

Older posts