Richmond SQL Server Users Group

July 8th, 2010, 6:30 PM - 8:00 PM

fibrock — Thu, 24 Jun 2010 23:48:00 GMT

Jessica M. Moss presents MDX: From WITH To WHERE!

When: July 8th, 2010, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Jessica M. Moss

Jessica M. Moss, an architect with Ironworks Consulting and a Microsoft SQL
Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL
Server business intelligence. Jessica has created numerous data warehousing
solutions for companies in the retail, internet, health services, finance, and
energy industries and authored technical content for multiple magazines,
websites, and the book "Microsoft SQL Server 2008 Integration Services Problem-
Design-Solution". Jessica enjoys working with the central Virginia community
and speaks regularly at user groups, code camps, and conferences. You can read
about her work on her blog, http://www.jessicammoss.com.

What:
MDX: From WITH To WHERE

SQL Server Analysis Services provides a quick and easy queryable structure for your data warehouse. You can use Analysis Services's querying language, MDX (multi-dimensional BLOCKED EXPRESSION, to retrieve data for reports, ad-hoc analysis, and dashboards! This session will discuss the basic syntax, query-scoped calculated measures, and common functions that can be used in MDX queries.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

June 10th, 2010, 6:30 PM - 8:00 PM

fibrock — Thu, 17 Jun 2010 11:59:00 GMT

Bob Lambert presents Normalize Metadata for Data Integration Analysis!

When: June 10th, 2010, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Bob Lambert

Bob Lambert, a consultant with CapTech Ventures, specializes in data management, business intelligence strategy, and system architecture. His interests encompass how IT and business get together to build and maintain business value, especially with databases and data warehousing. Recent projects have focused on real estate, health care, and financial services. Bob has authored a number of articles, most recently publications at Dr Dobbs and Information Management.

What:
Normalize Metadata for Data Integration Analysis

Many of today’s business applications feature dozens of interfaces feeding a central database. Interface source-to-target mapping is now common practice, but if there are many interfaces how do you make sure the work of separate teams on tight timelines dovetails smoothly and avoids the all too common death march of correction and rework? This presentation shows how normalized metadata can help coordinate team efforts, recording data requirements, the target data model, interface sources, source to target mappings, and relationships among analysis components, and enable an effective division of labor that promotes team efficiency, improves planning, and provides the best possible product for developers and testers.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

March 11th, 2010, 6:30 PM - 8:00 PM

fibrock — Thu, 11 Mar 2010 23:02:00 GMT

This Months Sponsor:SQL Saturday

Mark Hudson presents An Introduction to Report Builder 2.0

When: March 11th, 2010, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
H. Mark Hudson

Mark Hudson has more than 10 years experience in business intelligence and data analysis. He has developed data warehouses and data presentation layers using numerous tools including both SQL Server 2005 and SQL Server 2008. He currently serves as an architect and developer with CapTech Ventures, Inc. (mhudson@captechventures.com, http://www.captechventures.com/).

An Introduction to Report Builder 2.0
What does the fountain of youth have in common with happy, self-served BI users? Microsoft’s Report Builder 2.0 answers that question and more. Report Builder 2.0 is a report authoring tool with enhanced data layout, visualization and formatting capabilities left out of the earlier (and not widely used) Report Builder 1.0. This session introduces the audience to the dependencies and capabilities of Report Builder 2.0 and offers ways BI users might finally build those reports they always wanted.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

December 10th, 2009, 6:30 PM - 8:00 PM

fibrock — Sun, 29 Nov 2009 01:52:00 GMT

When: December 10th, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Kevin Boles

Kevin is a SQL Server expert, working exclusively with the product since
version 6.5. He holds pretty much every SQL Server certification including
MVP. His primary focus is the relational engine and his passion is
performance analysis and tuning. He teaches occasionally, is a great mentor
and has been a successful independent consultant for the past dozen years.

SQL Server and SANs - Let's dig into both the fundamentals and some details
of how SANs work and how we can best utilize them to improve SQL Server's IO
performance and reliability. The more you know about SANs the more you are
able to stand up to those bullying and very protective SAN admins! :-)

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

