Salt Lake City
SQL Server User Group

Refine your search

• TempDB Performance - August 2010

   This is the talk given by Pat Wright about TemDB performance.   We discussed some of the common issues of Tempdb and what you can do to improve the performance of tempdb.  We will also talked about disk performance you can make with SSD drives to give you even more performance from your tempdb and databases.

  Posted to Presentations and Demos (FileGallery) by sheffron on 08-10-2010

• Exception Handling (Try and Catch) - July 2010

  The TRY...CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and is an extremely important part of developing robust database applications. TRY..CATCH works by allowing you to specify…

  Posted to Presentations and Demos (FileGallery) by sheffron on 07-18-2010

• SQL CLR - April 2010

  The presentation focused on CRL (Common Languag Runtime) .  This is a technology for hosting Microsoft .NET engine within SQL Server.   Included in the zip file are the examples that were presented at the meeting Speaker: Scott Heffron

  Posted to Presentations and Demos (FileGallery) by sheffron on 04-16-2010

• DBA Performance Tips & Tricks - SSUG Feb 2010

  This presentation was given by Pat Wright at the February 2010 SQL Server User Group.

  Posted to Presentations and Demos (FileGallery) by sheffron on 02-08-2010

• Case Study: ETL without SSIS

  Because sometimes we do not have the luxury of SSIS and we have to work with what we have.  The presentation show how the principles that govern the ETL process can work with the tools that you are given. Speaker: Scott Heffron

  Posted to Presentations and Demos (FileGallery) by sheffron on 01-11-2010

• Sept 09 - Developing a Unified Dimensional Model (UDM) with Analysis Services

  Presentation by Peter Myer's of SolidQ Analysis Service’s OLAP component allows organizations to implement a Unified Dimensional Model (UDM) that is designed for rapid ad hoc information retrieval of their data. The UDM, as a single version of the truth, can be enriched to encapsulate business rules and calculations, and advanced Business ...

  Posted to Presentations and Demos (FileGallery) by sheffron on 09-15-2009

• DeMystified Common Expression Tables (CTE's)

  Presented by Scott Heffron Common table expressions (CTEs), a powerful and slick new feature in SQL Server 2005, make your SQL more readable and easier to maintain. They are similar to aliases (as in SELECT T1.* FROM MyTable T1) but much more useful. In essence, a CTE is a temporary result set that exists only within the scope of the statement in ...

  Posted to Presentations and Demos (FileGallery) by sheffron on 05-11-2009

• DeMystified Common Table Expressions (CTE's)

  Presented by Scott Heffron ommon table expressions (CTEs), a powerful and slick new feature in SQL Server 2005, make your SQL more readable and easier to maintain. They are similar to aliases (as in SELECT T1.* FROM MyTable T1) but much more useful. In essence, a CTE is a temporary result set that exists only within the scope of the statement in ...

  Posted to Presentations and Demos (FileGallery) by sheffron on 05-11-2009

• DeMystifying Common Table Expressions (CTE's)

  Presented by Scott Heffron Common table expressions (CTEs), a powerful and slick feature in SQL Server to make your SQL more readable and easier to maintain.  They are similar to aliases (as in SELECT T1.* FROM MyTable T1) but much more useful. In essence, a CTE is a temporary result set that exists only within the scope of the ...

  Posted to Presentations and Demos (FileGallery) by sheffron on 05-11-2009

• SQL Server 2008 Spatial Data

  This presentation was given by Scott Heffron Spatial data is used to represent points, lines, and areas on a surface. Most commonly, these elements relate to actual physical locations on Earth, so can be described a geospatial data. Most of us are familiar with this concept through the use of globes and maps, which generally show multiple ...

  Posted to Presentations and Demos (FileGallery) by sheffron on 05-07-2009