New SQL User Group in Wheeling, West Virginia’s first meeting is January 20th

If you caught my last blog post and reached the bottom of the page then you noticed that we are starting the first SQL Server User Group in West Virginia.   Last year we hosted our first SQL Saturday and drew interest for a user group.  I have teamed up with a few local friends and we are excited to see where our user group goes.

If you would like to attend our first meeting click here to signup so we will have pizza for everyone.

The Mission

The mission of the Wheeling SQL Server User Group is to provide an opportunity that will allow database developers, database administrators and all other IT professionals who work with databases to connect, share and learn for free. While everyone’s shop might be unique the majority of the DBA’s have similar projects and problems. We will allow all attendees the opportunity to share their experiences while they can also build their soft skills.

Our First Meeting

Our first meeting will be held on January 20th, 2011.  Everyone who attends will be an instant winner as there will be free pizza and free membership to the coolest organization for SQL Server Professionals. We are excited to have Jose Chinchilla (blog | @SQLJoe) speak. The following is our agenda:

  • 6:00pm to 6:15pm – Network and eat free Pizza
  • 6:15pm to 6:30pm – Establish a few goals for the group and eat more free pizza
  • 6:30pm to 7:30pm – The Main Event (Learning SSIS under 1 hour)

Abstract:

Need to know what is the corresponding SSIS transformation or task to a specific T-SQL statement? How do you accomplish Unions, Joins, and Merges in SSIS? How do you do CASE statements in SSIS? How do you group and aggregate data in SSIS? In this session I will cover the some of the most important SSIS control flow and data flow tasks to jumpstart DBAs and Developers into SSIS with SQL Server 2008-R2. At the end of this interactive demo, you will be able to identify what control flow tasks and data flow transformations can be used in place of T-SQL statements and scripts. I will also cover how to accomplish in SSIS:
• Basic SELECT, INSERT, DELETE, UPDATE statements
• Inner and Outer joins
• CAST and CONVERT
• CASE statement • Sorting, Grouping and Aggregate functions (SUM, COUNT, MAX, AVG)
• MERGE and Unions
• Loops (WHILE) and more

Bio:
Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Developer working as a BI consultant for a Tampa based full service consulting firm. Jose has12+ years of experience in IT and has focused his career in OLTP and OLAP database design, development and administration and specializes in ETL/ELT, Data Warehousing and Multidimensional Analysis using SQL Server 2008 BI tools. He is also the current president of the Tampa Bay area Business Intelligence User Group and Official PASS Chapter. He is an avid twitterer under the @SQLJoe handle and blogs at http://www.sqljoe.com.