When: November 12th, 2009, 6:30 PM - 8:00 PM

fibrock — Sat, 07 Nov 2009 13:18:00 GMT

When: November 12th, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Kevin Viers

Database Platform Technology Specialist with Microsoft

What: SQL 2008 R2- Come learn about the new and exciting roadmap for the SQL Server platform. SQL Server 2008 R2 is the next generation of the Microsoft SQL Server database platform, planned for release in the first half of calendar year 2010. The R2 release brings significant new capabilities and enhancements that can help your business keep pace with today’s growing and changing data management needs. Increase productivity and reduce data management costs by taking advantage of an even more scalable platform with comprehensive database and application management tools. SQL Server 2008 R2 helps users to build rich analysis and reports and helps organizations improve the quality of their data.

Learn a little more about:

·Powerpivot (formerly project codemane Gemini)·Master Data Services·Application and Multi-Server management·Parallel Data Warehouse (formerly project codename Madison)·New SKUs and Pricing

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

October 8, 2009, 6:30 PM - 8:00 PM

fibrock — Fri, 18 Sep 2009 13:21:00 GMT

When: October 8, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Tim Ford

What: Dynamic Management Objects - With the release of Microsoft SQL Server 2005, the curious DBA had a new arsenal of tools available for indentifying performance issues, automating maintenance tasks, and documenting their environments. These tools are called Dynamic Management Objects. Join Tim Ford as he takes you on a tour through some of his favorite Dynamic Management Objects and see why you just may have found you new favorite thing about Microsoft SQL Server.

About Tim Ford

Timothy Ford has been working with Microsoft SQL Server for almost 10 years, originally as a developer in SQL Server 7.0 and Visual Basic 6; now as a DBA for the last 8 years. He specializes in mining information from the system tables for automation of administrative tasks and troubleshooting performance matters. Tim has been a volunteer with the Professional Association for SQL Server (PASS) since 2002, serving as a founding leader of the DBA Special Interest Groups, on the Program Committee for 5 years, on the Editorial Committee, and as the co-creator and host of the annual SIG Quizbowl presented at each of the opening receptions of the PASS Summit for the past 5 years. He is an author and blogger, writing technical articles for MSSQLTips.com, Simple-Talk, SQL Server Central, and SQLServerpedia, where he also serves as the DBA Section Editor. Tim was one of the SQL Magazine Innovators of the Year for 2008 and is featured on the cover and in the associated story in the January 2008 issue.

When not engaged in the world of T/SQL you'll usually find him with a camera or spatula in his hands as he enjoys photography and cooking.

Links:
http://www.ford-it.com/sqlagentman
http://www.mssqltips.com/author.asp?authorid=13
http://sqlserverpedia.com/wiki/Editors#Timothy_Ford.2C_Database_Administration_Editor

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Thursday, August 13th 2009, 6:30 PM - 8:00 PM

fibrock — Mon, 27 Jul 2009 00:15:00 GMT

When: Thursday, August 13th 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Andy Leonard

What: SSIS Design Patterns

"Design Patterns" is more than a trendy buzz phrase; design patterns are a way of breaking down complex development projects into manageable tasks. They lend themselves to several development methodologies and apply to SSIS development. Chances are you're using your own design patterns now! In this presentation, Andy Leonard defines design patterns applicable to SSIS.

About Andy:

Andy is a SQL Server database and business intellgence developer. He owns a car. His favorite color is blue and he prefers cyberpets to the real thing. If this sort of humor appeals to you (along with talks about database development), join Andy at Richmond SQL Server Users Group!

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Thursday, July 2nd 2009, 6:30 PM - 8:00 PM

fibrock — Fri, 26 Jun 2009 11:59:00 GMT

When: Thursday, July 2nd 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Steve Jones

What: Self promotion in today's market

Abstract: Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more.

About Steve:

