The Arizona SQL Server Users Group



Analysis Services 2008 R2: After the Wizard

In this session, we will look at some of the interesting ways cube developers can provide Excel users the ability to interact with the cube. The demonstration will include creating URL, reporting and drill through actions, enabling writeback, creating a perspective and viewing the cube in Excel.  Presented by Marie Roqueni of Microsoft.


 OLAP PivotTable Extensions:


Metadata Reports:






Data Warehouse Dimension Updating with SQL Server 2008

This presentation will discuss the concepts of data warehouse dimension updates and show how to use features in SQL Server 2008 to make dimension update faster and easier to implement.  The key features discussed include the new Change Data Capture facility, SSIS Slowly Changing Dimension transform and the new MERGE statement.  The Presenter is Jeff Jones of Interface Technical Training.  The PowerPoint presentation and sample code can be found posted under the "Resources" tab.


Advanced T-SQL Constructs that Every SQL Programmer Should Know

This session discussed and demonstrated advanced Transact-SQL functionality - essential tools to help developers get the most out of SQL Server.    The session was presented by Bennie Haelen and Eric Nelson.  The PowerPoint presentation and sample code can be found posted under the "Resources" tab.


Surfacing Business Intelligence in SharePoint 2010

This session will demonstrate self-service BI using the newly released Microsoft Office 2010 with PowerPivot, SQL Server 2008 R2, and SharePoint Server 2010 with PerformancePoint Services.


Very Large SQL Server Projects

Kevin Cox of the Microsoft SQLCAT (Customer Advisory Team) presented on some of the largetst SQL Server implementation in the world.




SQL Server Reporting Services 2008 R2

Marie Roqueni of Microsoft presented the new features within SSRS 2008 R2.



Previously known as Project Gemini, PowerPivot is a new technology that Microsoft is calling “Self-Service Business Intelligence”. Come and see what this new technology is all about and learn how you might implement it for your team.  Presented by Mark Timpone and Croix Waage.


Data Partitioning in SQL Server

Partitioning is a method of splitting up a large data set (often terabyte sizes) into smaller, more manageable chunks. This presentation addresses the partitioning of SQL Server tables and Analysis Services objects and will explain the benefits of partitioning. The session will primarily focus on horizontal partitioning, which segments rows of data based on values in a partitioning column. This is a common strategy in large data warehousing implementations, primarily as a means of managing data, cube loading, and maintenance. There are also benefits when querying the data, because both SQL Server and Analysis Services provide a means of discerning which partitions are relevant to a query, assuming the query uses the partitioning column to filter the data.  Presented by Chad Kingsley.


Entity Framework Overview

The Entity Framework is a data technology from Microsoft that may particularly interest database administrators (DBAs). Join us at this session to see how this technology can radically change the development of applications.  We will look at the EF from both a developers  and DBAs perspective. We will discuss these changes and their impact on DBAs and data developers. Presented by Rob Bagby.


SQL Server 2008's New Filestream Feature

The Filestream feature allows storage and efficient access to BLOB data using SQL Server 2008 and the NTFS file system. This presentation will start with a description of FileStream, cover the overall setup and installation along with key implementation details and will also include several demonstrations. Presented by Christian Gilstrap.




SQL Server Integration Services (SSIS) 2008: New Features

In this hands-on presentation, we take a look at the new features in the second major version of SSIS, including the brand new scripting engine, now supporting C# as well as VB.NET.  The data flow task improvements and the improvements to the data flow engine.  The enhanced ADO.NET support, including the new ADO.NET data source. Cached Lookups.  All lookup data flow tasks now support a variety of caching methods, which can dramatically improve your data warehouse load times!  The SSIS support for Change Data Capture.  The Merge task, which supports the new SQL MERGE state and the Data Profiling Task.  Presented by Bennie Haelen.


SQL Server CLR - Practical Uses

In this low-slide-count presentation, we will be building and using some SQL Server CLR code to extend T-SQL's native capabilities. We will be exploring what SQL CLR is, when to consider it, what DBAs should know about it, as well as what .NET developers should know about it. We will also cover what is new in SQL CLR for 2008, Presented by Hafthor Stefansson.


SQL Server Disk I/O – Defining the Right Architecture for your Enterprise

In Joe Belson’s Microsoft consulting work, he frequently helps customers identify disk I/O-related bottlenecks that lead to inadequate performance and scalability.  He does this with white boarding sessions that result in clear plans for leveraging SAN hardware to help deliver optimal SQL Server performance. During our session, Joe will cover the basics of SQL Server disk I/O, how to determine your disk I/O saturation point, and how to provide simple, concise, and measurable requirements to your SAN engineers. Presented by Joe Belson.


Extending Analysis Services with Stored Procedures,

In this session we will take a look at Analysis Services Stored Procedures and learn how they can help you extend the capabilities of Analysis Services. These stored procedures can be called as Actions or through queries and be used in Reporting Services to document your cube metadata. Presented by Kathrine Lord.


Introduction to Change Data Capture (CDC) and the Merge Statement,

With the release of SQL Server 2008, there are a wide range of new features and improvements.  Change Data Capture (CDC) and the Merge Statement are two of them.  We'll discuss and demo the concepts of both and how the functionality can significantly help in the data warehousing arena. Presented by Marie Roqueni.