RichmondSQL

Thursday, April 11th, 2012, 6:30 PM - 8:00 PM

steve — Tue, 30 Apr 2013 00:09:00 GMT

Speaker: Kevin Hazzard

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

About Steve

Kevin Hazzard is a consultant, author and Microsoft Windows Azure MVP from the Richmond, Virginia. He serves as a Director at CapTech Consulting, a technology consulting firm of 400 where he designs and implements large-scale SQL Server databases and .NET services for Fortune 500 clients, focusing on the health care, retail, manufacturing and communication industries. Kevin is the lead author of Metaprogramming in .NET by Manning, a book that concerns the value of adaptable software design.

Abstract:

Creating an Flexible Data Quality Foundation
Data Quality (DQ) tools are typically expensive and difficult to integrate into your ETL and governance plans but it doesn't have to be that way. During this fun, highly-interactive session, Kevin Hazzard (Microsoft Windows Azure MVP and author of the book Metaprogramming in .NET), will show you how to implement a modular, highly resilient DQ foundation from the tools you already own, no matter which version of SQL Server you're using today.

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060

This Months Sponsor:

Event Registration

March 7th, 2012, 6:30 PM - 8:00 PM

steve — Sun, 24 Mar 2013 22:31:00 GMT

Speaker: Steve Jones

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

About Steve

Steve has been working with SQL Server since 1991, when he became the accidental DBA for a SQL Server v4.2 system running on OS/2 1.3. He is the editor of SQLServerCentral.com, which he has done for the last 8 years. He also has an undergraduate degree from the University of Virginia in Economics.

Your Questions, Your Group, Your Answers.

Abstract:

Its Steve Jones! You know it will be good!

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060

This Months Sponsor:

RichmondSQL

Paul Oster - Thursday, December 13th, 2012, 6:30 PM - 8:00 PM

steve — Wed, 05 Dec 2012 01:11:00 GMT

Richmond SQL Server User Group

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

SQL Server and XML Imports and Exports

The discussion will cover beginner and intermediate SQL Server based XML for data export. The discussion will start by covering basic XML generation via SQL Server and XML schema validation, moving on to intermediate XML export. It will then go into a more advanced topic of utilizing XSLT to create robust data import scripts via xlst and xquery/xpath.

Session Level: Intermediate

Paul Oster

Paul Oster has worked with SQL Server and XML for over 10 years. He has developed XML/EDI systems and integrated SQL/XML/EDI based systems with various companies in Norway, Finland, Germany, Sweden, England, France, Canada, Brazil and the United States. He is currently a Database Administrator/Architect at McGuireWoods. He formerly served as Systems Manager for Lydall in Ct, Systems Manager at Penn Warehousing in Philadelphia and IT/Systems Director at CrossGlobe Group in Glen Allen, Va

Location: Markel Plaza

4600 Cox Road

Glen Allen, VA 23060

Register: Click Here!

Join Our Mailing List!

We've disabled the signup functions on this website. If you want to receive email updates about meetings and events, you need to join our new Mailing List!

RSSUG Codeplex Project - Thursday, November 8th, 2012, 6:30 PM - 8:00 PM

fibrock — Sat, 20 Oct 2012 17:29:00 GMT

Richmond SQL Server User Group

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

RSSUG Codeplex Project

Abstract

We need you to come out and make this project and meeting happen. We will be discussing project goals, project organization,and project time lines. We will also go over how to interact with the Codeplex site, how to become a code contributor and, how to download and check in source code using Tortise subversion. Please come with questions and energy, also bring your laptop. We should have power and WiFi connectiviy for everyone. This is an interactive meeting so be ready to give your two cents and to help your fellow RSSUG member.

Who:

All of us

Location: Markel Plaza

4600 Cox Road

Glen Allen, VA 23060

Register: Click here to register!

Wayne Sheffield - Thursday, October 11th, 2012, 6:30 PM - 8:00 PM

