Colorado Springs SQL Server Users Group

Next Meeting




February SSUG Meeting

Our Main Presentation:

Rick Lowe

Title : Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints

Most of us have heard that using the NOLOCK hint is not recommended. But why is this? What is it about NOLOCK that sends most DBAs into a tizzy? And how about other hints such as ROWLOCK and RECOMPILE - are they OK to use? Come hear a discussion on why exactly query hints cause problems when used excessively, and watch some demos of NOLOCK craziness in action.

About Rick:

Rick is a Microsoft Certified Master with more than 15 years of experience working with SQL Server. He currently based in Denver and works as an independent performance DBA/Developer for clients across the USA and Canada. He started his career as a database developer, but over time became more and more interested in how the database engine operated ... eventually becoming more focused on operational and performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

101 Session: Jack Graber

RoundhousE Kick Your Database - An Intro to Automating DB Deployment with RoundhousE

Deploying databases with last minute treasure hunts for scripts or trying to figure out why your UAT database is different than QA or DEV even though they are on the same exact version can be maddening. Wait….you can version a database?! In this introduction to the RoundhousE tool we’ll talk about how it automates the deployment process, how the RoundhousE environment functions and how it can help make deployments a consistent, repeatable process. And yes, even apply some versioning to your database.

About Jack:
Jack Graber, Consultant at Datalere, has worked with SQL Server for the past 15 years. He has worked with ETL, reporting, database development and supporting enterprise applications on SQL Server. In the life prior to SQL Server he did software support / consulting / instruction and is working on dusting off some of those skills of speaking on things he has learned.

Featured Presentation:

Trying on the Glass Slipper: Is Azure SQL Data Warehouse Right for You?

Jason Horner, Consultant

You heard a lot about Azure SQL DW and may even be getting some pressure to move to this new platform; but what makes it so different from Azure SQL Database or even on-premise SQL Server. In this session, we will provide a solid overview of the concepts that make Azure SQL Data Warehouse different from other versions. We will also look a bit at common migration challenges and how to overcome that as well as explore and debunk some basic myths about Azure SQL DW. Attend this dynamic session to ensure that your Azure SQL Data Warehouse has a fairy tale ending and you aren't left with a Data Warehouse pumpkin on your hands.

About Jason:
Jason Horner is a Microsoft Certified Master of SQL Server and has worked with it for more than 10 years. He began work as a DBA/Application Developer in 1999. He made the transition to delivering BI solutions in 2002 and began working with spatial data in 2008. Jason’s latest focus has been architecting large-scale spatially enabled BI solutions.

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 for the actual EventBrite link.

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

Back to Top