Bio: Steve Jones has been working with SQL Server for over 18 years in a variety of industries and companies. After serviing as a DBA for many years, Steve founded SQLServerCentral and currently serves as editor.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Thursday, May 14th, 2009, 6:30 PM - 8:00 PM

fibrock — Tue, 05 May 2009 14:50:00 GMT

When: Thursday, May 14th, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Steve Fibich

What: SSIS Scripting and SSRS WebServices

So we have all moved a little data from point A to point B in SSIS or DTS but what else can we do? What about web services? Have you ever pointed the control flow web services component at a WSDL only to be told “This version of the Web Service Description Language is not supported”? I’ll show you how you can handle it (or at least the web services related to Reporting Services) using script tasks in SSIS. This presentation focuses on getting web service into a data flow using a scripting task and calling web services from a control flow script task. This presentation is from the DBA perspective not an experienced .Net programmer’s perspective.

About Steve:

Steve Fibich currently works in Richmond VA at PFGC as the Systems Architect on a Master Data Management project utilizing SQL Server 2005 and SSIS 2005 pulling data from iSeries, Unix, VAX, and SAP for a massive system integration effort. He has been working with SQL Server since 6.5 building Data Warehouses, building integration systems for third party product integration, creating Master Data Management systems , and doing general DBA work for the past 10 years.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Thursday, April 23rd, 2009, 6:30 PM - 8:00 PM

fibrock — Tue, 05 May 2009 12:00:00 GMT

When: Thursday, April 23rd, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Change In Plans!

Who:
Andy Leonard

What: Database Development
Andy Leonard demonstrates obvious and not-so-obvious techniques of SQL Server database development.

About Andy:

Andy Leonard is not Donald Farmer. :) Andy is, however, a SQL Server database and business intellgence developer. He owns a car. His favorite color is blue and he prefers cyberpets to the real thing. If this sort of humor appeals to you (along with talks about database development), join Andy at Richmond SQL Server Users Group!

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Thursday, April 23rd, 2009, 6:30 PM - 8:00 PM

fibrock — Thu, 26 Mar 2009 12:28:00 GMT

When: Thursday, April 23rd, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Donald Farmer

What: Tackling the future with Microsoft BI
There is no denying that the global economic situation is challenging. Is your company prepared to weather the storm? Microsoft business intelligence is uniquely positioned to help you find profitable customers & inefficiencies, and save money. This session features guidance on new ways to find value from your existing Microsoft business Intelligence investments, but it also includes a preview of what is to come in the future: New technologies for self-service analysis and self-service reporting that will change the way in which you think about BI. We will outline the major enhancements that SQL server is making for BI in the SQL Server Kilimanjaro release, including the exciting new Project Gemini.

About Donald:
Donald Farmer has worked in the Microsoft Business Intelligence team for 7 years, with experience in both the Analysis Services and Integration Services product teams. Donald is now a Principal Program Manager for SQL Server Analysis Services, working to build a new generation of analytic technology. Mr. Farmer is a popular speaker at international events for both business and technical audiences, with a wide range of interests including data integration, information quality, metadata intelligence, master data management and predictive analytics. He is a Guest Professor at the College of Software and Information Science, Southwestern University at Chongqing, China and is the author of a number of books and articles. Prior to joining Microsoft, Donald worked not only in Business Intelligence but in fields as varied as medieval archaeology and fish-farming.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Thursday, March 12th, 2009, 6:30 PM - 8:00 PM

fibrock — Fri, 06 Mar 2009 13:37:00 GMT

When: Thursday, March 12th, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Brian Knight and Tom Robinson

What: Microsoft PerformancePoint Server 2007 - Monitoring ServerAbstract:
Microsoft has recently announced a significant change in their business intelligence strategy. They will discontinue the planning component of the PerformancePoint Server 2007 and will fold the “monitoring and analysis” component into Office SharePoint Server Enterprise with the release of SharePoint 14 in late 2009. This presentation will cover architecture and application concepts for the Monitoring Server component of PerformancePoint Server 2007. The primary focus of the presentation will be an introduction to the Dashboard Designer; the main dashboard development component. The key concepts and functionality covered in the presentation are expected to apply to SharePoint PerformancePoint Services.
About Brian:

