1. SSAS Design Best Practices & Incremental Processing (presented by Dan English) - So you built a SSAS cube or are planning on it...now what? Just deploy, process, and let the users go at it? Maybe and maybe not. During this presentation we will talk about and explore Analysis Services design best practices and talk about a method for incremental processing.

    # vimeo.com/12222674 Uploaded 2,113 Plays 0 Comments
  2. Want to know what PerformancePoint Server (PPS) 2007 Monitoring & Analytics is all about? Get ready for an overview of this portion of the product and a demonstration creating a dashboard solution. I am looking to demonstrate building a BI Dashboards example from the Code Magazine Mar/Apr issue (article id 0803051 if you want to check it out in advance on the code-magazine site).

    # vimeo.com/12283458 Uploaded 131 Plays 0 Comments
  3. The new Gauge data region is most often used to provide a high-level summary of your data by highlighting key performance indicator (KPI) values. The gauge uses a pointer to show a single value. You can add a range to highlight a subset of values on your scale and control the size and positioning of the scale on the gauge to create different visual effects.

    # vimeo.com/12290754 Uploaded 709 Plays 0 Comments
  4. SQL Server 2008 includes Dimension Designer Enhancements, new attribute relationships designer, and additional Best Practice Alerts. The Dimension Wizard within BIDS 2008 (VS 2008) for Analysis Service Projects has been simplified and introduces a new attribute relationship designer. The wizard has reduced the number of screens and includes an auto-detection for parent-child hierarchies.

    # vimeo.com/12290829 Uploaded 229 Plays 0 Comments
  5. SQL Server 2008 includes GROUPING SETS: Grouping Sets is an extension to the GROUP BY clause that lets users define multiple groupings in the same query. Grouping Sets produces a single result set that is equivalent to a UNION ALL of differently grouped rows, making aggregation querying and reporting easier and faster.

    # vimeo.com/12291084 Uploaded 110 Plays 0 Comments

Sql Server

Efi Goldman

This channel will follow all new stuff in the SQl Environment

Browse This Channel

Shout Box

Heads up: the shoutbox will be retiring soon. It’s tired of working, and can’t wait to relax. You can still send a message to the channel owner, though!

Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels.