August's Presentation: SSIS FrameWorks!

Registration -  Please register!

This Months Sponsor-McClain Group II

Abstract:

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.

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

Registration - Coming Soon!

This Months Sponsor

Abstract:

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.

Register: Click here to register!

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:

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.

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)

Registration is not required for this event but if you plan to attend, please register so we'll know how many developers and database professionals to expect (feed). Thanks! 

This Months Sponsor

Abstract

Language Integrated Query (LINQ) marks the beginning of a massive shift in Microsoft’s data access philosophy. For those of us who grew up in the era when Microsoft touted the benefits of stored procedures as a necessary and sufficient abstraction of business logic, Object/Relational Mapping (O/RM) tools like LINQ to SQL can present a somewhat rude awakening. Because of our upbringing, we’ve learned to spend much of our time optimizing our stored procedures as a throttle for managing database performance in general. But what happens when the stored procedures simply disappear? Are you ready for that?
 
While moving business logic away from the database and into the middle tier is exciting for plenty of reasons, the specter of losing some control over database performance is very unsettling to most DBAs. Likewise, C# and VB developers need to get ready for the changes that LINQ to SQL will bring to them, too. When database performance suffers while using an O/RM tool, software developers will be called on to participate in the triage and tuning of queries in ways for which they may not be fully prepared. No more finger pointing at the database people when the database is slow. So this presentation should be as useful to software developers as it will be for the traditional DBAs and database developers in the audience. Come learn how to use the SQL Profiler to find and fix bottlenecks in your LINQ to SQL queries. The discussion will be fast-paced, informative and highly interactive.

About Kevin

Kevin is currently the Software Architect for SnagAJob.com in Richmond, Virginia. He has served on the Internet Engineering Task Force (IETF) and as an advisor to Virginia’s Joint Commission on Technology and Science (JCOTS). Kevin currently serves as the Chairman of the Information Systems and Technology Advisory Board for J. Sargeant Reynolds Community College. He’s also served the College as an adjunct instructor since the year 2000. As a Senior Engineer in the Intel Architecture Labs, Kevin successfully authored patents and designed ciphers, networking protocols and peer-to-peer components used by millions of users worldwide. Kevin has been designing and writing software for 25 years. He loves the art and the science of his job as much today as he did in the very beginning. Kevin is a father to five, a husband to one and a servant to many others. He speaks a bit of Portuguese, a bit of German and enjoys doing missionary work in South America. For fun, he enjoys motorcycling, hiking, etymology, bird-watching and friendly yet passionate discussions about politics and history.

Some of you have been asking if RSSUG new anything about the Richmond Code Camp Schedule.  Well here it is:

http://richmondcodecamp.org/Lists/20081Sked/calendar.aspx?CalendarDate=4/26/2008&CalendarPeriod=Day

Adam Machanic's demo from last nights meeting are available from the download area:

Presentation->AdamMachanic

You must be a registered Richmond SQL Server Group Site user to download the files.

March's Presentation: Designing Highly Concurrent SQL Server Database Applications
by Adam Machanic, SQL Server MVP

Registration is not required for this event but if you plan to attend, please register so we'll know how many developers and database professionals to expect (feed). Thanks!

This months sponsor is:

Abstract

Isn’t it amazing how well applications would scale with zero concurrent users? Fortunately for our careers, we often deal with the opposite problem: Lots of users, all working with the same data at the same time. This session starts with a discussion of the types of concurrency issues you might encounter, and then moves on to an analysis of techniques for solving the problems that concurrency brings to the table. We will look at both the tools SQL Server provides natively, as well as database and application design strategies that can help to maximize the user experience in highly concurrent applications.

About Adam Machanic

Adam Machanic is an independent database software consultant, writer, and speaker based in Boston, Massachusetts. He has implemented SQL Server solutions for a variety of high-availability OLTP and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. Adam has written numerous articles and has contributed to several books on SQL Server, including Expert SQL Server 2005 Development (Apress, 2007). He regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP).

Kevin Viers, Microsoft
presents What's New In SQL Server 2008

Wednesday, March 12, 2008, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!
Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]

Sponsor: 

Registration is not required for this event but if you plan to attend, please register so we'll know how many developers and database professionals to expect (feed). Thanks!

Abstract
Come see a preview of what is coming in SQL Server 2008. This session will be demo heavy and we will be able to get a preview of some of the exciting new features of 2008 including Policy Management Framework, Performance Data Collection, Resource Governor, Encryption, Backup Compression, Change Data Capture, New Report Designer, and more. If, like most, you have been too busy with your day job to take 2008 for a test drive then this is a great opportunity to get a firsthand look at the continued investment Microsoft is making to ensure that SQL Server 2008 is the first choice for enterprise class, mission critical database workloads.

February's Presentation: Introduction to Data Mining
by Brian Knight, MVP

Abstract

We’ve all seen Amazon’s cool feature where they recommend a set of books based on other books that you have bought. Now this feature can be yours! In this session SQL Server MVP, Brian Knight demonstrates the power of using SQL Server Analysis Services data mining in your projects for predictive analysis. Brian will start with the process to create a data mining process with your data and how to integrate it into your application. Lastly, he’ll show you some shortcuts on how to use data mining by using the Data Mining add-in for Excel 2007.  

About Brian Knight

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for SQL Server Standard and also maintains a regular column for the database website SQLServerCentral.com and does regular webcasts at Jumpstart TV. He has co-authored and authored more than 9 SQL Server books including Admin911: SQL Server (Osborne/McGraw-Hill Publishing), Professional SQL Server DTS, Expert SSIS, Professional SQL Server 2005 Administration and Professional SQL Server 2005 SSIS (Wrox Press). Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. Brian spends most of his time trying to think about how to use the word onomatopoeia in every day sentences.

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

Who: Andy Leonard, SQL Server MVP

What: Introducing Change Data Capture, SSIS and SQL Server 2008 

Where: