July 2011 Meeting
Rob Sullivan is the speaker. Rob is a DBA and officer of OKC SQL. He is also the token DBA on This Developers Life, SQL Author for Tekpub, open source contributor to .NET Micro ORMS and PASS speaker.
The topic is titled An hour in the life as the DBA for StackOverFlow.com and will cover:
We've have just been hired as the temp DBA or developer for a website getting hammered by users. Our job is to figure out what is wrong with the site and fix the system. Server settings, memory pressure, disk configurations, index options - we run the gauntlet of fixing a SQL Server built by AppDevs that has just run into a wall of web scale. This presentation is geared towards both database administrators and developers interested in improving the performance of website applications running against SQL Server databases. We'll be using the StackOverFlow.com data dumps as our real world scenario.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, July 11th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
June 2011 Meeting
Sean McCown is the speaker. Sean McCown holds a double MCITP in SQL Server 2008 for both Administration and Development. He is also a SQL Server MVP with over 15yrs experience in databases. Sean is a Contributing Editor with InfoWorld Magazine and a frequent contributor to many community sites and forums. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight. Sean also speaks a various SQLSaturday events and is a board member of his local user group, NTSSUG.
The topic is titled The Backup Tune-up and will cover:
Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success with it.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, June 13th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
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
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
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
July 2010 Meeting
This meeting has been rescheduled for Monday July 12th.
Tim Mitchell, a Microsoft SQL Server consultant, developer, speaker, and trainer will be speaking.
The topic is titled SSIS Scripting and will cover:
In this session, we will explore the Script Task and Script Component tools within SSIS. Learn how to break out of the traditional flat-file ETL mold and, using VB.NET or C#, create custom scripts to address unconventional transformations and related tasks. We'll also discuss other possible uses of script in SSIS, with several practical examples.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, July 12th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
Mailing List Sign Up
Sponsors
