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

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,319 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,010 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, 539 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, 501 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, 666 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, 503 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.

http://www.thegatesnotes.com/Topics/Development/Hans-Rosling-Good-News-in-Tanzania?WT.mc_id=11_2_Rosling_TW&WT.tsrc=Twitter

Follow me on Twitter: @paul_turley


Filed under: BI Industry, SolidQ

Read more

0 comments, 430 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,194 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, 482 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, 296 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,554 reads

Posted in SQL Server BI Blog on 11 October 2011

Follow PASS Keynotes Live Feeds via Blog & Twitter

Not going to be there? No Worries

The PASS Global Summit starts next Wednesday, October 12th in Seattle.  PASS is the Professional Association for SQL Server, an organization that supports a community of tens of thousands of SQL Server professionals around the world.  Over 4,000 members will gather next… Read more

0 comments, 309 reads

Posted in SQL Server BI Blog on 7 October 2011

Follow PASS Keynote Live Feeds via Blog & Twitter

Not going to be there? No Worries

The PASS Global Summit starts next Wednesday, October 12th in Seattle.  PASS is the Professional Association for SQL Server, an organization that supports a community of tens of thousands of SQL Server professionals around the world.  Over 4,000 members will gather next… Read more

0 comments, 295 reads

Posted in SQL Server BI Blog on 7 October 2011

SQL Server MVP for another year

I’m naturally paranoid.  I suppose it keeps me honest.  When I went to work for SolidQ earlier this year – and joined the largest assembly of Microsoft SQL Server MVPs and some of the smartest, most capable people I’ve ever met – I knew that keeping my Microsoft MVP status… Read more

0 comments, 277 reads

Posted in SQL Server BI Blog on 4 October 2011

SQL Server MVP Deep Dives 2 Released

Exciting news…  The second edition of the SQL Server MVP Deep Dives book has been completed and is going to press in time for the PASS Global Summit!  The book will be on sale at the conference book store and is available to pre-order on Amazon*  It can be… Read more

0 comments, 496 reads

Posted in SQL Server BI Blog on 26 September 2011

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, 489 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, 245 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, 305 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, 804 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, 515 reads

Posted in SQL Server BI Blog on 3 June 2011

Newer posts

Older posts