Colorado Springs SQL Server Users Group

Next Meeting

Wednesday,

June

20

June SSUG Meeting

  • In-Person @ 503 West Garden of the Gods Road Colorado Springs, Colorado, United States (map)
  • 17:30 - 20:00 Mountain Daylight Time
  • Add to your Calendar: iCal
  • Language: English
  • RSVP: None

We invite you to join us for our monthly meeting at the Hyatt Place - 503 W. Garden of the Gods Rd sponsored by TekSystems. This month we're pleased to feature our 101 presentations " GraphQL" with Isak Sky followed by our main presentation, " Bye Bye Cursors!", with Lynn Pettis.

When: 5:30 PM to 8:00 PM

Where: Hyatt Place - 503 W. Garden of the Gods Rd

What: We'll begin with networking and a delicious dinner from 5:30 to 6:00 PM. At 6:00, we'll have a few announcements and peer Q&A time followed by our main presentation. After the presentations, we'll move to the hotel lounge for socializing and additional networking time. The CSSUG provides two drink tickets - relax with a coffee, soda, or beer (or two) while you network.

Our 101:

GraphQL

Isak Sky

GraphQL is a query language for APIs and a runtime for fulfilling those queries with your existing data.

In the talk, I will:

* Give an introduction to GraphQL

* Go over some use cases

* Discuss some approaches for exposing a GraphQL interface backed by SQL Server.

* Show a demo

About Isak:

Isak Sky works at Xledger USA. He is a full stack developer with a background in economics.

 

Featured Presentation:

Bye Bye Cursors!

Lynn Pettis

How many times have you been faced with tuning a stored procedure or SQL script that had one or more cursors being used to accomplish a processing task? When originally written this procedure or script may have been running with little problem. Part of this may have been due to poor testing using a small data set or it could have been fine when first put into production but the data volume has increased and the procedure didn't scale with the increased data. In this presentation we will start with a cursory look at cursors in SQL Server, basically what are the options that can be used. I will also show you the type of cursor I use when one is called for to complete a task. And, before getting to meat of the presentation, I will also show you how some people try to eliminate cursors. Once this is done, I will then show you a few of the principles and techniques you can use to start replacing cursor-based approaches to solving problems with set-based approaches. Some of these may be obvious, especially if you have been working with SQL Server for a while, but if you are new to SQL Server what you will learn may change how you approach working with SQL Server.

About Lynn :
Lynn Pettis is currently a Database Administrator and Developer at Polaris Alpha, LLC (formerly Intelligent Software Solutions, Inc.) where he has been working for over six years. He is also currently the VP of Marketing for the Colorado Springs SQL Server Users Group. He has been working with Microsoft SQL Server for over twenty years having started with SQL Server 6.5. He is also a valued and respected contributor on SQLServerCentral.com.

Main Meeting:

Recurring: 3rd Wednesday of the month.

Time: 5:30 PM to 8:00 PM
Where: Hyatt Place - Garden of the Gods

Description: This meeting starts with free food and networking. Then we have a quick 101 session followed by our main presentation. After the presentations, we move to the hotel bar for more networking. Two drink tickets are provided by the club for the after hours networking.


Lunch Meeting:

Recurring: 1st Friday of the month.
Time: 12:00 PM to 1:00 PM
Where: Hacienda Colorado

Description: This is a monthly meeting for the group's members to get together outside of our normal meeting structure. A great chance to network with other members.

RSVP Required: We need to have an accurate count for the restaurant. Look for monthly emails or this webpage for the actual Meetup link.

Cost: ($10 - $15) Springs SQL does not cover the cost of lunch.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids