February 2012 Meeting
Tobias Ternstrom is our PASS Summit recorded speaker. Tobias, who is a program manager for Microsoft gave this talk at the SQL PASS Summit and we have the recording to share with our group. If you have been to the PASS Summit, then you likely know the quality of these presentations. If you have not been, then this meeting could be a good introduction into the level of information presented at events like SQL Rally and the PASS Summit. The title for the talk is:
What is New for T-SQL in SQL Server Code Name "Denali" & SQL Azure and will cover:
Using his role as a Lead Program Manager managing a team of program managers who own the engine-side of the SQL Server & Azure development experience, Tobias, will impart his knowledge on expected features of SQL Server 2012. With his areas include T-SQL language, type system, libraries as well as the data-tier application model, this is sure to be an informative talk from an incredibly knowledgeable source.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, February 13th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
January 2012 Meeting – Jan 16th
Grant Fritchey, renown SQL Server Author/Presenter, is our remote speaker. Grant is a former SQL Server MVP and writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. he has published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” He is one of the founding officers of the Southern New England SQL Server Users Group and it’s current president. When not slaving away over books or at Red Gate. Grant also work on part-time, short-term, off-site consulting contracts.
Seven Ways To Fix Bad Parameter Sniffing and will cover:
Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad. In this session we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then, we’ll explore how parameter sniffing can go wrong and I’ll show you seven different ways you can deal with it when it does. You’ll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, January 16th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
December 2011 Meeting
Jen McCown, hugely popular speaker at SQL Saturday Oklahoma City this past August, is our remote speaker. Jen is a SQL Server MVP, Co-Host of the popular MidnightDBA postcast, author, community leader and all around educator of masses..
T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code (aka Forgotten T-SQL) and will cover:
You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool, and that FOR XML isn’t as scary as it looks. And what’s more, we’ll look and BRAND-new features like SQL Server Denali’s new SEQUENCE object! This session is chock full of code examples, including before-and-after demos and how-to illustrations.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, December 12th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
November 2011 Meeting
Ernesto Fernandez is the speaker. Ernesto is a Senior Software Engineer at RelayHealth. He has been working there for the past 10 years in product development with various versions of SQL Server & .Net. Ernesto has been an officer in both the Tulsa SQL and Tulsa .Net User Groups. He has presented several database-related topics to regional user groups. Ernesto, also, has experience as a consultant working with several multinational firms.
The topic is titled Database unit testing using Visual Studio 2010 and will cover:
Learn about the different features in Visual studio that allows you to do database unit testing, the advantages and limitations it can bring to your projects.
Visual Studio offers different tools that can assist and complement while working on database projects, during development and deployment to mutiple environments.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, November 14th from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
October 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 SQL Saturday speaker.
The topic is titled Team Based Development and will cover:
Ready to learn how to do team database development like a rock star? Using both products and process, you'll see how to manage and deploy schema and code with complete confidence. From source control, to testing, to deployments... we'll see how to change release night from a pile of ulcers into a round of high fives.
The room is sponsored by GDH and no food will be provided. The meeting will be held Monday, October 3rd from 6:00 p.m. - 8:00 p.m. at the at the OKC COCO Click Here for Directions
September 2011 No Meeting
We will not be having a meeting in September due to SQL Saturday #90 being so close in time to our usual meeting date.
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
Mailing List Sign Up
Sponsors
