Skip to Content
Programming Microsoft® SQL Server™ 2008
book

Programming Microsoft® SQL Server™ 2008

by Leonard Lobel, Andrew Brust, and Stephen Forte
October 2008
Beginner to intermediate
1024 pages
31h 30m
English
Microsoft Press
Content preview from Programming Microsoft® SQL Server™ 2008

Using Excel

The number one OLAP client in the world today is Excel. For IT organizations, the ubiquity of Microsoft Office—and the resulting simplicity of deployment and low cost—make Excel quite popular. For users, the familiarity of the spreadsheet interface makes Excel a highly requested UI paradigm.

As a result, Microsoft made certain that Excel 2007 PivotTables and charts provided support for virtually every Analysis Services 2005 (and thus 2008) feature, including multiple measure groups, key performance indicators (KPIs), dimension attributes (as distinct from user hierarchies), actions, named sets, and more. In addition, Microsoft added several functions to the Excel formula language to allow querying of cubes from within non-PivotTable ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust
Microsoft® SQL Server® 2008 Internals

Microsoft® SQL Server® 2008 Internals

Paul Randal Kalen Delaney Kimberly Tripp, and Conor Cunningham

Publisher Resources

ISBN: 9780735625990