May 2011 Meeting
The slides for Jamin's talk can are -> here.
Jamin Mace is the speaker. Jamin is a Business Intelligence Architect working as a consultant for Stonebridge Technologies. He has more than ten years of experience delivering Microsoft based solutions. Jamin specializes in delivering Business Intelligence solutions within the familiar SharePoint environment. Jamin also has vast experience in delivering data warehouse solutions in the Microsoft technology stack.
The topic is titled Introduction to PerformancePoint Server 2010 and will cover:
PerformancePoint Services (PPS) is the performance management application from Microsoft. PPS is primarily designed to deliver interactive dashboards comprised of Key Performance Indicators (KPIs), Scorecards, and Analytic Charts and Reports allowing an organization to monitor progress toward strategic objectives as well as provide lightweight analytic capabilities. Microsoft has included PerformancePoint Services as a service application with SharePoint 2010. In its 2007 version, PerformancePoint was a stand-alone server component.
In this session we will gain an understanding of PerformancePoint within the Microsoft BI stack, architecture within SharePoint 2010, and basic PerformancePoint terminology. Finally we will demonstrate usage of a PerformancePoint in a Real World Scenario for an upstream Oil & Gas company.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, May 9th, 2011 from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
April 2011 Meeting
Tim Costello is the speaker. Tim is a business intelligence developer with InterWorks inc. in Dallas, Texas. Tim is passionate about data visualization and helping people realize new insights from their data through data visualization.
The topic is titled Tableau: Self Service BI made easy. and will cover:
Rapid-fire visual analysis. Ad-hoc query capability. Easy interactive dashboard building. No, this isn't going to be a session of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau, you can help users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, April 11th, 2011 from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
March 2011 Meeting
Tim Mitchell is the speaker. Tim is a business intelligence consultant, database developer, speaker, and trainer. He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting. He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP.
The topic is titled Dirty Data? Clean It Up! and will cover:
Dirty data is everywhere, and it's headed for a database near you. Extraction, transformation, and loading (ETL) can be difficult, but often the most challenging component of that process is the validation and clean up of data. Information must be cleansed in such a way that it retains its original message and business value, while conforming to the expectations of the destination system(s). In this session, we will discuss some of the high-level challenges of dealing with dirty data, along with some infrastructure-agnostic recommended practices for doing so. Further, we will dig in and get our fingernails dirty (pun intended) on some specific ways that SQL Server Integration Services (SSIS) can be used to cleanse incoming data.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, March 14th from 6:00 p.m. - 7:20 p.m. at the at the OKC COCO Click Here for Directions
February 2011 Meeting – Schedule Change!
Please note We are meeting the 3rd monday (Feb 21st) We are changing the date for this month only due to speaker availability.
Mike Hotek is the speaker.
The topic is titled Preview of SQL Server Denali and will cover:
This session will cover some of the features and changes that are going to be in the next edition of SQL Server.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, February 21st from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
January 2011 Meeting
Richard Turner is the speaker. Richard is a .Net developer with 7+ years experience using SQL 2000/2005/2008, VS 2003/2005/2010 and many other IDEs.
The topic is titled T-SQL - out of the box and into the brain and will cover:
This session will cover some of the common and not so common operators in TSQL and how they can help you out, or sometimes just be a landmine. Topics include: The SQL 2005/2008 enhancements you may have forgotten about or could never find a practical use for. Performance difference between methods of doing things.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, January 10th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
December 2010 Meeting
Rob Sullivan is the speaker. Rob is a DBA and officer of the OKC SQL group.
The topic is titled DBA: Tools and Techniques and will cover:
Rob is going to cover some awesome tools like WhoIsActive, SQL Source Control, some CheckDB techniques, some ways to deal with developers and their ridiculous ORM's and ... time permitting, he'll even try to stuff the stocking with some NoSQL demystification. This will be a very loose and informal presentation with (hopefully) a lot of questions.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, December 13th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
November 2010 Meeting
Patrick Kurz is the speaker. Patrick is currently the Manager of Technology for Megasys Hospitality Systems and the leader of the TulsaSQL group. He has been developing applications involving MS SQL Server for over 10 years.
The topic is titled Overview of new features in SQL Server 2008 R2 and will cover:
Overview of the new features contained within R2. Learn about the upgrade options so you can make an informed decision around migration. We'll cover Report Builder 3.0, the new Datacenter and Parallel Data Warehouse editions, StreamInsight, Master Data Services, PowerPivot for Sharepoint, Data-Tier Application (DAC), MultiServer Dashboards and more
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, November 8th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
October 2010 Meeting
Jason Cameron an Applications System Administrator for Chesapeake
Energy and Kristin Ferrier President of OKC SQL will be speaking.
Jason will be discussing Data Driven Subscriptions using SQL-RD and Kristin will be speaking on Time Calculations in SSAS 2008
In Kristin's presentation we'll discuss a variety of methods for adding time
calculations (Yr/Yr Growth %, Prior Period, etc.) into your SSAS 2008
cubes. We'll discuss the pros and cons of each, plus, implement a few of
the methods.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, October 11th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
September 2010 Meeting
Rob Sullivan, VP of OKC SQL will be speaking.
The topic is titled SQL CLR: From Start to Fun-ish and will cover:
We are going to cover what SQL CLR is and how to get started with it. After that bit, we're going to turn up the gas and take a look at how we can really extend SQL Server with it.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, September 13th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
August 2010 Meeting
Bryan Smith, with Microsoft will be speaking.
The topic is titled Intro to PowerPivot and will cover:
PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. Join Bryan Smith for an exploration of this incredible technology and how it can be used to address your organization's business intelligence needs.
In addition to Bryan, Todd Rosenthal from GDH Consulting will be speaking on Phone Interviewing and General Interviewing.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, August 9th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
Mailing List Sign Up
Sponsors
