Monthly Archives: August 2012

SQL Server Reporting Services (SSRS) Resources

Microsoft SQL Server Reporting Services (SSRS) has been around for over 8 years.  It was introduced in 2004 as an add-on for SQL Server 2000 because it was feature complete, but the SQL Server team was having issues launching the rest of “Yukon”.  Incidentally, Yukon was the codename for what would become SQL Server 2005.  As soon as the webcast for the initial release of SSRS finished, I started downloading the bits and planning our development environment for its inclusion.

I must admit, I personally didn’t do much at all with SSRS until well after 2005 was available.  I was first tasked to create a scaled out environment with two native mode SSRS portals.  Shortly after I was tasked with taking some user requirements, some design elements and building a bunch of reports.  This was actually a lot of fun.  They wanted me to do some investigation of Best Practices and document the ones we used for the reports.  It was an opportunity that you rarely get – to actually plan before delivering reports!  I was working with someone who’d spend quite a bit of time with SSRS, Chris McGuigan (a.k.a. mister.magoo on SSC).  Unfortunately, Chris was being pulled away from his passion of SSRS, and into Middle Management.  So Scott got to play in the sand box.  I also have the pleasure of working with Report Builder 1.0 report models and building a few solutions that were really eye popping for the users. But, I digress…

Back to my purpose…

I am starting to do some more work with SSRS in 2008 R2 and 2012, and I want to revisit some of the sites that I’ve perused in the past, and I am welcoming new suggestions too.  So anything focused on Lessons Learned, Best Practices, Design Ideas… Screencast are great, but equally good are articles and blogs.  I’d like to construct a drop zone for others to leverage what we’ve found.

So…

CALL TO ACTION:  If you have some favourite SSRS Resources, please add a comment below and help an old guy out, and the rest of the community too!

Cheers,

Scott

Here is one of my all time favourites!

  1. SSW Logo SSW Rules to Better SQL Reporting Services
  2. Koen Verbeeck (@Ko_Ver) recommends his colleague Valentino Vranken’s (@ValentinoV42) blog articles on SSRS
  3. MSDN: Report Design Tips (Report Builder and SSRS)

 

The Right Time and Place (and Technology?)

I am sitting in the waiting room at the doctors office with iPhone in hand… And I am blogging. Not the best tool for the job, but it works in a pinch. The WordPress iPhone app is actually just the right balance of utility and frugality – the power that you don’t need doesn’t get in your way, but you are delighted to find it when the need surfaces. Now that I’m an old man (40) it’s time to get poked and prodded. Time to keep up on the maintenance.

So much to do, so little time.

Summer is here and there is so much happening in my area of technical speciality.

Microsoft SQL Server

SQL Server 2012 was recently released. This is a significant release for SQL Server in many respects.  In the BI front out ETL tool finally had Undo.  I know… crazy that this is something that one gets excited about, and only after 7 years.  In the space of Reporting we have improved spatial capabilities and improved rendering with SharePoint Integrated Mode.  Additionally, there is Power View which is and highly interactive visual exploration tool, which when release only supported when hosted in a SharePoint Environment with the Enterprise Licensing price tag.  Analysis Services Supports a database engine and storage type referred to as a Analysis Services Tabular  (tradition OLAP engine was rebranded as Analysis Services Multidimensional).  Tabular uses the underlying technology introduced as an Add in to Excel called PowerPivot, introduced with SQL Server 2008 R2.  This technology was called the VertiPaq Engine, but with the launch of SQL Server 2012 it too was re-branded as xVelocity.  I could go on and delve into gruesome detail of the new features, but suffice to  say, there are an inordinate number or new and enhanced features in the product for everyone.

Microsoft Office 2013 Pre Release – In particular Excel

Excel for me is the product that provides the most alluring capabilities as a database professional.  More and more Business Intelligence features are being injected into the product.  Features that allow the business user to explore data in much more engaging ways than ever before.  The ability to create Power View visualizations (see above; this feature was only ever offered with SharePoint – No longer it seems) and additionally, add mapping integration with Bing Maps.  Other interesting additions are the new data import methods offered such as XML.

SharePoint 2013

I really don’t know all of the features, but really haven’t had time to delve in… dare I opt to distort the space time continuum?   Perhaps, not…

Windows 8 & Windows Server 2012

There is a plethora of feature in the new OS to be delivered in the Fall.  Touch is of personal interest – play with an iPad for any length of time and you will find yourself touching your laptop screen expecting it to respond to your gestures.  The new user interface referred to as the Metro UI encompasses design principle that make the user experience much more intuitive to touch, or so the design folks at Microsoft hope.

From a database professional who likes to isolate pre-release products in there own little virtual world, HyperV integration into the desktop version of the product (Windows 8) was a very welcomed addition.  No longer will I install a server operating system on my laptop to host a virtual environment – thanks for listening Microsoft!

With all these new product features and enhancements, when do I have time to cover it all?  Well maybe I should chill and enjoy some of the Summer and attend the PASS Summit in November and be chaperoned through minutia of product capabilities.

Where are you going to be November 6-9th?  Why not join me for the largest gathering of the SQL Server Community?  The PASS Summit 2012 (http://www.sqlpass.org/summit/2012/) – Ah, yet another topic for a blog entry, and alas, So much to do, so little time.