Recent Announcements

Big Mountain Data & SQL Saturday Conference

posted Oct 24, 2014, 9:10 PM by Scott Heffron

Business processes can get large and complex. So much so, that no one can understand each piece of the puzzle that makes the entire process work. This talk will be on how we put into place ways to capture the events of the processes so that we can more effectively understand and troubleshoot the system. This also allows us to perform further analysis (drilling down into details of the process, time patterns to see trends in how long a certain action takes, root cause analysis, and processing load analysis). This can also help people understand the many steps that can go into a business process

SSIS Performance Metrics - SQLSaturday #246

posted Sep 9, 2013, 9:18 AM by Scott Heffron   [ updated Sep 9, 2013, 9:19 AM ]

When designing a data integration solution.  The design decisions not only determine how successfully the solution meets the functional requirements, but also how well the solution meets performance requirements

Oracle Metric Collection (Case Study) - 7/30/13

posted Jul 24, 2013, 3:23 PM by Scott Heffron   [ updated Nov 11, 2013, 5:28 AM ]

When architecting a data integration solution, the design decisions not only determine how successfully the solution meets functional requirements, but also how well the solution meets performance requirements. To make the right performance design decisions, you need to understand the performance architecture of the integration process and, just as importantly, the techniques that enable you to maximize the utilization of system resources.

This presentation will discuss how we created the storage area for the metrics and how capturing metrics was implemented


SQL Saturday - October 20th, 2012

posted Oct 16, 2012, 3:12 PM by Scott Heffron

Topic: Processing XML Files into SQL Server using SSIS

This talk will show the steps needed to process an XML file for an order entry system. We will go through the lifecycle of the XML file and how the data is processed so that it is usable for entry in an order entry system. We will show the different pieces of the XML process and files and how they work together. We will also show how to dynamically change information as the need arises.

Speaking in November at SQL Server User Group

posted Oct 31, 2011, 7:21 AM by Scott Heffron

Defensive T-SQL Coding

We will be discussing how to design effective, resilient T-SQL code. We will learn what can go wrong with our T-SQL code and how we can pro-actively troubleshoot issues while still in development.  This will allow our code to last longer and easier to maintain. 

  • Changes in database objects
  • Changes in requirements
  • Code resuse
  • Error Handling in T-SQL
Salt Lake SQL Server Web Site:

Speaking at SQL Saturday

posted Oct 11, 2010, 12:08 PM by Scott Heffron   [ updated Oct 11, 2010, 1:52 PM ]

I am giving a talk on how to get through Disneyland using the shortest path. 

We have all been on a vacation. Our thoughts sometimes are to get to the rides quickly so that we can hit each one and get through the park without missing anything. This talk will be on given a list of points (Attractions) and their pairwise distances, the task is to find a shortest possible tour that visits each point (Attractions) exactly once. We will be discussing Dkjkstra's routing algorithm to solve the problem using T-SQL.

SQL Saturday

posted Sep 20, 2010, 7:47 AM by Scott Heffron

This event is being held in Salt Lake City UT and is a top notch free training on SQL Server open to any that wish to learn more about SQL Server.   Admittance to this event is free! All costs are covered by donations and sponsorships. This event is being organized by local SQL Server user groups. The SLC SQL users group and Utah county SQL users group.

It will be held on Oct 23rd 2010, at Neumont University (Neumont University 10701 South River Front Parkway South Jordan Ut 84095-3524). Event check-in will be at 8:00 with the sessions beginning at 9:00. Sessions will wrap up between 5:00 and 5:30.

Google Map Link to location.

New SQL Server User Group President

posted Apr 22, 2010, 3:11 PM by Scott Heffron

Scott Heffron was given the honor of taking on the responsiblities of the president of the Salt Lake City SQL Server User Group.  

1-8 of 8