fibrock — Mon, 24 Sep 2012 13:17:00 GMT

Richmond SQL Server User Group

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

Table Vars & Temp Tables – What you NEED to Know!

Abstract

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”

Who:

Wayne Sheffield started working with databases in the late 1980's, using xBase languages. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 1990's) in various dev and admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and posting on his blog at http://blog.waynesheffield.com/wayne.

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 2306

Register: Click here to register!

RSSUG Codeplex Survey Results

fibrock — Sat, 01 Sep 2012 16:39:00 GMT

Well here we are September 1st, the close of the RSSUG Codeplex Survey (number 2). We have the following results from our survey:

64.5% (20 Votes) - A set of SQL Server Utilities

16.1% (5 Votes) - A data-hub to collect and serve data sets gathered from the web

6.5% (2 Votes) - A better version of Exchange using SQL Server as the back end

3.2% (1 Vote) - An ERP System

9.7% (3 Votes) - Other

Well it looks like a set of SQL Server Utilities is the winner. So what does this mean? We'll I'm not to sure I have my vision of what we mean a set of SQL Server Utilities but I'm not to sure what the RSSUG means when they voted on this. So I'll take a little time to explain my vision of what choice "A set of SQL Server Utilities" could me.

My thought is one of two things either a set of independent scripts that can be executed on any SQL Server (as long as its of say SQL Server 2008 forward) that would provide help to a DBA or Developer. Thing of this as something similar to a bunch of utility scripts like sp_whoIsActive, sp_Blitz, a defraging script, a backup script that you could count on because you knew who developed it...YOU!

Or "A set of SQL Server Utilities"could mean a deployed tool set similar to what you get from a 3rd party vendor like Idera, Quest, or Redgate. This would be set of T-SQL centric objects, procs, views, tables, stored procedures, jobs that are deployed to database and help you with management or development tasks on that server. You could deploy this to your entire enterprise to help manage each server. On top of this we could write Reporting Services reports, possibly some SSIS packages to consolidate the data to a main reporting enterprise database and use Analysis Services to help find resource usage trends across an enterprise. I think it may be obvious this is where I would like to take the project and I believe it would give us the best opportunity to make use of the entire SQL Server tool set. In fact I liked the idea so much I actually started a codeplex project months ago for this vary task.If this is the direction we want to go then we could easly take the existing codeplex project and add additional people to the project and change it to meet the groups needs.

Finally I want to take a minute to mention the Data Hub idea, because I don't think it was very well explained. The basic idea would be to create a SQL Server database either on a hosted server in or SQL Azure (I'm leaning to SQL Azure) that would we would then populate with public data sets and other data sets shared with us. This would allow us to do two things, one we create our own set of SQL Azure Reporting Services Reports or SQL Server Reporting Services and Analysis Services reports and cubes over top of this data so we could mine it. More importantly and most likely more beneficial to us is that we could source from this data in our own data warehouse and software development needs. This could house a set of standards and data sets anything from ISO Country Codes to Census Bureau information. This project would also has the potential to use a wide breath of the SQL Server tool set and it lends itself to SQL Azure for those who want to dive into that pool.

On that note I have created one more survey, this is the last one I swear then we will have a project.(The survey will close on the 12th)

I have also created a discussion thread on our Linked in RSSUG Group site to further this discussion.

Thanks Everyone!

Jessica M. Moss - Thursday, September 13th, 2012, 6:30 PM - 8:00 PM

fibrock — Fri, 24 Aug 2012 01:22:00 GMT

Richmond SQL Server User Group

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

Who:

Jessica M. Moss

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence for CapTech Consulting. Jessica's expertise includes dimensional modeling, ETLs, semantic modeling, report design, and helping customers across industries successfully implement and enhance their business intelligence solutions. Jessica enjoys sharing her knowledge with the central Virginia community, speaks regularly at user groups, code camps, and conferences, and has co-authored four technical books.

Abstract

Exploring your Data with Power View

Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and how to use each one.

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 2306

