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

Debugging Parameter Dependencies in Reporting Services

Creating a report with two datasets that reference the same pair of parameters, I’m seeing the following error: The Value expression for the query parameter ‘DatesYear’ contains an error: The expression references the parameter ‘DatesYear’, which does not exist in the Parameters collection. Letters in the names of parameters must…

Read more

2 comments, 2,155 reads

Posted in SQL Server BI Blog on 7 December 2012

Power View and Reporting Services

There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting tools.  This is becoming a very popular topic and I thought I’d post my reply to that thread here.  I encourage you to  read the entire post on…

Read more

0 comments, 556 reads

Posted in SQL Server BI Blog on 3 December 2012

Is PowerPivot the Next Access?

I’m impressed with the current generation of semantic modeling technology from Microsoft.  I’ve had the opportunity to use both PowerPivot and SSAS Tabular Models on a handful of client projects and have had very good results so far.  The xVelocity in-memory aggregation and data compression engine seems to be everything…

Read more

2 comments, 3,351 reads

Posted in SQL Server BI Blog on 28 October 2012

Office 2013 BI and Mobility

I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about Power View and PowerPivot.  I’ve posted the presentation online and it’s ready for viewing here: Power View and PowerPivot – High-octane Self-service Reporting. (this presentation is the shell slide for…

Read more

1 comments, 565 reads

Posted in SQL Server BI Blog on 15 October 2012

The State of Microsoft Self-Service Reporting

(article published on the MVP Award Program Blog) I really enjoy this topic.  One of the reasons, I suppose, it’s such a hot topic is that a lot of people believe that there is a perfect ad hoc reporting solution out there, just barely beyond the current set of capabilities…

Read more

4 comments, 2,299 reads

Posted in SQL Server BI Blog on 25 September 2012

2012 Fall & Winter Conference Sessions

Fall is a busy time for speaking engagements which include user groups, SQL Saturdays and the PASS Global Summit. I'm speaking at a number of events and as the schedules are confirmed, I'll update this list and upload or provide links to presentations and demo content. I hope you can…

Read more

0 comments, 518 reads

Posted in SQL Server BI Blog on 22 September 2012

SQL Server BI & SharePoint eBooks, Guides and Resources

There are many free eBooks & resources available from Microsoft and members of the MVP community.  This is a collection of several very useful free publications: Power View Infrastructure Configuration and Installation Link Introducing Microsoft SQL Server 2012 PDF | EPUB | MOBI Introducing Microsoft SQL Server 2008 R2 PDF…

Read more

0 comments, 912 reads

Posted in SQL Server BI Blog on 10 August 2012

PASS 2012 Summit: November 6-9

I just received an email message from the PASS Global Summit 2012 organizers after submitting session abstracts a few weeks ago.  They told me not to make any public announcements about the information they sent me but they also gave me this cool button graphic.  Hmmm… I wonder what this…

Read more

4 comments, 756 reads

Posted in SQL Server BI Blog on 10 June 2012

On my way to DevTeach in Vancouver

Just stepping out the door on on my way to the DevTeach / SQL Teach conference in Vancouver, BC, Canada.  The conference begins tomorrow at the conference center and the Hilton Vancouver Metrotown in Burnaby.  I’m looking forward to meeting up with other MVPs and associates from SolidQ.

I’ll… Read more

1 comments, 535 reads

Posted in SQL Server BI Blog on 28 May 2012

SSRS Performance in SharePoint Integrated Mode

I’m working with a client to help them move all reports in their company from native mode (Reporting Services not integrated with SharePoint) to SharePoint integrated mode.  At the same time, we will help them migrate hundreds of report in SSRS 2005 and 2008 R2 to SSRS in SQL Server… Read more

4 comments, 3,508 reads

Posted in SQL Server BI Blog on 24 May 2012

SQL Server 2012 Upgrade Technical Guide is available

The SQL Server 2012 upgrade white paper is now available from Microsoft.  I’m proud to have made a contribution and to work with these industry leaders.  This extensive 454 page guide was published and edited by Microsoft and written by mentors from SolidQ.  It is a valuable reference for administrators,… Read more

1 comments, 1,075 reads

Posted in SQL Server BI Blog on 18 May 2012

SSRS or a Custom Web Form – Pros & Cons

In response to a post I made on an unrelated topic, a reader said "I’m not really a fan of SSRS, preferring to use an ASP.NET and HTML interface…"

I’d like to move that discussion to the this thread and keep it on topic.  This is an interesting subject and… Read more

2 comments, 556 reads

Posted in SQL Server BI Blog on 3 March 2012

SQL Saturday 108 in Redmond was a great success

Thanks to the organizers and volunteers for making SQL Saturday #108 an overwhelming success.  I’m just wrapping up the day following the Redmond SQL Saturday held in the Commons on the Redmond Microsoft campus.  Greg Larsen and all of the organizers did a fantastic job to make this a successful… Read more

1 comments, 522 reads

Posted in SQL Server BI Blog on 26 February 2012

Show Us Your Coolest SSRS Reports

I’ll show you mine if you show me yours.  Over the past nine years or so, I have showcased many examples of creative report designs on my blog and various community events.  Now I’d like to hear from you and see what others in the community have done.  To bring… Read more

6 comments, 687 reads

Posted in SQL Server BI Blog on 21 February 2012

SQL Server 2012 RC0 and beyond

Since the stable and mainly feature-complete versions of SQL Server 2012 have been available, I have been heads-down on multiple BI projects using this software.  SQL Server 2012 is not just the next, incremental build of the same database platforms with a few added features here and there.  No, SQL… Read more

5 comments, 524 reads

Posted in SQL Server BI Blog on 25 December 2011

Latest post from Bill Gates featuring Hans Rosling’s animated bubble graphs

I just caught a tweet from Bill Gates with yet another fascinating presentation from Hans Rosling on the Gates Notes site.  This is an excellent demonstration of how Business Intelligence can be used to convey an important message.

Follow me on Twitter: @paul_turley

Filed under: BI Industry, SolidQ

Read more

0 comments, 451 reads

Posted in SQL Server BI Blog on 2 November 2011

Creating a Table Report with Dynamic Columns

Over time, similar reports may be designed from variations of common queries and datasets.  Creating one report to meet all these requirements can minimize development time and maintenance overhead.  By evaluating existing reports and making modifications, future requirements can be met without creating yet another report.  Parameters and expressions may… Read more

2 comments, 1,299 reads

Posted in SQL Server BI Blog on 30 October 2011

SolidQ Announces BI Center of Excellence

Carl Rabeler, SharePoint and SQL BI Expert Formerly With Microsoft SQLCAT, Rejoins SolidQ as Director of the Business Intelligence Center of Excellence.

Under Carl Rabeler’s direction, SolidQ’s Business Intelligence Center of Excellence (BI CoE) will assist customers and partners around the world by providing architectural support, security review, mentoring, content… Read more

0 comments, 517 reads

Posted in SQL Server BI Blog on 20 October 2011

Best PASS Summit Ever (so far)

I have to admit that the 2011 PASS Summit was such an amazing experience and there was so much to say that I honestly didn’t know where to start.  It’s been three days since returning from this year’s PASS Global Summit in Seattle and I’m just now getting my thoughts… Read more

0 comments, 324 reads

Posted in SQL Server BI Blog on 20 October 2011

Using Custom Code Functions in Reporting Services Reports

Reporting Services is one of those tools that just keeps on giving.  I’ve been using SSRS since the early beta versions were available and the more opportunities I have to create advanced reports, the more creative ways I find to use this product to do interesting things.  One of its… Read more

1 comments, 1,694 reads

Posted in SQL Server BI Blog on 11 October 2011

Newer posts

Older posts