Avatar of Alvin Ramard

by Alvin Ramard

An SSIS Challenge From Brian Knight

January 19, 2012 in Uncategorized

An SSIS Challenge From Brian Knight

Prove your SSIS skills by besting the experts at Pragmatic Works! This Whitepaper is designed to help you map a technical SQL Server Integration Services (SSIS) solution to a business problem. To do this, we give you a business problem to solve with loose requirements. You can then solve it however you wish inside of SSIS as long as you meet the requirements. We provide hints on how to solve the problem and if you need some more help, you can read the high-level step by step instructions. Good luck!

Download the Challenge Now!

Knight's 24 Hour Trainer

What you’ll learn:

  • Learn how to use the Pivot transformation
  • Learn more about using expressions
  • Learn more about the Lookup transformation
  • Learn more about the Derived Column tranformation
  • Learn more about the Conditional Split transformation

Download the Challenge Now!

Number of View :34

Tags: No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Jan 12th Meeting – Dan Evans – Knight’s 24-hour Business Intelligence Trainer – Section VI – SharePoint

January 2, 2012 in Meetings

When: Thursday, Jan 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Jan 12th, as Dan Evans walks us through Section VI of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer and shows us how Microsoft SharePoint fits in the BI environment.

Abstract:
This month we will be wrapping up the review of the 24-Hours of BI with the final section on SharePoint BI. Come learn the main concepts of SharePoint as they relate to your BI efforts. See how to deploy SSRS reports and create Dashboards in PerformancePoint. You can view how Excel services can help your BI efforts and maybe even see some neat things with PowerPivot. We’ll also highlight some basic security and administration features within SharePoint so you can maximize your investment in Microsoft technologies.

Bio:
Dan Evans is the Director and Market Lead for the Americas Business Intelligence Service Line at Avanade, Inc. He benefits from 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel promotes technology for business use through various channels by sponsoring user groups like The Data Warehousing Institute (TDWI) Mid-South Chapter, the Mid-South Data Management Association (DAMA) chapter and is founder and acting president of the Memphis Professional Association of SQL Server (PASS) chapter. Dan holds several MCPs in SQL Server and SharePoint and is Certified Business Intelligence Certification (CBIP) with Mastery in Leadership and Management, Business Analytics, Data Analysis and Design and Data Integration. Daniel is a nationally recognized speaker at TDWI, TechEd and PASS on topics related to SQL Server and SharePoint.

Register for Knight's 24-hour Business Intelligence Trainer - Section VI - SharePoint in Memphis, TN on Eventbrite


Number of View :33

Tags: , , , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Dec 15th Meeting – Douglas Johnston – SQL Server Denali (SQL Server 2012)

November 27, 2011 in Meetings

When: Thursday, Dec 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Abstract:
This month, Douglas Johnston introduces the new version of SQL Server, codename Denali.  From T-SQL additions to the new Integration Services designer, from Master Data Services to the new Visual Studio project types, he will walk through a real-world example of each.  As Douglas is also currently implementing all of these for a client, he will also demonstrate the pitfalls and bugs of the pre-release software.  If you are considering upgrading to SQL Server 2012, this session will give you great information on what the benefits and the risks are.

Bio:
Douglas Johnston is a Group Manager in the Business Intelligence & Collaboration Service Line of Avanade. With 10 years of experience with SQL Server and business intelligence tools, in industries as diverse as healthcare, financial services, defense and energy utilities, he has become one of the leading contributors to the Avanade BI community. He advises on, and develops projects with, aspects of database development, performance tuning, architecture, warehouse design and management, high availability, ETL and reporting systems. He is also a founding member of the peer-nominated Avanade Expert Network and holds several Microsoft certifications.

Before becoming a database ninja, Douglas developed with VB6, Perl, Oracle, Business Objects and J2EE, as well as some other really terrible technologies. He has particularly desiccated sense of humor to go with the British accent, owns a kilt, and likes monkeys.

Register for Memphis PASS Chapter Meeting - Douglas Johnston – SQL Server Denali in Memphis, TN on Eventbrite


Number of View :39

Tags: , , , No Comments »

Avatar of Jim Houchin

by Jim Houchin

SQL Server 2012 RC0

November 17, 2011 in Notices

MS SQL 2012 RC0

MS SQL 2012 RC0

Just letting everyone know it appears SQL Server 2012 RC0 is out! Hope you guys enjoy it as much as I do!

http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

 


Number of View :9

No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Nov 10th Meeting – Dan Evans – 24-hour Business Intelligence Trainer – Section 3 – SSAS

November 6, 2011 in Meetings

When: Thursday, Nov 10th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Nov 10, as Dan Evans walks us through Section III of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer as we look at SQL Server Analysis Services (SSAS) in the BI environment.

Abstract:
For this month’s meetinng, we’ll be going over Section III of the Knight’s Microsoft Business Intelligence 24-Hour Trainer about SQL Server Analysis Services (SSAS).   We’ll show the major components of SSAS including Data Sources, Dimensions and basic MDX expressions.  You’ll see how these points are aplied using the SSAS project and the Cube Wizard.  Come learn what SSAS is an what it can do for your Business Intelligence (BI) projects!

Bio:
Dan Evans benefits from almost 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel is an MCP and is a TDWI Certified Business Intelligence Professional (CBIP) with Mastery in Leadership and Manager, Business Analytics, Data Analysis and Design and Data Integration.


Number of View :16

Tags: , , , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Oct 13th Meeting – Steve Anderson – 24-hour Business Intelligence Trainer – Section 4 – SSRS

October 8, 2011 in Meetings

When: Thursday, Oct 13th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Abstract:

Join us on Thursday, Oct 13t, as Steve Anderson walks us through Section IV of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer.  We will be taking a look at SQL Server Reporting Services (SSRS) in the Business Intelligence environment.

Bio:

Steve Anderson is a database and analytics professional who received a Master of Engineering Management degree from Christian Brothers University and a Bachelor of Science in Computer Engineering from The University of Memphis. Mr. Anderson specializes in: Database Marketing, Data Analysis, Data Warehousing, Report Development & Business Intelligence. His expertise expands across several industries – sports, entertainment, financial services, gaming, and retail.


Number of View :13

Tags: , , , , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Sept 15th Meeting – 24-hour Business Intelligence Trainer – Session 3

September 14, 2011 in Meetings

When: Thursday, Sept 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us for our third session from “Knight’s Microsoft Business Intelligence 24-hour Trainer“.

Abstract:

If everything works out as we hope, our own Dan Evans will lead a session covering Section III about SQL Server Analysis Services (SSAS). Come learn the fundamentals of SSAS concepts and how to apply SSAS to your BI/DW environment. Understand how to build and deploy a cube, edit dimensions and measures and play around with some MultiDimensional eXpressions (MDX).

If Dan is not able to join us, I will continue from our last session and go over examples of how you might go about loading dimension or fact tables using SSIS.


Number of View :20

Tags: , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

Aug 11th Meeting – Jim Houchin & Alvin Ramard – 24-hour Business Intelligence – SSIS

August 6, 2011 in Meetings

When: Thursday, Aug 11th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Abstract:

Join us on Thursday, August 11th, as Jim Houchin and Alvin Ramard take us through the second section of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer. This meeting will cover Section II: SQL Server Integration Services. The session will be a mixture of presentation and demonstrations to provide an overview of SQL Server Integration Services (SSIS) and how it can be used in your business intelligence and data warehouse process.

Bios:

Jim Houchin

Jim Houchin has over ten years of experience in software design, development, and implementation, of web and database
applications, with a touch of QA. Jim’s focus for the last year has been as a DBA at Yusen Logistics concentrating on SQL administration and maintenance on SQL 2000, 2005 and 2008R2. Jim also has a strong desire to learn new technologies and he is eager to share information.

Jim Houchin is a Vice-President of the Memphis PASS Chapter.

Alvin Ramard

After working for 14 years as an electrical engineer, Alvin Ramard returned to school to pursue a career in Information
Technology.  Alvin has almost 12 years of experience working mainly with SQL Server 2000, 2005, 2008, and 2008R2, with
strong focus on ETL and BI.  Alvin also has a strong desire to learn new SQL Server technologies and he is enjoys sharing this information with other SQL Server enthusiasts.

Alvin Ramard is a co-founder and a Vice-President of the Memphis PASS Chapter.

 


Number of View :41

Tags: , , 1 Comment »

Avatar of Alvin Ramard

by Alvin Ramard

July 14th Meeting – Dan Evans – 24-hour Business Intelligence Overview

July 2, 2011 in Meetings

When: Thursday, Apr 14th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, July 14th, as our own Dan Evans gives us an introduction to Data Warehousing and Business Intelligence.

Based on the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer, come learn the essence of developing BI/DW solutions using industry best-practices and leverage your investment in SQL Server. This meeting will cover Section I – Data Warehousing and Business Intelligence fundamentals including key concepts and data modeling. The session will be a mixture of presentation and demonstrations.

Dan Evans benefits from almost 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel is an MCP and is a TDWI Certified Business Intelligence Professional (CBIP) with Mastery in Leadership and Manager, Business Analytics, Data Analysis and Design and Data Integration.


Number of View :24

Tags: , No Comments »

Avatar of Alvin Ramard

by Alvin Ramard

User Groups? Those Still Exist? They Do, and You Should Be Going To One

June 24, 2011 in User Groups

Did you ever ask yourself why you should get involved with local user groups? Why waste your personal time? Why drive out of your way?

See what Jes Schultz Borland, Database Administrator at Kimberly Clark, had to say on the subject.

User Groups? Those Still Exist? They Do, and You Should Be Going To One


Number of View :31

No Comments »

Switch to our mobile site