Search
Thursday, July 29, 2010..:: SQL Server » San Francisco SQL Server User Group::..Register  Login
 Chapters


  
 Links


  
 San Francisco SQL Server User Group Minimize

2010 Meeting Schedule
Date Subject Speaker
January 13 SQL Server Storage Configuration for SharePoint Burzin Patel (StoreSimple)
February 10 What's New in SQL Server 2008 R2? Phil Hummel (WinWire Technologies)
March 10 Get Down and Dirty with SQL Server Profiler Jo Lax (Idera)
April 14 Tuna Helper for SQL Server DBAs Dean Richards (Confio)
May 12 The SQL Server OVER Clause Brad Schulz
June 9 Seven Deadly Sins of Database Design Solomon Waters (Embarcadero Technologies)
July 14 Multi-Server Management with SQL Server 2008 R2 Ross Mistry (Microsoft)
August 11 No Meeting  
September 8 Advanced SQL Server Reporting Services Lisa Nicholls (EC Wise)
 

August: No Meeting   Enjoy your summer!

Next Meeting: San Francisco – Wednesday, September 8 - 6:30 pm

SQL Server Reporting Services in a Development Context

Presented by: Lisa Nicolls of ECWise  

SQL Server Reporting Services does a lot to streamline and de-mystify the process of getting great BI results from your data. However, at least for now, it doesn't do a lot to integrate reporting with standard practices, whether you're a SQL or a .NET developer.

In this session, we'll look at some tools and practical methods for developing reports consistent with your usual working habits, and exposing them consistent with your users' expectations.

We will:

  • Compare and evaluate different syntax and methods that SSRS provides for sending and rendering output
  • See various tips and tricks for improving RDL results to resolve some common user requests
  • Look at using the RDL's containership model effectively, and discuss why some things seem to be harder than they ought to be
  • Evaluate different places to put the query code and different levels on which query parameters can be placed
  • Investigate using RDL data output (XML format) as an interim output format and a testing device
  • Notice what difference RS 2008, and R2 in particular, have made to some of our practices.
     

Demo:  You'll see examples of existing reports and RS exposure methods, as well as some development tools designed to make your RS life easier. No commercial products will be demonstrated.  .

Lisa Nicholls is a Microsoft Technologies Practice Manager and Solutions Architect for EC Wise, a BI-focused consulting company in San Rafael. Previously, with Colin Nicholls, she provided enterprise data integration and analysis services using XML in a variety of environments and languages (dba Spacefold). She has worked as a contractor to the MS Visual Studio Data team in many capacities, ranging from Program Management to Dev to Test to User Ed, and has a special interest in reporting tools of all kinds. She blogs on SSRS-related topics at Spacefold

Location Microsoft Office at 835 Market Street, Suite 700, San Francisco, CA 94103.   Click here for a map 

To RSVP or for more information, email Mark Ginnebaugh at mark@designmind.com

Cost  No charge 

6:30 to 7:00 pm - Introductions, food, networking

7:00 to 8:30 pm - Presentation and Q&A

The San Francisco SQL Server User Group focuses on database development and administration practices specifically centered around Microsoft SQL Server. Presentations include developer centric interactive sessions as well as demonstrations of related products that have been judged to have potential value or be of interest to the professional database community. We also offer a face to face forum for peer learning and networking.

Mark Ginnebaugh, User Group Leader, is the President of DesignMind, a Bay Area developer of Websites and Database Applications. Send User Group-related questions and suggestions to mark@designmind.com

 

 

 

 

 

 

 

 

 

  

 

 

 

 

 

 

 


 Print   
 Past Meetings Minimize

Additional Upcoming Meetings

 

 

Syndicate   Print   
 Documents Minimize

 TitleOwnerCategoryModified DateSize 
Ross Mistry Hardening SQL ServerJohn Hanson 10/13/2008760.85 KBDownload
Ross MistryAdministrator AccountRoss Mistry5/9/20075.41 MBDownload
Kevin Kline - End to End Performance TuningMark Ginnebaugh 11/13/20084.14 MBDownload
SQL Server High Availability - Paul BertucciAdministrator Account 5/9/20071.22 MBDownload
SQL Server High AvailabilityJohn Hanson 6/18/20081.93 MBDownload
SQL Reporting Services vs. Crystal Reports Feature ComparisonAdministrator AccountComparative Analysis5/9/2007566.80 KBDownload
20080409 Denise McInerney - Transactions in SQL ServerMark GinnebaughSQL6/11/200870.05 KBDownload
20050309 Karl Kuhnhausen: Analysis ServicesMark Ginnebaugh 6/11/20083.88 MBDownload
20040218 Keen Browne: Reporting ServicesMark GinnebaughPresentation slides6/11/2008498.50 KBDownload
Data Security Within the EnterpriseAdministrator Account 5/9/2007517.00 KBDownload
20081008 - Joe Belson's SQL Server 2005 and Disk IOMark Ginnebaugh 10/13/2008328.33 KBDownload
20080514 - Rene Woody's "Finding the Best Performing SQL"Mark GinnebaughSQL10/13/2008427.50 KBDownload

Syndicate   Print   
 Sponsors Minimize


 Print   
Copyright 2006-2009 by BAADD   Terms Of Use  Privacy Statement