Brian Knight is a business intelligence consultant with Ironworks Consulting in Glen Allen, VA. Brian specializes in the design and development of large-scale data solutions using Microsoft technologies, specifically SQL Server 2005 and 2008. Previously, Brian was a Manager of Database Services at Crutchfield Corporation in Charlottesville, VA. He has a particular interest in developing comprehensive IT infrastructures and services around an ITIL-based framework. Brian currently holds the MCITP: Database Administration and MCITP: Enterprise Administrator certifications.

About Tom:

Tom Robinson lives in Mechanicsville, VA and is currently a business intelligence consultant with Ironworks Consulting in Glen Allen, VA. As an Ironworks consultant, Tom has worked primarily on BI solutions involving SQL Server Analysis Services and SQL Integration Services. Prior to Ironworks, Tom was a Director of IT for Data Services at a finance company where he implemented business intelligence solutions including dashboards. Tom is a former CPA who switched to Information Technology in the early 90s to later become a Microsoft consultant with MCSD and MCDBA certifications.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

IRONWORKS

Thursday, February 12th, 2009, 6:30 PM - 8:00 PM

fibrock — Mon, 02 Feb 2009 13:02:00 GMT

When: Thursday, February 12th, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:

Rick Todd

What: Supporting RDBMS

Abstract:

Having supported a variety of customers through the years (insurance, banking, ski resorts, historic sites, hotels, ecommerce, etc.) one thing has been consistent: when you get a report that the database-based system is having problems, be it an outage or slowness, it’s best to have a plan of attack. Having recently had to support a non-SQL Server RDBMS performance issue, it became even more apparent that the approach that should be taken across almost any type of business or whatever the RDBMS should be the same. This presentation will cover a guideline for supporting your applications. It will start with the phone ringing in whatever support environment you have, and move from general concepts helpful for any RDBMS into specific things to run on a windows-based SQL Server 2005+ environment. Even if you don’t adopt the approach presented, if you decide to come up with your own process to follow I’ll feel like I’ve accomplished what I wanted. Please be prepared to share suggestions as to how you support your own DBs as I hope this will be a meeting where everyone gets involved in the discussion.

About Rick:

Rick Todd has been a database developer for 9 years. Initially as a private consultant in Chicago for the health care industry, the Federal Reserve Bank, and various smaller customers. From there he went on to be a Database Architect for Resort Technology Partners, LLC of Vail then Avon Colorado. At RTP Rick was responsible for design and development of various OLTP systems for the #1 ski resort software developer in North America. After 7 years at RTP, Rick visited the Colonial Williamsburg Foundation after they purchased RTP’s software and flew him out for training on the database. Rick moved to Williamsburg and started the Data Warehouse project for the Colonial Williamsburg Foundation last year in May.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Presentation from RSSUG Meeting Thursday, January 15th, 2009, 6:30 PM - 8:00 PM

fibrock — Fri, 16 Jan 2009 13:11:00 GMT

Recap:

I think last night’s presentation went pretty well, we had a lot of participation from the group and I know if nothing else I learned a few things. If anyone wants any of the slide deck or the T-SQL scripts for parts of the presentation we did not get to they can be download from the links below. The portion of the demonstration for the GUI setup of database mirroring that required some t-sql are downloadable below as well. I hope everyone who turned out had a good time and learn something. Thank you all for turning out and a special thank for our sponsor Richmond Code Camp 2009!

Presentation Links:

SQL2k5_Mirroring.pptx

DBMirroring_HP_TSQLSetup.sql

DBMirroring_HS_GUISetup.sql

Who:

Steve Fibich

What: SQL 2005 Database Mirroring

Abstract:

SQL Server 2005 introduces a number of new features, one of which is Database Mirroring. This is the 2nd out of the box technology from Microsoft for SQL Server that allows native configuration of a Hot Standby Server. It has a completely different configuration than its cousin SQL Clustering and opens up a whole host of secondary possibilities for the resourceful DBA. Come by and take a look as we kick the tires on this new but seldom used solution.

Thursday, January 15th, 2009, 6:30 PM - 8:00 PM

fibrock — Mon, 29 Dec 2008 17:53:00 GMT

When: Thursday, January 15th, 2009, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:

Steve Fibich

What: SQL 2005 Database Mirroring

Abstract:

About Steve:

Steve Fibich currently works in Richmond VA at PFGC as the Systems/Database Architect on a Master Data Management project utilizing SQL Server 2005 and SSIS 2005 pulling data from iSeries, Unix, VAX, and SAP for a massive system integration effort. He has been working with SQL Server since 6.5 building Data Warehouses, building integration systems for third party product integration, creating Master Data Management systems , and doing general DBA work for the past 10 years.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

Thursday, December 11th, 2008, 6:30 PM - 8:00 PM

fibrock — Tue, 23 Dec 2008 12:59:00 GMT

When: Thursday, December 11th, 2008, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:

Andy Leonard and Jessica Moss

What: SSIS Scripting

Overview of Presentation:

Can't find an SSIS Task that does what you need? Script it! The Script Task and Script Component in SSIS are extremely powerful and flexible. In this session you will learn how to customize SSIS functionality using Script objects, best practices for script development, script troubleshooting techniques, and script lifecycle management.

About Andy:

Andy Leonard is a Solid Quality Mentor, SQL Server database and Integration Services developer, SQL Server MVP, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services , Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers , MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005 , and the upcoming e-book Mastering Visual Studio Team System Database Edition . Andy founded and manages VSTeamSystemCentral.com and maintains two blogs there: Applied Team System and Applied Business Intelligence . He also blogs for SQLBlog.com. Andy's background includes web application architecture and development, VB.Net, ASP, and ASP.Net; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000 and 2005; and test-driven database development.

About Jessica:

Jessica Moss is a Microsoft SQL Server MVP, a business intelligence mentor with Solid Quality Mentors, and an MCDBA and MCTS: SQL Server 2005 Business Intelligence. She has been working with SQL Server 2005 since its release and has participated in many warehousing and reporting solutions. Jessica enjoys working with the local community and is a regular speaker at user groups, code camps, and conferences. You can read about her work on her blog, http://jessicammoss.blogspot.com.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

Thanks to our Sponsors

Thursday, Novemeber 13th, 2008, 6:30 PM - 8:00 PM

fibrock — Wed, 15 Oct 2008 11:47:00 GMT

When: Thursday, November 13th, 2008, 6:30 PM - 8:00 PM
Social Time starts at 6:00 AM!

Who:

Jessica Moss

What: Building Reports in SQL Server Reporting Services 2008

Overview of Presentation:

Using SQL Server Reporting Services can simplify designing reports, but how do you handle complex report requirements? This session will discuss how to handle these complex scenarios by using the new features of SSRS 2008. We will walk through building reports to showcase these situations. This session will be friendly to people who have experience in either SSRS 2005 or SSRS 2008.

About Jessica:

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]
Register: Click here to register!

Thanks to our Sponsors

Thursday, October 9th 2008, 6:30PM -8:00PM

fibrock — Wed, 15 Oct 2008 11:46:00 GMT

When: Thursday, October 9th, 2008, 6:30 PM - 8:00 PM
Social Time starts at 6:00 AM!

Who:

Michael Coles

What: SQL 2008 Full-Text Search, Filestream Storage, and Fuzzy Searching

Overview of Presentation:

* New Integrated Full-Text Search (iFTS) in SQL Server 2008 - full-text search is highly integrated with the SQL Server query engine in SQL Server 2008. This makes administration easier, improves performance significantly, and increases scalability.

* The new filestream data type attribute in SQL Server 2008 - takes advantage of Windows NTFS transactions and streaming to improve performance and provide greater manageability for binary large object (BLOB) data.

* SQL Server 2008 provides several new dynamic management views and functions, and new catalog views, to make full-text search processing fully transparent to developers.

* I'll also give a survey of alternative fuzzy-search techniques including Soundex, NYSIIS, n-grams, ternary search trees, and regular expressions.

* Also we'll talk about how to quickly and easily create a Google-style search interface for your SQL Server 2008 iFTS-enabled databases.

About Michael:

Michael Coles is a Microsoft MVP (SQL) with over 15 years' experience designing and administering SQL Server databases. A prolific writer on all aspects of SQL Server, particularly on the expert use of T-SQL, Michael has written dozens of published articles and several books including Pro SQL Server 2008 XML, Pro T-SQL 2008 Programmer's Guide, and Accelerated SQL Server 2008. Currently he is contributing chapters to a Microsoft MVP charity book project and working on a project to detail SQL Server 2008 encryption technology.

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]
Register: Click here to register!

Thanks to our Sponsors

Thursday September 11th 2008 6:30PM to 8:00PM

fibrock — Tue, 19 Aug 2008 16:18:00 GMT

August's Presentation: An Introduction to Analysis Services 2005

Registration - Please register!

This Months Sponsor-Fahrenheit Technology

Abstract:

Microsoft’s Analysis Services 2005 is best known for its ability to build and manage OLAP data cubes. In addition to that core functionality, SSAS enables users to define key performance indicators (KPIs), profile data, mine data and predict future activities using the results of that mining. Perhaps best of all, SSAS is included as part of SQL Server 2005 Standard and Enterprise Editions. This session introduces the audience to the capabilities of SSAS, businesses uses for those tools and ways to integrate SSAS with Integration Services and Reporting Services.

About Mark:

Mark Hudson has more than 10 years experience in business intelligence and data analysis. He has developed data warehouses and data presentation layers using numerous tools including both SQL Server 2000 and SQL Server 2005. He currently serves as an architect and developer with CapTech Ventures, Inc. (mhudson@captechventures.com, www.captechventures.com).

Presentations - Heroes Happen {here} 2008 Launch Wave

fibrock — Mon, 18 Aug 2008 16:32:00 GMT

How was it?:

Thank you everyone for coming out and joining us for the SQL Server 2008 Community Event. Everything from my point of view went off without a hitch. We will have the presentations posted with links on this blog post as soon as they become available. Special thanks to MaconIT for lunch, Solid Quality Learning for breakfast and a great two day training give away. Thanks to Microsoft for a number of great give always including TechNet subscriptions and some great shirts and jackets.

Thank you to Andy Leonard, Kevin Hazzard and Susan Lennon without who this would not have been possible.

Andy posted some pictures at his site on Visual Studio Team Systems Central!

Andy's -Updated_CDC_Files.zip

Kevin's -

Steve's -SQL2008-PowerShell the Sleeper Feature!.zip

Susan's - SSRS08.pptx

When: Saturday, August 16th, 2008, 10:00 PM - 2:00 PM
Social Time starts at 9:45 AM!

Who:

Andy Leonard, Kevin Hazzard,Susan Lennon, and Steve Fibich

What: Richmond SQL Server Users Group Presents:
Heroes Happen {here} 2008 Launch Wave

9:45 Breakfast - sponsored by Solid Quality Directions!
10:00 Andy Leonard - SQL Server 2008: SQL Server 2008 Integration Services, Change Data Capture, and Incremental Loads
11:00 Kevin Hazzard - Visual Studio 2008
12:00 Steve Fibich - SQL Server 2008 - SQL Server 2008 PowerShell Integration: What is it good for?
12:00 Lunch (while listening to Steve!) - sponsored by MaconIT!
1:00 Susan Lennon - SQL Server 2008 - SQL Server 2008 Reporting Services
1:45 Closing and Give Aways
2:00 Event Ends - Everyone goes home and blogs about the great time everyone had!

Registration is limited for this event. Please register today!

Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Presentation Information for - Thursday August 14th 2008 6:30PM to 8:00PM

fibrock — Mon, 18 Aug 2008 16:24:00 GMT

