1 / 12

Powerpivot for DBA’s

Powerpivot for DBA’s. André Kamman. About me. First paid IT job when I was 17 SQL Server MVP Co-Founder and Chapter Leader of the Dutch PASS Usergroup. andre@kamman.net @ andrekamman http://andrekamman.com. Agenda. Typical perf tuning What’s a cube ? What’s Powerpivot ?

stew
Download Presentation

Powerpivot for DBA’s

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Powerpivot for DBA’s André Kamman

  2. About me • First paid IT job when I was 17 • SQL Server MVP • Co-Founder and Chapter Leader of the Dutch PASS Usergroup andre@kamman.net @andrekamman http://andrekamman.com

  3. Agenda • Typical perf tuning • What’s a cube ? • What’s Powerpivot ? • Virtual file stats • Date & Time dimension • Questions • Thank You

  4. Works for me • I try to tell you how I do it and suggest how this could be usefull to you. You decide ! • Sometimes I talk about something I work with every day, sometimes it is just a crazy idea. So sometimes I (think I) know what I’m talking about, but sometimes I’m completely out of my comfort zone myself...(This session is a bit of both actually !) • Last time feedback was very useful ! • So please do give feedback !

  5. Typical perf tuning

  6. Demo What is a cube ?

  7. What is PowerPivot ?

  8. Simplified !

  9. Demo : sys.dm_io_virtual_file_stats

  10. Questions ? http://powerpivotpro.com/what-is-powerpivot/

  11. Thank You ! Vergeet de afsluitingniet in het Auditorium ! andre@kamman.net @andrekamman http://andrekamman.com

More Related