Register: Click here to register!

Carlos Chacon - Thursday, August 5th, 2012, 6:30 PM - 8:00 PM

fibrock — Fri, 24 Aug 2012 01:16:00 GMT

Richmond SQL Server User Group

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

Who:

Carlos Chacon is database consultant with SQL Data Partners and has experience in many different technology areas. He graduated from Mills Godwin High School here in Richmond and received a degree in Information Technology from Utah Valley University. In the database world he has earned his MCSDBA and is a Microsoft Certified Technology Specialist. He has been to 4 continents and hopes to check the others off his bucket list. He is a member of the Richmond SQL Server User Group and can eat his weight in Raspberries (yet to be proved).

Abstract
Sizing up SQL Azure

This presentation will take us through Microsoft's cloud based offering of SQL Server now named SQL Azure. There will be demonstrations of using the cloud based tools and how to synch databases. We will discuss how this will impact us as database administrators and what you can do to prepare as managers hear more about this.

We will review the following items in Azure
- What is it and how it differs from data center storage (IE Peak 10)
- High Availability and Disaster Recovery
- How to access via SQL Server Management studio
- How management strategies differ in SQL Azure

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 2306

Andy Leonard - Thursday, July 19th, 2012, 6:30 PM - 8:00 PM

fibrock — Fri, 24 Aug 2012 01:14:00 GMT

Richmond SQL Server User Group - July 2012

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

Who:

Andy Leonard

Using BIML as a Design Patterns Engine

Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.

Objectives:
1. Demonstrate how to generate multiple SSIS incremental load packages with a single click.
2. Demonstrate the power of repeatable patterns-based development.
3. Demonstrate the flexibility Biml brings to data integration development.

About Andy Leonard:

Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 2306

Jennifer Kenny - Thursday, June 14th, 2012, 6:30 PM - 8:00 PM

fibrock — Fri, 24 Aug 2012 01:13:00 GMT

Richmond SQL Server User Group - June 2012

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

Who:

Jennifer Kenny

The SQL Toolbox

No matter where you go, or what you do, if you're working with SQL there are some standard objects that can help you solve problems. This presentation will show you how to build and use increment tables, functions to pack and unpack multidimensional delimited lists, readers for those pesky COLUMNS_UPDATED outputs, and (time permitting) the wonderful world of DDL triggers.

About Jennifer Kenny:

Jennifer Kenney has been working with SQL since 1998. She has worked in the public sector and the private, small organizations and large, as a Developer, Teacher, DBA and Architect. Jennifer currently works for Molina Healthcare developing Medicaid administration software. Jennifer lives in Goochland with her husband and two rambunctius and ill-mannered beagles.

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 2306

This Months Sponsor:

Round Table - Thursday May 10th, 2012, 6:30 PM - 8:00 PM

fibrock — Fri, 24 Aug 2012 01:11:00 GMT

Richmond SQL Server User Group Round Table

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

Who:

You!

Your Questions, Your Group, Your Answers.

Abstract:

We've all had questions that haven’t been answered during or after a presentation. Or we had wished we could just start up our own conversation during a meeting and discuss what problems we are facing at work and see if the group could help. Well now this is your chance. This will be half social, half hard core SQL Server. Bring your laptops we have a screen available if you need to show your issue to the group. If you have burning question you would like to get to the group ahead of time please email them to us (events@richmondsql.org) and we will send them out with the May reminders!

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060

This Months Sponsor:

Steve Fibich - Thursday, April 12th, 2012

fibrock — Fri, 24 Aug 2012 01:10:00 GMT

SQL Development Tips and Tricks to become a more efficient DBA/Developer

When: Thursday, April th, 2012, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:

Steve Fibich

Steve Fibich currently works in Richmond VA at Markel Corporation as a IT Analysts on their Data Warehousing project. Steve has 12+ years experience with SQL Server from SQL 6.5 to SQL 2008. Steve has dealt with the SQL Server from the perspective of a front end developer, a DBA, and SQL Developer.

Abstract:

We’ve all learned a few best practices and even some “worse” practices. I’ll try to cover some of the best productivity and coding practices I have come across and maybe even share some of the bad habits I’ve managed to kick. We will look at what SSMS Projects, shortcuts keys, SQLCMD, Powershell, and Version Control Systems can do to make you a better DBA, a better developer and all around more productive SQL Server professional. (It will be fun I promise!)

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [map]

This Months Sponsor:

Wayne Sheffield - Thursday March 8th 2012

fibrock — Sat, 24 Mar 2012 00:44:00 GMT

Windowing Functions in SQL Server 2012 by Wayne Sheffield!

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

Who:
Wayne Sheffield

Bio:

Wayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at www.sqlservercentral.com, where he also is active on the forums assisting the community.

Abstract:

SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to find out the changes to existing windowing functions, and the new windowing functions that have been added.

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Kevin Griffin - Thursday, February 9th, 2012

fibrock — Wed, 25 Jan 2012 01:19:00 GMT

Kevin Griffin - Windows Azure!

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

Who:
Kevin Griffin

Bio:

Kevin Griffin is a Technical Evangelist for ComponentOne. He’s a Microsoft MVP, ASPInsider, and the leader of the Hampton Roads .NET Users Group. Additionally, he serves as an INETA mentor for the state of Virginia. He can often be found speaking at or attending other local user group meetings or code camps. He enjoys working with new technology, and consistently works on being a better developer and building the best software he can.

Abstract:

Windows Azure was first introduced the world in October 2008. Over the years it has changed the way we look at building applications and software infrastructures. In this presentation, we're going to take a look at Azure from the ground up. What is it? What are the moving parts? How do we develop software and systems to take advantage of it? We'll answer all these questions and more!

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Geoff Johnson - Thursday, January 12th, 2012

fibrock — Sat, 24 Dec 2011 01:50:00 GMT

Geoff Johnson - Common Table Expressions!

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

Who:
Geoff Johnson

Bio:

Geoff Johnson is the Education Team Lead for Shelby Systems, Inc., a Microsoft Gold Partner providing software solutions for non-profit organizations around the world, particularly churches and parachurch organizations. Over the past five years he has conducted numerous training workshops to teach Shelby customers how to use T-SQL statements as the foundation of custom reports. Recently he wrote and conducted a brand new training workshop on using Reporting Services 2008 R2 with the Shelby software database. In addition to training, Geoff develops custom report solutions ranging in complexity from simple membership directories to GAAP-compliant financial statements, building all of them with T-SQL and many of them with Reporting Services.

An active member of the Richmond SQL Server Users Group and PASS, Geoff recently had the privilege of presenting at SQL Saturday #96 in Washington, DC and now is looking forward to the chance to give back directly to his local user group.

Abstract:

Common Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables.

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

VACO

Thursday, December 8th, 2011 - Richmond SQL Round Table!

fibrock — Sat, 24 Dec 2011 01:31:00 GMT

RichmondSQL Round Table!

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

Who:
Roundtable featuring RichmondSQL Leadership!
Your leadership, your questions. It should rock!

Abstract

It's the last RichmondSQL meeting of 2011. Bring your SQL Server questions to our round table discussion!

Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

RichmondSQL

Wayne Sheffield - Thursday, September 8th, 2011

fibrock — Wed, 28 Sep 2011 00:53:00 GMT

Wayne Sheffield - Avoid the RBAR!

When: Thursday, September 8th, 2011, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Wayne Sheffield

Wayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at www.sqlservercentral.com, where he also is active on the forums assisting the community.

Abstract

