Colorado Springs SQL Server Users Group

Next Meeting

Wednesday,

August

15

August SSUG Meeting

We invite you to join us for our monthly meeting on Wednesday, August 15th at the Hyatt Place - 503 W. Garden of the Gods Rd sponsored by TekSystems! This month we're pleased to feature our main presentation, Power BI Premium: Is it for your Company (and Worth it)?, with Steve Wake.

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 presentation, 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 Main Presentation:

Power BI Premium: Is it for your Company (and Worth it)?

Power BI Premium is the top level of Power BI that your company can pay to get dedicated capacity for your Power BI reports and models. But at a starting price of $5000/month is it something your company needs and is it worth that price? In this session we will go over all of the current features offered with Power BI Premium and the features that we know are coming in the future so that you can help make that decision for your company. With multiple demos in this session you can see these features for yourself to help determine the worth. Come to this session if your company has been thinking about Power BI Premium but you have been unable to determine if it is right for your company or not. At the end of this session you will be armed with all of the knowledge you will need to make the right decision.

About Steve:
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full Microsoft BI stack. Steve is also very involved in the SQL community, speaking at events around the world, blogging at wakebi.com, and is currently Chapter Leader of the Mile Hi Power BI User Group.

101 Session:

"Bye Bye Cursors!"

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 the 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 a Parsons Company (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