Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4445 W Lake Forest Drive, Suite# 100, Blue Ash, OH 45242. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 5:30 - Networking and Food
  • 6:00 - PASS news and Announcements
  • 6:15 - Featured Presentation
  • 7:15 - Q&A Session / Door Prizes


Next Meeting: Tue, Jul 15 2014

CincyPASS July Monthly Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None


UTC : Tue, Jul 15 2014 22:30 - 00:00
Event Time : Tue, Jul 15 2014 18:30 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Jul 15 2014 22:30 - 00:00


4445 W Lake Forest Drive
Blue Ash, Ohio

Direction: None

Featured Presentation

Custom Shared Schedules in SQL Server Reporting Services

Speaker: Vincent Staropoli, Principle Consultant Cardinal Solutions

Summary: SQL Server Reporting Services provides an extensive platform for building and delivering reports. Also included is functionality to create subscriptions for reports that can be delivered based on predefined schedules. In the Finance world, for example, there is typically a high volume of work that occurs just before and just after closing out a fiscal month. Automated report generation helps preserve critical snapshots of the data used in that work. Out of the box in SSRS, the shared scheduling options are fairly straightforward. Configuration allows for selecting days or dates, time and execution frequency along with a some other necessary details. But what if the requirements for the schedule are more specific to the business? Fiscal calendars can vary between organizations, so how do we solve the problem with minimal IT interaction and maintenance? This presentation will explore a method to extend the fairly rigid Shared Schedule feature into something more dynamic and flexible.

About Vincent: Vincent Staropoli is a Solution Sales Specialist and Principal Consultant for Cardinal Solutions. As an MCSE in Business Intelligence, he looks to enable businesses to make better decisions.






Back to Top