OKCSQL Oklahoma City SQL Server Developers Group

14May/130

PASS Summit 2013 Discount Code

If you are interested in attending the PASS Summit this year in Charlotte, be sure to take advantage of our chapter discount code "SUM235CH". This should give you up to $150 off your registration.

Filed under: Events No Comments
8May/131

May 2013 Meeting

Kristin Ferrier is our speaker. Kristin Ferrier is a data and analytics enthusiast with nearly a decade of SQL Server experience and four years Oracle experience. She loves her job as a Senior Data Analyst at Devon Energy and is Co-Founder and President of OKCSQL. Regional speaking credits include Tulsa Tech Fest and SQL Saturday Dallas.

The title for the talk is: 3D Geospatial Visualization Using GeoFlow and will cover:

Learn what GeoFlow is and how to use it for 3D visualization of data that can be time-stamped. You can create static charts or interactive animated tours. GeoFlow is one of Microsoft’s latest releases in the BI spectrum.

Kristin's talk is going to prime the pump for an open discussion that will follow her short talk. So come with questions, ideas or any solutions you've found lately you want to share. Everything (not just BI) is on the table!

When: May 13th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: GDH Offices
1111 N Walker Ave
Oklahoma City, OK 73103
Directions link: Click Here

Filed under: Meetings 1 Comment
1Apr/130

April 2013 Meeting

Jen McCown is our remote speaker. Jen McCown is an independent consultant, Microsoft SQL Server MVP awardee, developer and DBA. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs@Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She has presented at multiple SQL Saturday and 24 Hours of PASS events, PASS Summit 2010 and 2012, PASS SQLRally 2011, and SQLBits 2012. She lives in Dallas, Texas in the vicinity of approximately 6.5 million other humanoids.

The title for the talk is: When a Strange Server Calls: Getting to Know a SQL Instance and will cover:

Have you checked the databases lately? It could be that you’re new on the job, or you’ve inherited a set of servers from another team. Maybe things have just been busy lately. Any which way, you’ve got a SQL Server instance (or five) that may have issues, may have backups, may have maintenance…or not. How do you start getting to know an instance? We’ll go over scripts and methods to gather and prioritize important information about your server, so you don’t have to be afraid when the server calls.

When: April 08th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: GDH Offices
1111 N Walker Ave
Oklahoma City, OK 73103
Directions link: Click Here

Filed under: Meetings No Comments
5Mar/130

March 2013 Meeting

Allen Smith is our in person speaker. Allen Smith is a business intelligence and data warehouse consultant, speaker and trainer. Allen has an MBA in Computer Sciences and has worked in database services and data warehousing since 1998. Allen has a MCTS certification in Business Intelligence. Allen is a principal consultant at Cognitive Information Inc., a consulting firm in Edmond, OK. He enjoys sushi, traveling to obscure places, fixing Rubik's cubes and prefers Marvel over DC.

The title for the talk is: Sharing Data in SharePoint and will cover:

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL table as a 'List' in Sharepoint. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we share a PowerPivot analysis built off our SQL data.

When: March 11th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: GDH Offices
1111 N Walker Ave
Oklahoma City, OK 73103
Directions link: Click Here

Filed under: Meetings No Comments
6Feb/130

February 2013 Meeting

This month, we are going to be talking about all things automation. Rob Sullivan is going to be doing a quick presentation on automating SQL Server installation and the concept of infrastructure as code. Once he is done, we will engage in group discussion on ways you all are trying to automate process at work or questions you might have getting started with automation under certain conditions.

The title for the talk is: Let's Automate Everything and will cover:
 
A key to being a good DBA/Dev/BI Professional is being able to automate everything you can so that you can focus on tasks that really matter. One of the often overlooked tasks is automating your SQL Server installs and configuration. Taking it another step further, your team's entire process starts to change when you can introduce the concept of 'Infrastructure As Code' which is basically automated repeatable server configuration based on what is in source control. Lastly, I'm stuck in the OLTP/Web world which means I'm really curious about how Business Intelligence people automate tasks or those not doing web stuff. So join me in the group discussion where we can all ask or share about automation solutions and tricks.

When: February 11th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: GDH Offices
1111 N Walker Ave
Oklahoma City, OK 73103
Directions link: Click Here

Filed under: Meetings No Comments
10Jan/130

January 2013 Meeting

Ryan Adams is our in person speaker. Ryan has worked for a Fortune 100 company for 14 years. He is the sole SQL Server DBA for his group. His primary focus is database design and performance, but also works with SSRS and SSIS. He enjoys being involved in the SQL community and serves on the Board of Directors for the North Texas SQL Server User Group and is President of the PASS Performance Virtual Chapter. He also serves as a Regional Mentor for PASS and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP.
The title for the talk is:

How Active Directory Affects SQL Server and will cover:

There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers. Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent. We’ll discuss how the location of your server in AD is important, how security can be compromised, AD DNS configuration, and of course Kerberos. By the end of the session you’ll have a check list of things to discuss with your domain administrator when you return to work. This includes the biggest perpetrator, Group Policy Objects.

When: January 14th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: GDH Offices
1111 N Walker Ave
Oklahoma City, OK 73103
Directions link: Click Here

Filed under: Meetings No Comments
5Dec/120

December Meeting

Allen Smith is our in person speaker. Allen Smith is a business intelligence and data warehouse consultant, speaker and trainer. Allen has an MBA in Computer Sciences and has worked in database services and data warehousing since 1998. Allen has a MCTS certification in Business Intelligence. Allen is a principal consultant at Cognitive Information Inc., a consulting firm in Edmond, OK. He enjoys sushi, traveling to obscure places, fixing Rubik's cubes and prefers Marvel over DC.
The title for the talk is:

SSIS Configurations Vs. Parameters and will cover:

In this session, SQL Santa (Allen) will review configurations in SQL 2008R2. These options allowed dynamic configuration across environments. Next, we look at SSIS 2012 and the new dynamic options, including Parameters, Expressions and Variables. This upgrade takes SSIS from simply confusing to downright confounding. We will simplify these options so any elf in the workshop can follow along.

Before Allen's talk, Rob Sullivan is going to be filling your stockings with a quick rundown of some cool trace flags.

When: December 10th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: GDH Offices
1111 N Walker Ave
Oklahoma City, OK 73103
Directions link: Click Here

Filed under: Meetings No Comments
6Nov/120

November Meeting

Jamin Mace is our in person speaker. Jamin is a BI Practice Manager for Stonebridge. Stonebridge is an information technology consulting firm headquartered in Tulsa that focuses on helping organizations get better results from their people, processes and technology. Jamin has been with Stonebridge specializing in Business Intelligence for the last 5 years and has been working with SQL Server since 2000. He has been an employee and consulted at a number of prominent companies in the Oklahoma city area including Sonic, Love’s Travel Stops, and Chesapeake Energy. Jamin holds multiple certifications including MCT, MCITP BI 2008, and MCTS SQL 2008 Database development.
The title for the talk is:

Analyzing SQL Saturday OKC attendee data with PowerPivot and PowerView and will cover:

We will be taking a tour of features self-service capabilities of PowerPivot and PowerView to analyze and perform data exploration for SQL Saturday OKC data. We will build a PowerPivot model, optimize it for Powerview, and build a rich, presentation ready dashboard. The session will be heavily focused on demonstration and will encourage interactive questions and discussion.

When: November 12th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: GDH Offices
1111 N Walker Ave
Oklahoma City, OK 73103
Directions link: Click Here

Filed under: Events No Comments
19Jul/120

August 2012 Meeting

Philip Freeman is our in person speaker. Philip is a Consultant for Stonebridge for approximately 5 years. He's been working with databases of various types since 1997. His concentration leans more towards database administration but also includes development and currently Business Intelligence. He's done work for clients here in OKC, Tulsa, Houston and Dallas. In addition to the above, Philip is certified in SQL 2005(MCTS), SQL 2008 (MCITP) and SQL 2012 Database Administration.
The title for the talk is:

SQL Server 2012 AlwaysOn and will cover:

This presentation is an illustration of what it takes to connect all of the components of AlwaysOn. I start with 4 vms and walk you through most of the way through getting this feature to work correctly. Then give you an illustration on where to connect your apps with a single connection string.

When: August 13th - 6:00pm - 8:00pm

Food and Drinks will be provided by GDH

Location: OKC CoCo
704 W. Sheridan Ave
Oklahoma City, OK, 73102
Directions link: Click Here

Filed under: Meetings No Comments
5Jul/120

SQL Saturday #125 and Joe Celko in OKC!

SQL Saturday #125 in OKC SQL Saturday is back in town on August 25th and it is going to be bigger and better than ever. Spots are filling up quickly so register as soon as possible to make sure you can attend.

SQL with Style class by Joe Celko Whether you do Oracle, SQL Server or Postgres, you won't want to miss Joe Celko as he brings his gigantic SQL brain to help you learn. This even also has limited seating so sign up to make sure you have a spot at this rare educational event here in town.

Filed under: Events No Comments