Login  |  Register
Colorado Springs SQL Server User Group
You are here :: Home Wednesday, April 23, 2014

Springs SQL Events

Saturday, April 12th

SQL Saturday #104
Saturday, January 7th, 2012

SQL Ski Trip
Sunday, January 8th, 2012


Next Meeting Minimize  
Date Published - Thursday, April 10, 2014

Note: The April meeting has been cancelled due to SQL Saturday #297. 

Please join us on Saturday, April 12th, for what may be our best SQL Saturday yet! 

Location: 1628 West Bijou Street, Colorado Springs, CO 80904

This year we will be having a western theme with games like SQL Rodeo and others with lots of Great Prizes as well as all of our great speakers and sponsors! We are proud to have MicrosoftDell, and Xtivia as major sponsors. Microsoft's own Kevin Cox will be delivering our keynote as well as presenting!

In conjunction with the event, we are having a food drive to benefit the Westside Cares food pantry, which is located at the facility where the SQL Saturday event will take place. Our goal is simple - to collect so much food and groceries that they literally have to put up additional shelving to hold it all! There will be giveaways tied directly to participation in the food drive - the more you bring, the more chances you will have. 

We have a lot of great sponsors who will be supplying us with plenty of SWAG, but for this event, they've really kicked it up a notch! For example, Xtivia has provided one of the coolest prizes we've ever seen for a SQL Saturday - a signed AC/DC guitar complete with certificate of authenticity! Dell computers has also generously supplied us with a Dell Tablet to give away. 

Bring at least one item to receive a single ticket for the SWAG drawing. Or, go big and bring one or more grocery bags of items to receive 5 tickets for the SWAG drawing. (Remember to stick around for the closing - you must be present to win!In the end, this food drive is about giving back to our community. We hope that everyone will open their hearts and help out with a great cause. 

 

Chris Shaw even posted on his blog regarding the food drive.

To help with the food drive, please feel free to reach out to our Food Drive Organizer, Troy, at troyk@42and5.com or our team at sqlsaturday297@sqlsaturday.com.

Thank you! We look forward to seeing you there!


 

 
Date Published - Tuesday, March 04, 2014

Next Meeting: March 19th @ 5:30pm

Main Session: "Advanced Spatial Analysis: Beyond Bubble Charts" by Jason Horner

Abstract: Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!

Bio: Jason is a Microsoft Certified Master for SQLServer and has been working with SQLServer for over 10 years. He began working with SQLServer as a DBA/Application Developer in 1999, starting with version 6.5. He made the transition to delivering BI solutions in 2002 and began working with spatial data in 2008. His latest focus has been architecting large-scale spatially enabled BI solutions.

Meeting Location:

Hyatt Place - Garden of the Gods
503 West Garden of the Gods Road
Colorado Springs, CO 80909

 

 
Date Published - Wednesday, February 19, 2014

Next Meeting: February 19th at 5:30pm

Main Session: "Navigating between Oracle SQL, PL/SQL and T-SQL: The Introduction" by Marc Beacom

At one point or another, we are all faced with writing queries against different database platforms. This session will focus in on Oracle and SQL Server and review many of the similarities as well as differences between the two most popular database platforms.

We’ll go through code examples in Oracle SQL and PL/SQL and discover the T-SQL equivalent and vice. We’ll also go through a few coding scenarios such as traversing hierarchical data.

 
About Marc Beacom

Marc Beacom is Principal Architect and Owner of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees.

 

Marc is an active member of the community and has served 5 years on the board of two Colorado SQL Server User Groups (Denver and Colorado Springs), 1 year as a Regional Mentor for PASS and is currently on the boards of three Colorado nonprofit organizations; Mile High AnalyticsColorado GiveCamp and Camp To Belong Colorado.


Meeting Location:

 

Hyatt Place - Garden of the Gods
503 West Garden of the Gods Road
Colorado Springs, CO 80909

 


 
Date Published - Friday, December 27, 2013

Next Meeting: January 22nd 15th at 5:30pm

Main Session: "Using BIML as a Design Patterns Engine" by Andy Leonard

Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
 
About Andy Leonard
Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.

Meeting Location:

Hyatt Place - Garden of the Gods
503 West Garden of the Gods Road
Colorado Springs, CO 80909

 

 


 
Date Published - Wednesday, December 04, 2013

Join us for our annual Holiday Party at Old Chicago at Austin Bluffs and Academy on December 18th starting at 5:30pm! We will be in the back room reserved for large parties. Bring your family!

Old Chicago (Austin Bluffs and Academy)
4110 North Academy Boulevard
Colorado Springs, CO 80918
Marketplace At Austin Bluffs‎

Map / Directions

 
Date Published - Tuesday, November 19, 2013

Next Meeting: Wednesday, November 20 at 5:30pm

Main Session: "Getting Started with Execution Plans" by Jason Kassey

Abstract: You just received a phone call from your boss telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is under-performing, hogging resources or timing out, the first thing you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.

Bio: Jason Kassay is a database developer/administrator, web application programmer and speaker from Colorado with over 10 years of experience. He is passionate about SQL Server and performance tuning and optimization. Jason is an active member of the SQL Server community and has volunteered at events such as the Colorado GiveCamp and the Denver SQL Server User Group. When not tuning databases, Jason will most likely be found playing hockey or running.

 
   
Welcome Minimize  

We hold meetings on the third Wednesday of every month.  Our group meets at the Hyatt Place Garden of the Gods in Colorado Springs.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

5:30 - 6:00 - Networking, Food
6:00 - 6:30 - Introductions,General Q&A session & Announcements
6:30 - 7:30 - Presentation(s)
7:30 - ?? - Door prizes and Question & Answer session

***NOTICE***

Hyatt Place - Garden of the Gods
503 West Garden of the Gods Road
Colorado Springs, CO 80909
 
 


If you cannot find us please call Kat Meadows @ 719-330-8425

 


   
Blogs | Home | Meetings | Photo Gallery | About Us | Resources | Officers | Sponsors
Privacy Statement  |  Terms Of Use
Copyright 2009 by PASS Chapters Portal