SQL Server is primarily designed for set-based operations, so writing code that performs Row-By-Agonizing-Row (RBAR) operations is going against the design, rather than working with it. In this code filled “Developer–to–Developer” session, we will examine several recent additions to SQL Server, and learn how the vast majority of RBAR code can be replaced with efficient, set-based code. Learn how the APPLY operator works with table-valued functions; iterate through incoming data just once with the MERGE statement instead of once per DML operation; see how the Windowing (ranking) functions allow you to “slice and dice” your data, and then perform operations on those groupings; discover how re-writing your multi-statement table-valued functions to be inline functions can help the optimizer and speed up your queries; and learn how to create a grouped delimited list – without loops! Come to this demo-packed session and learn how the vast majority of loop-based operations can be replaced with very efficient set-based operations!

Where: Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

Jennifer Kenney - Thursday, August 11th, 2011, 6:30 PM - 8:00 PM

fibrock — Thu, 08 Sep 2011 02:05:00 GMT

Jennifer Kenney - Building A SQL Rules Engine

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

Who:
Jennifer Kenney

Jennifer Kenney is a Senior SQL Developer with Molina Healthcare. She has been developing software professionally since 1990, and has concentrated on databases in medical applications. She has twice been a presenter at the Richmond, VA Code Camp on issues in SQL Development. She currently lives in Goochland, VA with a wonderful husband and two marvelous dogs and a cat who is well above-average.

Abstract

Building a SQL Rules Engine – SQL is not the ideal platform for a Business Layer, but sometimes you don't have much of a choice! The same rules for performance apply here as would if you were coding in VB.Net or C#: you want to encapsulate your code and you want to read once, apply all your rules, and then write the changes once. Unfortunately, SQL doesn't have the same tools to expose multiple arrays of writeable data held in memory to multiple procedures that exist in the .Net framework. This presentation focuses on using the XML DML syntax to solve this problem, allowing for quick reads and writes of in-memory data that can be passed in and out of multiple black boxes, allowing for quick processing and code encapsulation. The presentation also features cartoons.

Where: Location: Markel Plaza

4600 Cox Road
Glen Allen, VA 23060 [map]

Register: Click here to register!

This Months Sponsor:

SQLPeople

Andrew Kelly - July 14th, 2011, 6:30 PM - 8:00 PM

fibrock — Wed, 06 Jul 2011 01:38:00 GMT

Andrew Kelly - Understanding Indexes in SQL Server 2008

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

Who:
Andrew Kelly (MVP)

Andrew J. Kelly is the Practice Manager for Performance & Scalability with SolidQ and lives in Plaistow, New Hampshire. He has over 20 years experience with relational databases and application development on both UNIX and Windows platforms but his main focus now is SQL Server. In addition to general SQL Server training and Mentoring, he specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at many conferences and user groups and has been a SQL Server MVP since 2001.

Abstract

Understanding Indexes in SQL Server 2008
Understanding the fundamentals of how indexes work and how they are best utilized is an essential part of any DBA or SQL developer's repertoire. Many people assume if you create an index on a column or columns of a table that it will automatically be used when you reference that column. While that may be true under some conditions the actual usage depends on several key factors and they may surprise you. We will cover the fundamentals of how the indexes work under the covers and why you need to know this in order to ensure your indexes are actually helping and not hurting your performance.

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

Register: Click here to register!

This Months Sponsor:

Grant Fritchey - June 9th, 2011

fibrock — Tue, 05 Jul 2011 02:02:00 GMT

Grant Fritchey (the Scary DBA himself) presents Reading Execution Plans, the Deep Dive

When: Thursday, June 9th, 2011, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years experience in IT including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant volunteers with PASS and is president of the Southern New England SQL Server Users Group (SNESSUG). He has authored books for Apress and Simple-Talk and joined Red Gate as a Product Evangelist in January 2011.

Reading Execution Plans

It’s one thing to know to look for scans instead of seeks, but if you really want to know what’s going on in an execution plan, you need to dive deep. This session will cover reading execution plans from the basics, but goes way beyond the basics to cover as much of the information available within an execution plan as you might possibly ever need. We’ll cover the basics, like looking for fat pipes, but we’ll also go into how to understand how to interpret parameter sniffing and spot when a join operation is not performing the way you would want. We’ll use the graphical plan and the XML behind to thoroughly explore execution plans.

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

