RichmondSQL

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:

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

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.

RichmondSQL

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!

VACO

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

Register: Click here to register!

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

Register: Click here to register!

SQLPeople

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)

Register: Click here to register!

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

Register: Click here to register!

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!

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

Mark Hudson presents An Introduction to Report Builder 2.0

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

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

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

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

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

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

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

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

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

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

Presentation from RSSUG Meeting Thursday, January 15th, 2009, 6:30 PM - 8: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