Join us for our February meeting as fellow CSSUG member Melissa Coates presents: "Report Calcs - SSRS Source Query vs. Expressions."  

As a report developer, you want to ensure your reports are structured for accuracy, performance, maintenance, and reusability. One of your many decisions includes where to perform report-specific calculations when the source is a SQL Server relational database. In this session we will compare and contrast a sampling of functions available in T-SQL and SSRS, with an emphasis on handling aggregation, ranking, dates, and strings. A "cheat sheet" will be available online for future reference. Session Goal: Identify common situations when performing calculations within SSRS is preferred, versus when the T-SQL source query may be more appropriate. 

Speaker's Bio:

Melissa Coates is a Business Intelligence developer based in Charlotte, NC. As a consultant with Mariner, she specializes in delivering BI and Data Warehousing solutions. Formerly a CPA, Melissa is ridiculously proud to be an IT geek. Her background gives her a valuable blend of technical, business, and training skills. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie. Melissa blogs at http://www.sqlchick.com. 

Agenda:

5:30 PM Networking and Pizza

6:00 PM Stump the SQL Experts - NEW open Q&A Forum with CSSUG Members

6:15 PM Main Presentation

7:30 PM Meeting End

Location:

The meeting is being held in the MPR room at the Microsoft Offices. Click for directions. The entrance and the room is marked on the linked map above. Thanks to Bing maps! 

Sponsors:

TEKsystems® has been a loyal sponsor of the Charlotte SQL Server Users Group. TEKsystems® provides technology staffing and services, helping businesses deploy high-caliber IT and communications expertise. With roots as the nation’s largest IT staffing firm, they’ve become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Visit www.teksystems.com for more info.

SQL Sentry, Inc., is a Charlotte based company and a long time sponsor of the Charlotte SQL Server Users Group. SQL Sentry creates software products to optimize the performance of Microsoft® SQL Server® environments.  SQL Sentry software provides unprecedented visibility and control that enables database administrators to monitor their database environment with confidence, and quickly diagnose and solve complex performance problems as they arise. Visit www.sqlsentry.net  for more info.

About Our Group:

Charlotte, NC has a dynamic, growing business environment filled with opportunities for SQL Server professionals. The goal of the Charlotte SQL Server User Group is to encourage and support the growth of that environment by providing a venue for user education and peer collaboration. Our group is a certified Chapter of PASS and we recommend all members join that organization. Our web site is here: www.Charlotte-SQL.org and a preview of our new web site can be viewed here. CSSUG Preview