If you are a SharePoint Admin, you are probably a reluctant SQL admin, since few are SharePoint admins first. There are the SQL admins and developers that are required to understand SharePoint but in my travels they are the exceptions not the rules. So here are some links to help out those newly appointed SQL admins.
Troubleshooting Port Redirection
SQL Port Redirection - SQL Alias
https://technet.microsoft.com/en-us/library/ff607733(v=office.16).aspx
SQL Port Redirection – Cliconfg
https://nikpatel.net/2013/09/05/step-by-step-configuring-sql-alias-on-all-sharepoint-web-and-application-servers/
SQL Port Redirection – Testing
https://social.technet.microsoft.com/Forums/office/en-US/7dcf9b8d-ba48-4c09-bb31-84a55908de1c/change-sharepoint-from-port-1433-to-something-else
Frienemies – SQL Gardner’s great presentation
http://blogs.msdn.com/b/sqlgardner/archive/2013/06/12/presentation-from-dayspug.aspx
SQL Performance Presentations
Bill Baer - Tuning SQL Server 2012 for SharePoint 2013
Mod 01: Key SQL Server and SharePoint Server Integration Concepts
Mod 02: Best Practices for SQL Server Database Settings
Mod 03: Server Settings for SQL Server
Mod 04: SQL Server and SharePoint Availability
More Good Stuff
Appendix
Database Recovery Model
Free Book on Backup and Restore
http://www.red-gate.com/community/books/sql-server-backup-and-restore
Free Whitepaper – Maximizing SQL 2012 Performance for SharePoint 2013
http://sharepoint-community.net/profiles/blogs/free-whitepaper-maximizing-sql-2012-performance-for-sharepoint-20
No comments:
Post a Comment