Register: Click here to register!

This Months Sponsor:

February 10th, 2011, 6:30 PM - 8:00 PM

fibrock — Sun, 20 Feb 2011 18:23:00 GMT

Steve Fibich presents Practical Change Data Capture

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

Who:
Steve Fibich

What: Practical Change Data Capture

Looking to revamp your current ETL or data Audit process? Have you heard of Change Data Capture introduce in SQL 2008? Could you use this as part of you solution? Need some help figuring out how to utilize CDC? Then this talk is for you. We will be exploring post implementation results of an actual CDC based ETL process. This is not a bunch of untested theory and untried rhetoric, it’s the lessons learned from a year long project and 6 months of living with a production CDC based ETL system.

About Steve:

Steve Fibich currently works in Richmond VA at PFGC as the Data Warehouse Architect on a Data Warehousing /Master Data Management project utilizing SQL Server 2008/2005 and SSIS 2008/2005 pulling data from iSeries, 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:

We've disabled the signup functions on this website. If you want to receive email updates about meetings and events, you need to join our new Mailing List!

Join Today!

January 13th, 2011, 6:30 PM - 8:00 PM

fibrock — Fri, 07 Jan 2011 13:46:00 GMT

Stefan Bauer presents SSIS in Denali CTP1 When: January 13th, 2011, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Stefan Bauer Stefan Bauer is a Data Warehouse Administrator at a marketing company in Richmond, VA. He has worked in Business Intelligence and Data Warehousing since the late 1990’s on a variety of platforms. Stefan has created warehouse and business intelligence solutions for banking, retail, and marketing companies. Currently working in SQL Server 2008, Stefan provides insight into hardware architecture, database modeling, as well as developing in Integration Services, Analysis Services and Reporting Services. In addition to traditional development, Stefan enjoys teaching topics on architecture, database administration and performance tuning. What: SSIS in Denali CTP1 Have you heard about Denali? Hot off the press from Microsoft is their latest database release. If you missed it at the PASS Summit, come see what is new for SSIS in the Community Technical Preview (ctp1) release of Denali and what all the buzz is about. I will take a hands-on approach to looking at the new features in SSIS, and also take a look at what Dependency Services is about. I am sure you will be as excited about the new release as I am, so we will also cover the basics you need to know to get up-and-running with the ctp release. Where: Location: Markel Plaza 4501 Highwoods Parkway (DIFFERENT LOCATION!) Glen Allen, VA 23060 [map] Register: Click here to register! This Months Sponsor: TBA

December 9th, 2010, 6:30 PM - 8:00 PM

fibrock — Sat, 11 Dec 2010 19:50:00 GMT

Andy Leonard presents SSIS Design Patterns (from his PASS Summit 2010 Spotlight Session)

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

Who:
Andy Leonard

Andy Leonard is an SSIS Trainer and Consultant, Architect with Molina Medicaid Solutions, SQL Server database and Integration Services developer, professional trainer, community mentor, SQL Server MVP, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. Andy blogs for SQLBlog.com. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008.

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! At the PASS Summit 2009, Andy Leonard demonstrated ways to use some less-documented features of SSIS. At the PASS Summit 2010 Andy shares more SSIS Design Patterns. This session includes patterns: - to migrate SSIS packages through your enterprise without editing connection managers; - to load data from variable-length row files; - to extend the functionality of the parent-child pattern to create SSIS execution groups. The session is designed for those with little or no exposure to design patterns or application development methodologies; but with good experience in SSIS. The goal is to introduce the science, terminology, and philosophy of design patterns to those wishing to learn more.

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

Register: Click here to register!

This Months Sponsor:

TBA

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:

RichmondSQL

Thursday, April 11th, 2012, 6:30 PM - 8:00 PM

Speaker: Kevin Hazzard

