SQL Saturday #90
We are pleased to announce that that OKC is going to be the host of SQL Saturday #90!
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Aug 27 2011 at Moore Norman Technology Center (13301 South Pennsylvania Avenue, Oklahoma City, OK 73170). Admittance to this event is free, we will provide an optional box lunch for $10 (not pizza.) Please register soon as seating is limited, and let friends and colleagues know about the event.
We are, currently, planning for a 3 track, 250-person event. The expected tracks are Database Administration, Developer, and Business Intelligence.
Steve Jones from SQLServerCentral.Com is, currently, scheduled as our keynote speaker.
Website: http://sqlsaturday.com/90/eventhome.aspx
We hope to see you there!
-OKC SQL
August 2011 Meeting
Here is the URL for this talk as it was done at SQL Saturday #63 : http://midnightdba.itbookworm.com/EventVids/SQLSAT63CurseInterview.wmv
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 How to curse in interviews and will cover:
This session will take a hard look at different things that happen in interviews and give you what you need to know to get that next job. This isn't a recruiter session that'll tell you to wear a tie and smile. I'm a real Sr. DBA who hires DBAs all the time. I'm going to tell you what we look for in a DBA, and the types of things you should and shouldn't say. I'll show you how to pass a tech screening and get past the HR portion as well. Your mama can teach you how to dress. I'm gonna teach you how to get hired. You seriously can't afford to miss this discussion because it'll be the most candid anyone will ever be with you about interviews. This will be a fun and very interactive session. And yes, you will be exposed to some pottymouth... it's in the title.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, August 8th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
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
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
Mailing List Sign Up
Sponsors
