SQL Server BI Blog

Mastering Reporting Services Expressions, March 26

As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using Expressions to enhance report capabilities. The sessions are online with live chat from 11:00 to 4:30 Eastern Time. Register today to get in on the early-bird discount. the cost for…

6 comments, 250 reads

Posted in SQL Server BI Blog on 15 March 2013

Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes

We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past, if you wanted to develop and maintain BI projects in the same development environment as other Visual Studio projects, you had to install multiple versions of Visual Studio. This may…

1 comments, 243 reads

Posted in SQL Server BI Blog on 8 March 2013

SQL Server Community World Tour with GeoFlow

When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This is a short world tour with visits to a few SQL Server community members and leaders around the globe talking about their SQL Server communities. GeoFlow is a new BI…

17 comments, 220 reads

Posted in SQL Server BI Blog on 6 March 2013

Speaking at the Business Analytics Conference, April 1-12 in Chicago

The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please do not share your schedule until that time.” Well, what does that mean, exactly? It means that it’s midnight right now and time to tell the world…. We are going…

2 comments, 208 reads

Posted in SQL Server BI Blog on 6 February 2013

Database Lifecycle Management for Azure SQL Database

DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created a few databases and then quickly left it behind but in the last few months I’ve found some really good uses for “Microsoft Windows Azure SQL Database”. I just wish…

1 comments, 369 reads

Posted in SQL Server BI Blog on 1 February 2013

Reporting Services 2012 BI Training

Just wanted to get the word out that our SSRS 2012 training course is available. Are you looking for expert training on SQL Server 2012 Reporting Services? SolidQ now offers a SSRS training course with focus on designing report solutions for Business Intelligence and SharePoint integration. Not using SharePoint? Private…

4 comments, 597 reads

Posted in SQL Server BI Blog on 10 December 2012

Is Self-service BI Threatening IT Professionals’ Livelihoods?

(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is little doubt that the movement toward self-service BI is going to change the climate for some IT professional who specialize in BI – but the question is “how?” and “how…

0 comments, 440 reads

Posted in SQL Server BI Blog on 9 December 2012

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…

2 comments, 905 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…

0 comments, 334 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…

2 comments, 2,608 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…

1 comments, 358 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…

4 comments, 1,991 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…

0 comments, 360 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…

0 comments, 609 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…

4 comments, 506 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, 394 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, 2,234 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, 658 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

0 comments, 392 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, 345 reads

Posted in SQL Server BI Blog on 26 February 2012

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog

Mastering Reporting Services Expressions, March 26

Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes

SQL Server Community World Tour with GeoFlow

Speaking at the Business Analytics Conference, April 1-12 in Chicago

Database Lifecycle Management for Azure SQL Database

Reporting Services 2012 BI Training

Is Self-service BI Threatening IT Professionals’ Livelihoods?

Debugging Parameter Dependencies in Reporting Services

Power View and Reporting Services

Is PowerPivot the Next Access?

Office 2013 BI and Mobility

The State of Microsoft Self-Service Reporting

2012 Fall & Winter Conference Sessions

SQL Server BI & SharePoint eBooks, Guides and Resources

PASS 2012 Summit: November 6-9

On my way to DevTeach in Vancouver

SSRS Performance in SharePoint Integrated Mode

SQL Server 2012 Upgrade Technical Guide is available

SSRS or a Custom Web Form – Pros & Cons

SQL Saturday 108 in Redmond was a great success