Indiana University

1. Indiana University SharePoint User’s Group http://iuspug.iu.edu User's Group Committee LeadersLarry Campbell Andy Hill Brian Hughes Tanzil MalekCory P. Retherford June 15th, 2010

2. 2010 IUSPUG: IU SharePoint Users’ Group IUSPUG Group Leaders • Cory P. Retherford (User's Group Founder and Community Leader) • Student Enrollment Services - Manager of Technology Services • cprether@indiana.edu • iuspug@iu.edu • Brian Hughes (Group Leader) • UITS Messaging - Lead Software Engineer • hughesb@indiana.edu • spadmin@iu.edu • Tanzil Malek (Group Leader) • School of Education - Network Applications Specialist • tmalek@indiana.edu • Andy Hill (Webmaster) • Student Enrollment Services - Senior Analyst/Programmer • athill@indiana.edu • Larry Campbell (Business Process Specialist) • School of Education – Associate Director of Information Systems • lacampbe@indiana.edu

3. 2010 IUSPUG: IU SharePoint Users’ Group Agenda – More to Come!!! • SQL Server 2008 R2 and SharePoint 2010 Integrations • Install Best Practices… • OnBase SharePoint Web Parts Demo – Hyland Software

4. Indiana University SharePoint User’s Group http://iuspug.iu.edu PresentationSQL Server 2008 R2 and how to best integrate SharePoint 2010 Presented by Cory P. Retherford June 15th, 2010

5. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Installation • Server Specifications • Disk Availability • Data Partitioning • Setup and Installation • SQL Alias’s • Service Accounts • DB Sizing • Using Non-Default Ports • Maintenance Plans • Transparent Data Encryption • And More…

6. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Specifications Musts! • Physical Hardware or Virtualized? • Use Dedicated SQL Server and dedicated Data Partition/LUN • 16GB Memory • 4 CPU • Make certain the L2 cache per CPU is greater then 2MB • You can theoretically scale out beyond 4 TB of data. • beyond the 100 gig recommended threshold for a collection, however you should use Microsoft DPM or SQL backups instead of other systems such as VERITAS or Tivoli systems to do backup on these systems

7. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server 2008 (Disk Availability) • Use asynchronous mirroring of DB services • High performance mode (Data Safety Off) • Principle DB sends transaction to mirror and does not wait for the commit (transaction is committed immediately as opposed to waiting for the transaction acknowledgement from the mirror “Safety FULL”) • http://msdn.microsoft.com/en-us/library/ms187110.aspx • http://msdn.microsoft.com/en-us/library/cc917681.aspx • Only for advance deployments (High Availability)

8. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server 2008 (Disk Availability) • SQL Server 2008 R2 Disk Availability • http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx

9. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server 2008 (Data Partitioning) • Data Stores - Dynamic Disks • C:\OS • Make certain to have enough free disk for a full memory dump • E:\SQL Data Volume • 64K Allocation unit size • http://technet.microsoft.com/en-us/library/cc966412.aspx • F:\tempdb • Configure the Temp DB to be at least 10% of total content DB size or the size of the largest table • G:\SQL Backup • H:\SQL Log Volume

10. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup • Prerequisites • Install .NET Framework • Server Manager > Features > Add Features > .NET Framework... • Installation • New installation or add features to an existing installation • Setup Role • All Features with Defaults

11. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup • Feature Selection

12. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup • Installation Rules • Verify Status for all Rules Passed • Instance Configuration • Create alias for DB • In SQL Server Configuration Manager, expand SQL Native Client Configuration, right-click Aliases, and then click New Alias. • IMPORTANT!!!

13. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (Aliases) • Create an SQL Alias • Windows SQL Severs can be setup to use server alias’s using the local native client configuration manager so that in the event of an upgrade (SQL Server 2008 R2) clients do not need to make server connection changes to existing Databases when server names are changed. If you use the alias SP2010\Instance you can always point your SharePoint WFE's to your server FQDN without any consequence of the SQL server name. The advantage of this approach is that if you ever want to move your SharePoint databases to a new SQL Server all you need to do is change the SQL Alias.

14. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (Aliases) • Create an SQL Alias • On the SQL Server create an alias • In SQL Server Configuration Manager, expand SQL Native Client Configuration and SQL Native Client Configuration (32bit), right-click Aliases, and then click New Alias. • The New Alias (Alias Tab) topic describes the New Alias dialog box, and contains links to valid connection strings for each type of protocol.

15. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (Aliases) • Create an SQL Alias • On the SharePoint WFE configure the Client do the following • Open a run prompt and type cliconfg. • The SQL Server Client Network Utility will open. • Click the General Tab • Enable TCP/IP • Click the Alias tab • Add the server name alias For example”SP2010”

16. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (Aliases) • This will now use the SQL Alias name and redirect the client to any new server FQDN location if changed.

17. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup • Use a Named Instance unless the Default instance is absolutely required

18. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (Service Accounts) • Server Configuration • Service Accounts

19. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup • Database Engine Configuration • Windows Authentication Mode • Add AD Admin Group • Current User • Server Administrators AD group • Data Directories • Data Root Directory • E:\ • User database directory • E:\ • User database log directory • H:\ • Temp DB directory • F:\ • Temp DB log directory • H:\ • SQL Backup • G:\ FILESTREAM http://technet.microsoft.com/en-us/library/bb933993.aspx

20. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup • Reporting Services Configuration • Install the SharePoint integrated mode default configuration

21. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup • Error Reporting • Do not check the Send Error Reports option • Installation Configuration Rules • Verify Status for all Rules Passed • Ready to Install • Installation Progress

22. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (DB Sizing) • DB Sizing • Size the databases ahead of time • Content 60mb • Config 10mb • The max upload size of the webapp should match the auto grow size for the DB • DB properties>File> • Ideally you should size the DB and not allow auto growth • This will reduce and prevent fragmentation of the DB and • Keep the disk contiguous. 

23. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (SQL Non-Default Port) • SQL Non-Default Port • Open SQL Server Configuration Manager on the SQL Server • Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager

24. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (SQL Non-Default Port) • Expand SQL Server Network Configuration • Click the instance for configuration • Right-click TCP/IP, and then click Properties. • Click the IP Addresses tab • For every IP assigned to the SQL Server there is a corresponding entry

25. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (SQL Non-Default Port) • Globally change the port that the instance responds • Clear all values for TCP Dynamic Ports and TCP Port • Values • Value 0 - Indicates that SQL Server uses a dynamic TCP port for the IP address • Blank value - Indicates SQL Server will not use a dynamic TCP port for the IP address.

26. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (SQL Non-Default Port) • For the IPAll section enter the port number desired for communications. • Enter IP, for example TCP “40115”.

27. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (SQL Non-Default Port) • Restart the SQL Server (INSTANCE) using the Services.msc command • You may get a prompt stating this will also restart the SQL Server Agent • Confirm this in Event Viewer > Windows Logs > Application

28. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (Maintenance Plans) • To be continued…

29. 2010 IUSPUG: IU SharePoint Users’ Group SQL Server Setup (TDE) • Transparent Data Encryption • To be continued…

30. 2010 IUSPUG: IU SharePoint Users’ Group Cory’s Blog SQL Server Setup • SQL Server 2008 R2 Data Center Installation for SharePoint 2010 • http://www.retherfords.com/blogs/CoryRetherford/Lists/Posts/Post.aspx?ID=4

31. Indiana University SharePoint User’s Group http://iuspug.iu.edu PresentationHyland’s OnBase SharePoint Web Parts Presented by Eric Patalinghug June 15th, 2010

32. 2010 IUSPUG: IU SharePoint Users’ Group Future Topics of Discussion • Blogs, copy and paste images and text to SharePoint! • Workflow, Insights, and Composites • BCS; Visio Services, Excel Services • SharePoint 2010 • Microsoft PerformancePoint Services • SharePoint 2009 Conference Videos • Creating Dashboards as easy as One, Two, Three - An Introduction to PerformancePoint Services • Building SharePoint Mashups With SharePoint Designer, Bing Maps and REST Services • Microsoft SharePoint Designer 2010 • Microsoft SharePoint Designer Dashboard

33. 2010 IUSPUG: IU SharePoint Users’ Group Future Topics of Discussion • Governance • IU SharePoint Governance Plan Progress • Academic Solutions Built on SharePoint • Ticket System • Asset Inventory • InfoPath • Web Parts creation • Training and Resources • Tutorials and Classroom Lesson Plans • How do we build what you have!?

34. 2010 IUSPUG: IU SharePoint Users’ Group Thank you for your attendance. The Indiana University SharePoint Users Group goals are to provide you with the tools and resources to engage, connect, and collaborate with the Indiana University SharePoint community. We hope to facilitate communication and discussion about SharePoint and Microsoft products. Monthly Meetings – In person, Video conferencing, Breeze, and phone http://iuspug.iu.edu