Author Archives: Scott

To the #SQLPASS #FirstTimers of #Summit 2012 – The Procrastination Edition

Okay, it is the “11th Hour” – It’s Friday, you have things to do before you leave for the day, and they you rush home to pack you bags for the SQL PASS Summit.  WHERE TO START?

It will be okay…

Keep calm and carry on

(incidentally, many interesting variations of the original when you look at Google images.)

There are resources out there to help you as you prepare for your first time at the Summit.

There is so much great content out there, and I’m not one  to re-create the wheel, but simply re-present it.  Even if you are have been to multiple PASS Summits in the past, I’m confident you’ll find a few gems in the links below.

If you are an Official First timer, or would like to be, it would be great to attend one of 5 “Professional Development and Networking Workshop Sessions” (for more details) offered on-site on Tuesday by Networking Professional, Don Gabor.  Click on the “Let Us Know” link located here to register.

I know there are numerous, don’t feel that you have to read them all, but speed through, make some notes, and come say, “Hi!” to me at the Summit.

Blog Posts for #FirstTimers to #SQLPASS #Summit2012

 Jen Stirrup’s

 Tara Clark’s

 Denny Cherry

 Jason Strate’s

 Pat Wright’s

 Kendra Little’s

 Julie Koesmarno’s

 Jes Schultz Borland’s

Davide Mauri

Oldies but goodies!  (The blogs… not the blogers…)

 Thomas LaRock’s

 Sarah Strate (Olander?)

Tim Radney’s

 Jen McCown’s

 Jason Strate’s

Official @SQLPASS Links

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.

 

“Done is Better Than Perfect”

I saw this quote in someone’s Facebook post the other day, and although I cringe at the reality of the statement, in general I must agree – Done is better than perfect.

With this current task of creating a new personal brand for myself, “done” is the goal of this first blog post.  Sure, I need to get my EasyDNS configuration to point scottstauffer.ca to this Windows Azure Web Site.  Sure, I have to figure out this whole new world of WordPress, and the underlying technologies of MySQL & PHP and how it operates on this slightly, non-traditional Windows Azure Web Site infrastructure.  And that’s only the technology aspects of this endeavour…  I also need to think about my message, my voice; I have to choose a colour scheme that reflect my feeling and personality…

Okay, while “Done” is close at hand, please don’t confuse this with “Good”.  Good as it loosely relates to the Voltarian quote “Le mieux est l’ennemi du bien.” or loosely translated to “The perfect is the enemy of the good.”  But perhaps, I’ve lost my perspective… My goal was to post my first blog on this new site, and perhaps this is just good enough.

I look forward to sharing a better branded experience shortly on http://ScottStauffer.ca/ but today, you were brought here to a generic WordPress site.  Expect some SQL Server BI video blogs here in the future, and perhaps some articles on alternative fuel technology and natural resource management on the personal scale.

And with that, my work here (for now) is done