Cincinnati SQL Server User Group May Meeting Community Launch
The CincySQL user group will host a community launch event on May 27th from 6-9 PM.
SQL 2008 Launch
The SQL Server 2008 launch will consist of three presentations. Mr. Chris Barth and Mr. Drew Marston will highlight the new functionality for database administrators, t-sql developers and business intelligence professionals.
VS 2008 Launch
The Visual Studio 2008 launch will consist of two presentations separated by an intermission for networking. Mr. Philip Japikse will present "WPF - Not your Mother's WinForms" and Mr. Chuck Mobley will present "Web Programming Model in WCF"
Meeting Date: November 2007 Topic: Introduction to Report Generation and Distribution Utilizing SSRS 2005SQL Server Reporting Services (SSRS) is a server-based report generation environment developed by Microsoft that is part of SQL Server 2005. It can be used to deliver a variety of interactive and printed reports.
Reporting Services features a web services interface to support the development of custom reporting applications and reports can be designed using Visual Studio 2005 or BI Developer Studio. Come to our next session to hear and see the What, Why, and How of SSRS.Presenter: Drew MarstonMr. Marston a Senior Consultant with Pinnacle Solutions Group possessing 12 years of information systems experience focusing in project leadership, custom software design, development, and implementation in various Windows environments. His specialties include project management, application and database development using the latest visual programming tools for n-tier solution development deployed on both traditional client/server and internet interfaces. Some of his most recent experience involves serving as the lead database architect on several projects utilizing SQL Server 2000/2005 database and reporting services solutions. These projects involved extensive database design and development. Mr. Marston's management, design and development experience demonstrates a track record of high quality software delivered through goal-oriented schedules. __________________________________________________________________________________October 2007 Topic: Visual Studio for the Database ProfessionalVSTS for the Database Professional (codenamed Data Dude) enables database professionals (developers and DBAs) with more control over their Microsoft SQL Server databases throughout the entire application life cycle in unprecedented ways. This includes change management, communication, and process integration with other project team members such as developers, testers, and project managers. Offering a wealth of innovative tools, VSTS for the DB Pro offers features such as schema compare, support for refactoring, data generation capabilities and much morePresenter: Chris Barth Chris Barth is a Principal Consultant with Pinnacle Solutions Group with deep expertise in Microsoft SQL Server. Pinnacle Solutions Group is an IT consulting services firm specializing in Business Intelligence, E-Business Solutions, and custom solutions, providing IT services for companies in the Cincinnati, Northern Kentucky, and Dayton regions. It is distinguished by seasoned and exceptional technical professionals with the business acumen to align our customer's business needs to superior technical solutions, as well as provide the honesty, integrity, and service necessary for a long-term client partnership.__________________________________________________________________________________
September 2007Topic: SQL 2005 XML Presenter: A Jason Follas presentation. XML-based data is very prevalent in today's data world to the point that every database developer should know how to work with XML. Middle-tier translation of XML into relational data may be inflexible, and often leads to a loss of fidelity over time. One solution is to move the XML handling into the database itself in order to improve overall integration. SQL Server 2005 provides powerful XML processing features that allow easy access to data stored within XML without sacrificing any of the original fidelity. __________________________________________________________________________________ Cincinnati Business Intelligence User Group Meeting Date: March 2008Topic: PerformancePoint Server 2008Presenter: Craig Utley is a Mentor and senior architect with Solid Quality Learning, where he focuses on business intelligence (BI), .NET application development, and developer productivity issues. Craig has been working with Microsoft database technologies since 1993 and with Microsoft development tools since 1991. He is the former president of a custom software development company and has been an independent consultant since 1997, except for a year at Microsoft as a Program Manager on the SQL Server Customer Advisory Team, where he worked with some of the world’s largest Microsoft Business Intelligence customers. He is a published author of books, articles, and white papers, and is a speaker at conferences and to various user groups. His latest book, Business Intelligence with Microsoft® Office PerformancePoint Server 2007, was released in February 2008. Meeting Date: January 8th, 2008Topic: Introduction to Dimensional Modeling TechniquesDimensional modeling has become the industry standard database design for reporting and analysis. Database, reporting and data integration tool vendors all have native support for dimensionally modeled databases. However, it is important to understand the differences between normalized and dimensional data models and to grasp the basics of dimensional modeling before embarking on data mart or data warehouse project. Several industry leaders have developed dimensional modeling techniques that are widely used in data mart design today. This presentation will provide an overview of the various dimensional modeling techniques available today while detailing the framework and guidelines to use the most common dimensional modeling method for data mart designPresenter: Jeff Cook is a principal consultant with Pinnacle Solutions Group in Cincinnati, Ohio. Jeff has over 20 years experience in IT including over 10 years experience consulting in the Cincinnati area specifically on data warehousing and business intelligence solutions. Jeff has concentrated on innovative data mart solutions in the financial services and health care equipment vertical markets primarily for his client’s sales and marketing organizations. Jeff has over 10 years experience utilizing star schema designed data marts including data modeling, physical implementation, ETL design and development and performance tuning exclusively in the Oracle database. In 2007, Jeff achieved the Certified Business Intelligence Professional (CBIP) certification from The Data Warehousing Institute, specializing in data analysis and design, awarded at the mastery level. Jeff has supported this background with extensive conferences, research, courses and teaching ‘C’ programming at a local community college.
Sponsors: Dundas, O'Reilly, Wrox