Migrating from Native to Integrated Mode SSRS Part 2: Essentials for Your Toolbox

Once you’ve made the decision to migrate from native mode to integrated mode, you need ways to assess what you’re up against. You need to know the current state of your native mode instance, and what that means for your migration, mainly:

Continue reading

Migrating from Native to Integrated Mode SSRS Part 1: Setting the Stage

***Update October 2014: Microsoft has put greater emphasis on Power BI and SharePoint online in the past year, and the future of on-premises SharePoint SSRS is uncertain. Microsoft may instead find a way to connect Power BI to native mode SSRS. At this time,  I’d caution teams with an eye to future Microsoft BI against undertaking a migration from native mode  to on-premises SharePoint online. This is just my opinion, not the opinion of Microsoft or my employer, but a project of this magnitude must be very carefully planned and risks weighed against the benefits.***


As someone who has worked with SQL Server Reporting Services for a number of years, the bulk of my experience is with “native mode” installations. Reports are accessed via Report Manager or custom developed .NET UI’s, and SSRS is a free-standing entity administered by someone in a DBA and/or BI role. However, if you wish to get access to the newest and best BI goodies from Microsoft, SSRS running in SharePoint Integrated mode is the direction you must go. The goal of this blog series is to share the lessons and techniques I’ve learned over the past months of migrating reports from a native mode to an integrated mode environment.

Continue reading

Crash Reboot: Getting Back on the Bike

In honor of my one year anniversary at Trek, it’s only fitting that I blog about bikes, specifically my experience getting myself back on the bike and learning to enjoy cycling again after a nasty crash this winter. I know that I get encouragement from others who share how they were afraid and managed to move ahead anyway, so I hope someone stumbles across this post via Google someday and gets a boost back onto their own bike.

Continue reading

How I Learned to Stop Worrying and Like Social Media

Within the past year, my involvement with social media sites has grown exponentially. Carrying a smartphone has certainly helped feed these new habits, as have my duties on behalf of MADPASS, but what surprises me the most is how useful some of these sites have become in my life.

Before I natter on about how I’m using social media, please take My Very Short Social Media Survey. I need some data, and it’s just three easy questions. Think of it as helping a thirty-something geek with her homework,  with no calculus required.

Continue reading

SQL Saturday #206: Don’t Just Attend…Volunteer!


Have you heard about SQL Saturday #206 yet? No? Well then, you need to read Jes Borland’s post first.

Welcome back! I hope you’re interested enough to register, because we had a waiting list last year and I hope we have that same “problem” this year. I’d hate for you to miss out.

Continue reading

URL Access to SSRS Integrated Mode Reports

We’ve got an active project at work to migrate our many (many!) SSRS reports from a 2012 native mode instance to a 2012 instance integrated into SharePoint 2010. There are a number of benefits to migrating to SharePoint, which I’ll cover in a future post, but there are also functions we need to replicate from native mode. Several of our reports get displayed on LCD screens around a development team’s area so they can track sprint burndown rates and progress towards software upgrade goals. These reports are displayed via SSRS URL Access, which allows us to render the report in its own window and with certain parameter and display configurations. David Peterson and I found that the configuration between native and integrated mode wasn’t necessarily a 1:1 swap, but our suffering is your gain, as you now get to cheat off our homework.

Continue reading

Samsung Galaxy S3 – Initial Review

Like so many both in the technology industry (and at this point on our planet), I am addicted to my smartphone. I am seized with momentary panic if I think I’ve forgotten it, which is only assuaged when I unearth it from my purse. It goes with me everywhere, and probably gets more attention than it should. On the other hand, how else does a human react to something that provides entertainment, information, a camera, and which responds best to gentle taps and strokes?

Continue reading