in

RichmondSQL

Richmond SQL Server Users Group

events

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

    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

     

    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

     

    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

    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

     

    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

     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

     

    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

     

    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

    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

     

    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

    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

     

    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

     

    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

     

    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

    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:

     

More Posts Next page »
©2006-2011 Richmond SQL Server Users Group; ©2008-©2011 Richmond User Groups Corporation
Powered by Community Server (Non-Commercial Edition), by Telligent Systems