sqlsathistory

Nr: 60

Back to Main list

SQLSaturday #60 - Cleveland 2011

Start Time (24h) Speaker Track Title
00:00:00 Aaron Bertrand Room 314 T-SQL : Bad Habits to Kick
00:00:00 Aaron Bertrand Room 330 What's new in SQL Server 2011 ("Denali")?
00:00:00 Michael Coles Room 325 Introduction to SQL Server Spatial Data
00:00:00 Michael Coles Room 314 Build Your Own Search Engine With SQL Server
00:00:00 Allen White Room 313 Gather SQL Server Performance Data with PowerShell
00:00:00 Tim Chapman Room 314 Writing faster queries
00:00:00 Chris Skorlinski Room 315 Part 1 - Introduction to Change Data Capture
00:00:00 Chris Skorlinski Room 315 Part 2- Integrating CDC with SSIS
00:00:00 Craig Purnell Room 330 Database Mirroring in the Real World
00:00:00 Deepak Puri Room 329 Excel 2010: everyman's OLAP client just got better
00:00:00 Erin Stellato Room 313 Who's responsible? The vendor or the DBA?
00:00:00 Erin Stellato Room 313 Baselines first, troubleshooting second
00:00:00 Evan Basalik Room 315 Troubleshooting SSRS Performance Issues
00:00:00 Eddie Wuerch Room 325 Drive SQL Server Performance: I/O For Developers
00:00:00 Grant Fritchey Room 330 Gathering and Interpreting Performance Metrics
00:00:00 Ira Warren Room 315 (SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)
00:00:00 Jeff Moden Room 314 The "Tally" Table High Speed "Pseudo Cursors"
00:00:00 Jeff Mlakar Room 314 Using SQL Azure in an SSMS Addin
00:00:00 Jeremiah Peschka Room 313 Fundamentals of SQL Server Internals
00:00:00 Jeremiah Peschka Room 325 Modeling Muddy Data
00:00:00 Joe Fedak Room 329 Analysis Services Troubleshooting and Optimization
00:00:00 Joe Kuemerle Room 314 Encryption in SQL Server
00:00:00 Joe Kuemerle Room 313 Technical Professionals….Are We Just a Commodity?
00:00:00 Karen Lopez Room 325 Database Design Contentious Issues
00:00:00 Kendra Little Room 330 Table Partitioning: Evaluation, Planning, Options
00:00:00 Kendra Little Room 325 (NOLOCK) FOR YESFUN: Games with Isolation Levels
00:00:00 Mike Walsh Room 330 As a DBA, Where Do I Start?!
00:00:00 Paul Hiles Room 313 Take Your Automation Script to the Next Level
00:00:00 Brian Davis Room 325 Service Broker...What's That How Do I Use It?
00:00:00 Rob Collie Room 329 PowerPivot: BI Massive Data Analysis for Humans
00:00:00 Sam Nasr Room 329 Programming with FileStreams
00:00:00 Sam Nasr Room 329 BI Development
00:00:00 Sandra Mueller Room 329 Developing Date and Role-Playing Dimensions
00:00:00 Steve Jones Room 315 The Modern Resume - Building Your Brand
00:00:00 Thomas LaRock Room 330 Waits and Queues and YOU!
00:00:00 William E Pearson III Room 315 Getting Started with MDX

SessionID: 28441

T-SQL : Bad Habits to Kick

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 314

Speaker: Aaron Bertrand

Title: T-SQL : Bad Habits to Kick

Abstract:

The session will cover a collection of minor bad habits that can occasionally lead to major problems.

SessionID: 28443

What's new in SQL Server 2011 ("Denali")?

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 330

Speaker: Aaron Bertrand

Title: What's new in SQL Server 2011 ("Denali")?

Abstract:

This presentation will cover all of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Lots of demos and no marketing.

SessionID: 28461

Introduction to SQL Server Spatial Data

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 325

Speaker: Michael Coles

Title: Introduction to SQL Server Spatial Data

Abstract:

SQL Server 2008 introduced support for new spatial data features -- providing powerful visualization capabilities to your users. In this course attendees will learn the basics of the Geography and Geometry data types, spatial indexing, and spatial calculations. We will also explore more advanced uses for spatial data: loading spatial data into SQL Server from other formats, the new Map control in SSRS, and using online mapping software like Bing Maps to visualize SQL Server spatial data.

SessionID: 28462

Build Your Own Search Engine With SQL Server

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 314

Speaker: Michael Coles

Title: Build Your Own Search Engine With SQL Server

Abstract:

SQL Server 2008 once again improves on the classic built-in SQL Server full-text search (FTS) functionality by making FTS more efficient and transparent. In this course attendees will learn both the basics of the new Integrated FTS (iFTS) and how to build user-friendly Google-style search interfaces on top of SQL Server for the benefit of their end users.

SessionID: 28908

Gather SQL Server Performance Data with PowerShell

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 313

Speaker: Allen White

Title: Gather SQL Server Performance Data with PowerShell

Abstract:

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 29452

Writing faster queries

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 314

Speaker: Tim Chapman

Title: Writing faster queries

Abstract:

Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.

SessionID: 29486

Part 1 - Introduction to Change Data Capture

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 315

Speaker: Chris Skorlinski

Title: Part 1 - Introduction to Change Data Capture

Abstract:

Change Data Capture (CDC) is used by data warehouse applications to retrieve Type I and Type II dimension updates. This sessions provides a walk through of Microsoft's newest SQL Replication feature called CDC. Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of Type I and Type II data changes.

SessionID: 29487

Part 2- Integrating CDC with SSIS

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 315

Speaker: Chris Skorlinski

Title: Part 2- Integrating CDC with SSIS

Abstract:

Working together, Change Data Capture (CDC) and SSIS can identify changed data and move changes to your Data Warehouse. This session will focus on using SSIS package to pull daily, hourly, or near real-time Type I and Type II dimension changes from SQL Server running CDC.

SessionID: 29654

Database Mirroring in the Real World

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 330

Speaker: Craig Purnell

Title: Database Mirroring in the Real World

Abstract:

A review of Database Mirroring in the context of operations in the real world. A high level review of the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a ultra fast upgrades or to move large databases to a different location.

SessionID: 29677

Excel 2010: everyman's OLAP client just got better

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 329

Speaker: Deepak Puri

Title: Excel 2010: everyman's OLAP client just got better

Abstract:

Starting with Excel 2000, pivot tables have been able to use OLAP cubes as data sources. Since then, Excel has become the most widely adopted OLAP BI client tool for Analysis Services cubes. And new OLAP functionality has been introduced with each successive version of Excel. In this session we'll review Excel OLAP client functionality, survey what's new in Excel 2010 - and see how it all works with Analysis Services 2008 R2.

SessionID: 30084

Who's responsible? The vendor or the DBA?

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 313

Speaker: Erin Stellato

Title: Who's responsible? The vendor or the DBA?

Abstract:

Database administrators - you don't really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don't you? Well guess what, you're both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing customers) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start.

SessionID: 30085

Baselines first, troubleshooting second

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 313

Speaker: Erin Stellato

Title: Baselines first, troubleshooting second

Abstract:

“The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs

SessionID: 30094

Troubleshooting SSRS Performance Issues

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 315

Speaker: Evan Basalik

Title: Troubleshooting SSRS Performance Issues

Abstract:

Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past.

SessionID: 30165

Drive SQL Server Performance: I/O For Developers

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 325

Speaker: Eddie Wuerch

Title: Drive SQL Server Performance: I/O For Developers

Abstract:

An often-overlooked aspect to data optimization is what is happens under the covers – how does SQL Server store and access data? There are plenty of common rules covering tuning, but this session looks at data access from the physical layer, detailing how table access and indexes work, showing why some designs perform poorly, and why adding more indexes may not help. This will not be a discussion of normal forms or design rules. Instead, it will be a technical session providing the foundation for you to choose which concepts to apply to your designs.

The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases.

SessionID: 30264

Gathering and Interpreting Performance Metrics

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 330

Speaker: Grant Fritchey

Title: Gathering and Interpreting Performance Metrics

Abstract:

To begin tuning your system and the queries that run on it, you must begin from a position of knowledge. The knowledge I’m talking about is knowing what is occurring on your systems. What kind of load is the server under? How many times is that stored procedure called? This session will present the basics of gathering and interpreting knowledge about your server and the queries running on it. We’ll cover a variety of topics from performance monitor, to server-side traces, to dynamic management objects. We’ll go over how to set these things up to monitor your system and how to interpret the data returned from them. This session is part of a full day of training which will be presented in May at SQL Rally in Florida.

SessionID: 30397

(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 315

Speaker: Ira Warren

Title: (SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)

Abstract:

We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms.The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined.

SessionID: 30556

The "Tally" Table High Speed "Pseudo Cursors"

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 314

Speaker: Jeff Moden

Title: The "Tally" Table High Speed "Pseudo Cursors"

Abstract:

There are dozens of things we do in T-SQL which require some type of iteration. "Iteration" means "counters", "loops" and recursion to most people. To those well versed in the “Black Arts” of high performance "Set-based" programming, it means a "Numbers" or "Tally" Table, instead. This “Developer-to-Developer” session starts with the basics of how SQL Server can be tricked into counting faster than you can imagine, how that simple act of counting replaces slothful loops and other forms of “RBAR”, and provides a substantial introduction to “set based thinking. The session also includes tips on using Pseudo Cursors, CROSS APPLY, and INLINE TABLE VALUED FUNCTIONS (iTVFs) to make your code that much faster .

SessionID: 30655

Using SQL Azure in an SSMS Addin

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 314

Speaker: Jeff Mlakar

Title: Using SQL Azure in an SSMS Addin

Abstract:

The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. It doesn’t always have to be full sites deployed to the Cloud, it could also be "hybrid solutions", with a Client tool accessing a Cloud database. That is what will be demonstrated in this talk: A step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio Addin. The end result is an Addin in SSMS that uses the SQL Azure Cloud as a common script repository.

SessionID: 30738

Fundamentals of SQL Server Internals

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 313

Speaker: Jeremiah Peschka

Title: Fundamentals of SQL Server Internals

Abstract:

Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.

SessionID: 30740

Modeling Muddy Data

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 325

Speaker: Jeremiah Peschka

Title: Modeling Muddy Data

Abstract:

Unfortunately, the real world isn't always as cut and dry as third normal form; sometimes things get muddy. What do you do then? This talk will examine the use of NULLs, sparse columns, XML data types, and other ways of storing data with a murky format. This presentation will introduce techniques for common data modeling problems and examine potential patterns and practices for working with flexible data modeling that can be immediately useful in real-world scenarios.

SessionID: 30807

Analysis Services Troubleshooting and Optimization

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 329

Speaker: Joe Fedak

Title: Analysis Services Troubleshooting and Optimization

Abstract:

You've got SSAS cubes and they work. Now people are using them and everyone's queries are slow. I'll cover how to see who's using the cubes, what query they're running. Also, what can we do to make the queries run faster and how to stop bad queries that are hogging system resources. Specifically I'll cover the SSAS DMVs, the SSAS Activity Viewer available from CodePlex that uses theses DMVs. Also the aggregation designer that is available as part of the BIDS project and how it can be used to speed up queries against the cube database.

SessionID: 30896

Encryption in SQL Server

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 314

Speaker: Joe Kuemerle

Title: Encryption in SQL Server

Abstract:

Learn to protect data in your application by leveraging the built in encryption functionality in SQL Server 2005/2008 by taking a brownfield application and bringing it up to modern standards. Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008.

SessionID: 30898

Technical Professionals….Are We Just a Commodity?

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 313

Speaker: Joe Kuemerle

Title: Technical Professionals….Are We Just a Commodity?

Abstract:

The economy is still tight. Companies continue to reduce costs across the board. With outsourcing and off-shoring achieving success, how can today’s in-house DBA or developer prove his value to the business? Technical expertise is valuable to product and technical management. However, it’s the professionals understanding of the business and his role in generating revenue that’s invaluable. This presentation explains various techniques technical professionals can use to increase their business savvy, proving they are providing value and not just an expense.

SessionID: 31188

Database Design Contentious Issues

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 325

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

SessionID: 31504

Table Partitioning: Evaluation, Planning, Options

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 330

Speaker: Kendra Little

Title: Table Partitioning: Evaluation, Planning, Options

Abstract:

Does SQL Server's table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it's important to understand many aspects of the feature to evaluate where it will be useful. This session will cover basic concepts of table partitioning. We'll discuss where the feature can be applied, its benefits, and changes that partitioning may require to existing database schema. Special considerations for management of partitioned tables will be discussed, as well as potential changes to query optimization and plans. SQL Server 2008 R2 features for partitioning will be included in the discussion.

SessionID: 31505

(NOLOCK) FOR YESFUN: Games with Isolation Levels

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 325

Speaker: Kendra Little

Title: (NOLOCK) FOR YESFUN: Games with Isolation Levels

Abstract:

Understanding transaction isolation levels is critical for developing concurrent software as well as administering databases. Unfortunately most of us learn about transaction isolation early in our careers and don't maintain an in-depth knowledge of different isolation levels. This talk will help! We'll cover all isolation levels and discuss problems and benefits. A broadsheet handout will keep your knowledge fresh later on. This is suitable for developers and DBAs at all levels.

SessionID: 32040

As a DBA, Where Do I Start?!

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 330

Speaker: Mike Walsh

Title: As a DBA, Where Do I Start?!

Abstract:

You've always wanted to get promoted into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out.

SessionID: 32226

Take Your Automation Script to the Next Level

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 313

Speaker: Paul Hiles

Title: Take Your Automation Script to the Next Level

Abstract:

How can PowerShell take SQL Server Automation to the next level? PowerShell with the help of the SMO (Server Management Objects) allows a script to interact with the operation system and SQL Server at the same time. In this session we will cover the basics of PowerShell and the SMO object model. Then review a number of scripts that demonstrate the power of PowerShell when automating SQL Server tasks and can be used as building blocks for further automation.

SessionID: 32452

Service Broker...What's That How Do I Use It?

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 325

Speaker: Brian Davis

Title: Service Broker...What's That How Do I Use It?

Abstract:

Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We'll explore Service Broker and learn what it is and how it works. We'll walk through the setup and configuration along with demonstrating its use. You'll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments.

SessionID: 32553

PowerPivot: BI Massive Data Analysis for Humans

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 329

Speaker: Rob Collie

Title: PowerPivot: BI Massive Data Analysis for Humans

Abstract:

The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow?

In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :)

I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :)

SessionID: 32751

Programming with FileStreams

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 329

Speaker: Sam Nasr

Title: Programming with FileStreams

Abstract:

SQL Server 2008 introduced the FileStream object. This allowed developers to resolve an age long dilemma of storing large binary files in the database or accessing them on the file system. SS08 provides the best of both worlds while allowing applications to access the data readily through the FileStream object via Transact SQL or File I/O.

SessionID: 32752

BI Development

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 329

Speaker: Sam Nasr

Title: BI Development

Abstract:

SQL Server 2008 provides a great platform for producing Business Intelligence reports. With the ability to create SSIS packages and SSRS reports, BI can be utilized to provide vital information for running any business. Learning these skills will help any developer to maximize the full potential of any database application. In addition, many of the new features in Reporting Services make it easier to provide a rich BI report with little effort.

SessionID: 32757

Developing Date and Role-Playing Dimensions

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 329

Speaker: Sandra Mueller

Title: Developing Date and Role-Playing Dimensions

Abstract:

Every data warehouse needs a date dimension to help users slice and dice data. What should be included in the dimension, what is enough and what is too much? Should you use the wizard to generate the dimension for you; what are the advantages and disadvantages? We will explore a generic date dimension load script, loading a custom table and configuring SSAS to use the table as the time dimension. Finally we will address the advantages of role-playing dimensions to make an Order Date, Ship Date, Received Date exposed to users as opposed to multiple date dimensions.

SessionID: 32945

The Modern Resume - Building Your Brand

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 315

Speaker: Steve Jones

Title: The Modern Resume - Building Your Brand

Abstract:

Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job.

SessionID: 33069

Waits and Queues and YOU!

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 330

Speaker: Thomas LaRock

Title: Waits and Queues and YOU!

Abstract:

Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA.

SessionID: 33947

Getting Started with MDX

Back to calendar

Event Date: 05-02-2011 - Session time: 00:00:00 - Track: Room 315

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.