Presentations and Demos

TempDB Performance - August 2010

sheffron — Tue, 10 Aug 2010 05:22:07 GMT

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.

Exception Handling (Try and Catch) - July 2010

sheffron — Sun, 18 Jul 2010 17:22:57 GMT

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…

TDE Demo Script - May 2010

benmiller — Tue, 11 May 2010 19:51:28 GMT

TDE Presentation - May 2010

benmiller — Tue, 11 May 2010 19:48:26 GMT

These are the slides for the Presentation. I will also post the TSQL.

SQL CLR - April 2010

sheffron — Fri, 16 Apr 2010 17:34:06 GMT

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

DBA Performance Tips & Tricks - SSUG Feb 2010

sheffron — Tue, 09 Feb 2010 00:59:19 GMT

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

Case Study: ETL without SSIS

sheffron — Tue, 12 Jan 2010 01:40:38 GMT

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

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

sheffron — Tue, 15 Sep 2009 12:07:51 GMT

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 Intelligence features including KPIs and actions.

For organizations that have a Standard or Enterprise SQL Server license, Analysis Services is a possible zero-cost opportunity for your organization today. In the session learn how to exploit the capabilities and features, and the basics of best practice design. Be prepared for numerous compelling demonstrations and to leave the session energized by the potential!

This session is targeted at IT professionals with an interest in data analysis, and equally for non-IT professionals interested to understand and evaluate Microsoft's BI strategy and platforms. Apart from a general understanding of relational database technologies, there is no requirement to have any background or experience with OLAP technology

Aug. 2009 - Confio Presentation on SQL Tuning

benmiller — Mon, 10 Aug 2009 22:49:02 GMT

DeMystified Common Expression Tables (CTE's)

sheffron — Tue, 12 May 2009 03:00:00 GMT

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 which it occurs.

DeMystified Common Table Expressions (CTE's)

sheffron — Tue, 12 May 2009 02:58:44 GMT

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 which it occurs.

Attached is the presentation and example code.

DeMystifying Common Table Expressions (CTE's)

sheffron — Tue, 12 May 2009 02:56:01 GMT

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 statement in which it occurs.

Presentation and Example code into included in the zip file.

SQL Server 2008 Spatial Data

sheffron — Fri, 08 May 2009 01:20:45 GMT

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 geographic features and their relative locations.

Business Process Modeling Notation

sheffron — Fri, 08 May 2009 01:09:21 GMT

This presentation was given by Scott Heffron

Business Process Modeling Notation (BPMN) is a standard for business process modeling, and provides a graphical notation for specifying business processes in a Business Process Diagrams (BPD), based on a flowcharting technnique. The objective of BPMN is to support business process management for both technical users and business users by providing a notation that is intuitive to business users yet able to represent complex process semantics.

Journey to Developer Certification - Tables and Views

sheffron — Fri, 08 May 2009 00:58:32 GMT

This presentation was given by Scott Heffron

It is about the different areas that I went through to review and learn on the way towards getting ready for my certification. The Exam is # 70-433 and it is the Technical Specialist for SQL Server 2008 with the target area of Database Development.

URL: http://www.microsoft.com/learning/en/us/Exams/70-433.mspx