sql server 2012 — why it is so important to sharepoint by peter serzo - sptechcon
DESCRIPTION
Technical Class:TRANSCRIPT
Peter Serzo
SPTECHCON – San Franscisco
March 2013
Peter Serzo, MCP, MCSD .Net, MCTS
High Monkey Consulting
Blog: monkeyblog.highmonkey.com
www.highmonkey.com
Twitter: pserzo
Author
Love to read and Love a Good Story
Agenda
Covering SQL 2012 enhancements ONLY as it relates to SharePoint 2010.
SP 2013 BI
Data
Alerts
Power View
Claims
Reporting Services
PowerShell
Service App
Backup/Restore ULS
Access Services
Excel 2013
Architecture
Architecture
VertiPaq
VertiPaq
In-memory column store… typical 10x compression
Brute force memory scans… high performance by default… no tuning required
Basic paging support… data volume mostly limited to physical memory
Column Store Indexes • Ford, Jane, 34mpg • Nissan, Bill, 24mpg • Buick, Don, 17mpg
• Ford, Nissan, Buick • Jane, Bill, Don • 34mpg, 24mpg, 17mpg
Column store indexes store each column’s data together.
Reporting Services Installation Notice the word integrated is no longer used. It is called SharePoint Mode.
Reporting Services Installation
PowerShell
Create SSRS Service Application $RSServiceAppPool = Get-SPServiceApplicationPool "SharePoint Web Services Default" $RSServiceAppName = "SSRS Service App 2" $RSDBName = "ReportServerService_GUID" $RSServiceApp = New-SPRSServiceApplication -Name $RSServiceAppName -applicationPool $RSServiceAppPool -DatabaseName $RSDBName
Create SSRS Service Application Proxy $RSServiceAppProxyName = "SSRS Service App Proxy" $RSServiceAppProxy = New-SPRSServiceApplicationProxy -Name $RSServiceAppProxyName -ServiceApplication $RSServiceApp
Reporting Services Management
Manage Service Application
Claims
Backup/Restore
SharePoint Central Administration
Encryption key still needs to be backed up
ULS
Diagnose with SharePoint ULS Logging
Report Builder
SSRS – Data Alerts
SSRS – Data Alerts
Manage Alerts in SharePoint
Per Site
Not available in Native Mode
SSRS – Export
65k to 1 million Rows
SSDT
SSDT
Power View
Power View is an interactive data exploration and visual presentation
experience.
Power View
• Interactive, web-based authoring and sharing of information
• Zero configuration highlighting and filtering
• Animated trending and comparisons
• Interactive Presentation turns pervasive information into
persuasive information
• Deliver and collaborate through SharePoint
• Full screen presentation mode for interactive boardroom session
Site Collection Feature
Power View
Power View – Multiple Views/Report
Excel 2013
SharePoint 2013 – Access Services
SharePoint 2013 - BI
Licensing
3 versions: Enterprise Business Intelligence Standard
Follow the SQL Team
They control BI within Microsoft
http://blogs.msdn.com/b/sqlrsteamblog
http://weblogs.sqlteam.com/
Follow theses bloggers
http://denglishbi.wordpress.com Dan English
http://www.powerpivotblog.nl Kasper
http://blogs.msdn.com/b/karang Karan Gulati