March 7th, 2012, 6:30 PM - 8:00 PM

Speaker: Steve Jones

RichmondSQL

Paul Oster - Thursday, December 13th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group

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

SQL Server and XML Imports and Exports

Paul Oster

RSSUG Codeplex Project - Thursday, November 8th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group

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

RSSUG Codeplex Project

Wayne Sheffield - Thursday, October 11th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group

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

Table Vars & Temp Tables – What you NEED to Know!

RSSUG Codeplex Survey Results

Jessica M. Moss - Thursday, September 13th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group

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

Who:

Carlos Chacon - Thursday, August 5th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group

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

Andy Leonard - Thursday, July 19th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group - July 2012

When: Thursday, July 19th, 2012, 6:30 PM - 8:00 PMSocial Time starts at 6:00 PM!

Jennifer Kenny - Thursday, June 14th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group - June 2012

When: Thursday, June 14th, 2012, 6:30 PM - 8:00 PMSocial Time starts at 6:00 PM!

Round Table - Thursday May 10th, 2012, 6:30 PM - 8:00 PM

Richmond SQL Server User Group Round Table

Steve Fibich - Thursday, April 12th, 2012

SQL Development Tips and Tricks to become a more efficient DBA/Developer

Wayne Sheffield - Thursday March 8th 2012

Windowing Functions in SQL Server 2012 by Wayne Sheffield!

When: Thursday, March 8th, 2012, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Wayne Sheffield

Register: Click here to register!

Kevin Griffin - Thursday, February 9th, 2012

Kevin Griffin - Windows Azure!

When: Thursday, February 9th, 2012, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Kevin Griffin

Register: Click here to register!

Geoff Johnson - Thursday, January 12th, 2012

Geoff Johnson - Common Table Expressions!

When: Thursday, January 12th, 2012, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Geoff Johnson

Register: Click here to register!

Thursday, December 8th, 2011 - Richmond SQL Round Table!

RichmondSQL Round Table!

When: Thursday, December 8th, 2011, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Roundtable featuring RichmondSQL Leadership! Your leadership, your questions. It should rock!

Register: Click here to register!

RichmondSQL

Wayne Sheffield - Thursday, September 8th, 2011

Wayne Sheffield - Avoid the RBAR!

When: Thursday, September 8th, 2011, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Wayne Sheffield

Jennifer Kenney - Thursday, August 11th, 2011, 6:30 PM - 8:00 PM

Jennifer Kenney - Building A SQL Rules Engine

When: Thursday, August 11th, 2011, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Jennifer Kenney

Andrew Kelly - July 14th, 2011, 6:30 PM - 8:00 PM

Andrew Kelly - Understanding Indexes in SQL Server 2008

When: Thursday, July 14th, 2011, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Andrew Kelly (MVP)

Grant Fritchey - June 9th, 2011

Grant Fritchey (the Scary DBA himself) presents Reading Execution Plans, the Deep Dive

When: Thursday, June 9th, 2011, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! Who: Grant Fritchey

February 10th, 2011, 6:30 PM - 8:00 PM

Steve Fibich presents Practical Change Data Capture

January 13th, 2011, 6:30 PM - 8:00 PM

December 9th, 2010, 6:30 PM - 8:00 PM

Andy Leonard presents SSIS Design Patterns (from his PASS Summit 2010 Spotlight Session)

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

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

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

Bob Lambert presents Normalize Metadata for Data Integration Analysis!

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

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

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

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

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

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

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

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

Who:
Wayne Sheffield

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

Who:
Kevin Griffin

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

Who:
Geoff Johnson

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

Who:
Roundtable featuring RichmondSQL Leadership!
Your leadership, your questions. It should rock!

When: Thursday, September 8th, 2011, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Wayne Sheffield

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

Who:
Jennifer Kenney

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

Who:
Andrew Kelly (MVP)

When: Thursday, June 9th, 2011, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!

Who:
Grant Fritchey