Recent Announcements
Big Mountain Data & SQL Saturday Conference
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 |
| Attachments:
Process_And_Operational_Intelligence.zip
SSIS Performance Metrics - SQLSaturday #246
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 |
| Attachments:
SSIS-Metrics Collection.zip
Oracle Metric Collection (Case Study) - 7/30/13
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 URL: www.utoug.org |
| Attachments:
ETL Performance Metrics Handout .pdf
SQL Saturday - October 20th, 2012
Speaking in November at SQL Server User Group
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. Area(s):
|
Speaking at SQL Saturday
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
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. http://tinyurl.com/23efmld |
New SQL Server User Group President
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