Victoria SQL Server User Group

Welcome to Victoria SQL Server User Group. Membership and attendance of any sessions are absolutely free. If you are not a registered user, please click on Register link on right top link on this page. This will guide you to create your own account associated with Victoria SQL Server User Group. If you are already a registered SQL PASS user, please logon to http://www.sqlpass.org website and associate your account with this group. In this way, you will be able to receive our monthly meeting notice and announcement. Please RSVP for every meetings so we can get enough pizza for everyone.

If you could not come in person, please join us at http://www.anymeeting.com/VicPASSGroup1, we may have virtual meeting running at the same time.

Introduction to SQL Server Reporting Services (SSRS)

Microsoft has provided us with an easy to use and feature rich reporting service since SQL 2000. Now with the newest 2012 version, we have almost all the features available that we ever could ask for! And amazingly, we can even have it all for FREE in the Express edition, if we want! In the first 50 min of this introduction we will be looking at how to install and configure SSRS 2012, how to build a simple report with it using the included Visual Studio, and finally, how to set automated periodic generations of the report using the client front end. In the second 50 min of the evening, we will be looking at more complex report types, how to add colourful and meaningful charts to your reports, and if time allows, we will look at extended formatting tricks and tips on the data columns and rows.

PLEASE NOTE: This session can be enjoyed by non-DBA’s, as the report creation system was designed by Microsoft to be understood by non-IT users. So feel free to bring along your super-user co-worker from the finance, sales, engineering or marketing department, who might be interested in building useful reports off your ERP, CRM, or other system!

Speaker: Martin S. Stoller

Martin S. Stoller (MCDBA, MCITP SQL DBA & SQL DEV 2005 & 2008) is a DBA, Programmer and IT Architect that learned SQL two decades ago using MS-QUERY and MS-ACCESS 1.0, and first came in contact with MS-SQL Server in its seminal version of 4.2. Currently working for Canada’s largest fuel distributor (Parkland Fuel Corporation) as their sole Microsoft Database Administrator, Martin specializes in legacy system upgrades and unorthodoxly complex ETL. http://www.linkedin.com/in/martinsstoller

Time: May 15^th, 5:30PM, RSVP is required

Location:

Royal Jubilee Hospital - New Patient Care Centre

Located on the Southeast corner of Richmond and Bay Streets. In the main foyer, there is a large walkway marked to “Patent Rooms” that leads toward an elevator bank. There is a gift shop on the left of this walkway. Do NOT go towards the elevators; instead follow the smaller hallway to the left of the gift shop. The lecture theatre (Room S169) is located on the right at the “T” hallway intersection.