August's Presentation: SSIS FrameWorks!

Here is the slide show for this event:Object Oriented Technics applied to SSIS Development.zip; Code samples to follow soon (check back in a day or two)

This Months Sponsor-McClain Group II

Abstract:

SSIS Frameworks focuses on Object Oriented programming techniques applied to SSIS Development. We will explore the concepts of encapsulation and modularity from an Object Oriented Programming perspective and how this can be applied to developing SSIS packages. SSIS Frameworks will look into building both a metadata structure and the SSIS package design, to support breaking units of work into small reusable SSIS packages and how to structure those packages for re-use. Real world examples from a Data Warehouse to Master Data Management Systems will be referenced to show how this type of SSIS development can cut development time and allow for coding work to be spread across a team. We will also get into the nitty gritty of some SSIS configurations/event handlers/variable passing.

About Steve:

Thursday August 14th 2008 6:30PM to 8:00PM

fibrock — Tue, 05 Aug 2008 11:59:00 GMT

August's Presentation: SSIS FrameWorks!

Registration - Please register!

This Months Sponsor-McClain Group II

Abstract:

About Steve:

Saturday August 16th 2008 10:00AM to 2:00PM

fibrock — Tue, 29 Jul 2008 14:21:00 GMT

SQL Server 2008 Community Event

What:

SQL Server 2008 Community Event

Featuring SQL Server 2008 with W2k8 and VS2k8. There will be 3 to 4 presentations focusing on SQL Server 2008, but also covering Windows 2008 and Visual Studio 2008. Lunch will be provided. Details are being ironed out but we wanted to get some information out to you (the community) as soon as possible! Please Register

Sponsors (More to come)

MaconIT

Microsoft

Where:

Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Thursday July 17th 2008 6:30PM to 8:00PM

fibrock — Wed, 25 Jun 2008 20:23:00 GMT

June's Presentation: Colonial Williamsburg’s Foundation Data Warehouse overview with Rick Todd!

Registration - Coming Soon!

This Months Sponsor

Abstract:

Colonial Williamsburg’s Foundation Data Warehouse, where the 18th century meets the 21st century. Rick Todd from the Colonial Williamsburg Foundation IT Department will be sharing some of their insights into handling the ever-tricky Customer Dimension while building their Data Warehouse. Colonial Williamsburg is a perfect fit for a Data Warehouse, having lines of business as diverse as Ticketing, Hotel, Food and Beverage, Retail (online, on location, and catalog), Spa, and Golf. Rick will be discussing some of the successes and failures his team (of 2) has had will attempting to import, conform, merge, household, and report on customers across all these systems (which currently include SQL 2000, SQL 2005, and AS400). The first 3/4ths of the presentation will be a fairly fast moving, high level discussion covering modeling the Customer dimension, an ETL framework for conformed dimensions, merging, purging, and householding Customers through fuzzy logic, and handling the conformed dimension in Analysis Services. The last 1/4th of the meeting time will be left for a more in-depth discussion of any areas that people find interesting. Please come to help Rick further Colonial Williamsburg’s mission: That the Future May Learn From the Past. In this case, their Rick’s teams’ past mistakes and successes, as opposed to the founding of our country.

About Rick:

Thursday June 12th 2008 6:30PM to 8:00PM

fibrock — Tue, 03 Jun 2008 16:46:00 GMT

June's Presentation: RSSUG Round table!

Registration - Coming Soon!

This Months Sponsor

Abstract

This is going to be round table discussion facilitated by Andy Leonard, Ron Deskins, and Mark Hudson. The topic is SQL Server, but other than that it is wide open. Please post your comments to the board so we can get a lively discussion going at the meeting!

About Everyone:

Mark Hudson has more than 10 years experience in business intelligence and data analysis. He has developed data warehouses and report presentation layers using both SQL Server 2000 and SQL Server 2005. He currently serves the Richmond area as a data architect and developer with CapTech Ventures.

Ron Deskins - Richmond SQL Server User Group President. (No picture on file)