~/talk

Upgrade and Migration Planning BI Features for SQL Server 2014 and 2016

on YouTube 01h 00m
Talkat 24 Hours of PASS: Summit Preview 2015 · on Thursday, 2015-09-17· [databases]

speaker

name:Paul Turley
links:none on file

resources

video:https://youtu.be/OJC6TLBJfqg
slides:none on file

summary

Covers concrete upgrade paths: in-place vs side-by-side, which files and symmetric keys to back up, and gotchas when moving from 2005/2008 to sql server 2014. Digs into SSDT/SSDTBI naming, reporting services compatibility and deprecated renderers, and shows the 2016 CTP features that actually exist — parameter UX, HTML5 rendering, new charts (treemap/sunburst), tabular advances like DAX additions, direct query and many-to-many, and the inclusion of data zen for mobile dashboards, with demos and troubleshooting pointers.

AI-written summary · about

chapters (25)

  1. 0:00Start
  2. 3:09Paul Turley Bio
  3. 4:34What Does This Presentation Cover?
  4. 8:10Upgrade Versions
  5. 8:25Why Upgrade?
  6. 11:26When To Upgrade?
  7. 12:32Business Intelligence Tools SQL Server Management Studio SQL Server Data Tools Analysis Services Multidimensional Analysis Services Tabular Reporting Services Excel add-ins
  8. 14:36SQL Server Data Tools - BI
  9. 16:00SQL Server Data Tools & Visual Studio
  10. 17:12SSRS Versions & Feature Snapshot
  11. 20:08SSRS Upgrade Scenarios
  12. 23:15Backup and Rollback Plan
  13. 24:44Troubleshooting a Failed Upgrade
  14. 25:57Deprecated Features in SSRS 2012 & 2014
  15. 28:47Reporting Services Additions
  16. 38:15SSAS Upgrade Scenarios
  17. 38:57Deprecated Features in SSAS 2014
  18. 39:33Discontinued Functionality
  19. 40:20Summary
  20. 40:40Analysis Services Multidimensional Improvements Performance improvements for
  21. 41:29Analysis Services Tabular Project
  22. 43:51Multidimensional or Tabular? Multidimensional
  23. 44:49Power Pivot for Excel
  24. 45:13Analysis Services Tabular Additions - 1
  25. 48:43SQL Server Data Tools 2016

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.