Download - Presentation SQL for DIWUG
![Page 1: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/1.jpg)
SQLSharePoint Query
Language
Server
![Page 3: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/3.jpg)
Agenda
• SQL overzicht
• SharePoint achter de schermen
• SQL en SharePoint
• Installatie SharePoint 2013
• Tips and Tricks
![Page 4: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/4.jpg)
• Geschiedenis
• Seekuel
• SharePoint• SPS• STS
The basics
![Page 5: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/5.jpg)
Allemans vriend
• Belang
![Page 6: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/6.jpg)
The basics
• Database• Table• Row• Colomn
• Files
• Indexes
![Page 7: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/7.jpg)
Files
![Page 8: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/8.jpg)
The basics
• Database
• Files
• Indexes
![Page 9: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/9.jpg)
Behind the scene
• SharePoint
![Page 10: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/10.jpg)
Specs
• SharePoint 2010• SQL 2005 sp3• 4 – 8 cores• 8-16 Gb
• Sharepoint 2013• SQL 2008R2 sp1• 4 – 8 cores• 8-16 Gb
![Page 11: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/11.jpg)
SQL Server 2012 en SharePoint 2013
• High Availability• AlwaysON
• Opslag• RBS/ EBS• filestream
![Page 12: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/12.jpg)
SharePoint 2013 en SQL Server 2012
• Shredded storage• A “real difference”
• BI• SP1
• Acces Services
![Page 13: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/13.jpg)
Shredded StorageShredded Storage DB size (Mb) RBS size (Gb) Export time (secs)
Off 24724.88 Off 1477
Off 54.58 23.40 1882
Default – 64Kb chunk 6000.31 Off 2471
Default – 64Kb chunk 103.25 6.35 3502
2010 2013File grootte 5 File grootte 5Versies 5 Versie 1 0,5Totaal Mb 25 0 0 0 25 Versie 2 0,5
Versie 3 0,5Versie 4 0,5Versie 5 0,5
winst = 17,5 Mb Versie 6Totaal Mb 7,5 0 0 0 7,5
![Page 14: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/14.jpg)
SharePoint 2013 en SQL Server 2012
• Shredded storage• A “real difference”
• BI• SQL 2012 SP1• Power View
• Acces Services• ULS Logging
![Page 15: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/15.jpg)
Demo
• Installatie SharePoint 2013• Met ‘t handje
![Page 16: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/16.jpg)
MAXDOP
![Page 17: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/17.jpg)
Tips• Maxdop
• performance
• Geheugenbeperking• Don’t kill the OS
• Autogrowth• Fragmentatie
• Tempfile• performance
• Onderhoud• Maintenance plan
![Page 18: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/18.jpg)
Vragen
• De domste vraag is die niet gesteld is
![Page 19: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/19.jpg)
Links• Specs 2013 http://
technet.microsoft.com/en-us/library/cc262485.aspx#section3inks• Specs 2010
http://technet.microsoft.com/en-us/library/cc262485(v=office.14).aspx• BI http://
office.microsoft.com/en-us/excel-help/whats-new-in-power-view-in-excel-2013-and-in-sharepoint-server-HA102901475.aspx
• BI http://msdn.microsoft.com/en-us/library/jj218795• Limits and boundaries http://
krunaljani.blogspot.nl/2012/01/sharepoint-2010-limits-and-boundaries.html
• SPS 2001 http://technet.microsoft.com/en-us/library/cc723723.aspx#XSLTsection122121120120
• STS 2002 http://technet.microsoft.com/en-us/library/cc767982.aspx• Basics http://
www.itbully.com/articles/sql-indexing-and-performance-part-1-sql-storage-and-indexing
![Page 20: Presentation SQL for DIWUG](https://reader038.vdocuments.us/reader038/viewer/2022110121/558e0c8c1a28ab72318b4645/html5/thumbnails/20.jpg)