Featured Article(s)
Useful Undocumented Maintenance SQL Server 2008 DBCC Commands
In this article, Alexander Chigrik shows some useful undocumented maintenance DBCC commands that shipped with SQL Server 2008.
Webcast Today – Register Now
Measure Twice, Develop Once
One site-collection or two? Subsite or List? The answer to these questions guides the decisions of many deployments. When mistakenly answered organizations quickly learn how hard it is to gain their return on investment. We will explore the importance of requirements gathering, the limitations of SharePoint, and some backend considerations in making these decisions. Presented by: Adam Levithan
> Register Now
> Live date: 10/28/2009 at 12:00 Pacific
Final Thoughts on SharePoint and Mixed Administration Roles
Ray approaches DBA/SharePoint admin like this – "Sharepoint is setup to allow the Sharepoint Administrator to create Databases and add content to those databases from Central Admin… With that said, you really should have a DBA managing what gets created where! I am one of those cases that works at a small company and I have always been both the developer and the DBA… So naturally, I became the Sharepoint Admin as well… But from what I have experienced, you could really create a monster if you don’t have the DB experience… And, I would be willing to bet, most DBAs would rather take on that Sharepoint roll, than let someone else potentially hose something up. At some point, the DBA is going to get called in anyway to fix it… I’d just rather know it’s managed correctly from the beginning…"
A few people wrote in with purely "factual" cuts on where a system becomes a candidate for a dedicated administrator for SharePoint (or any other application). These may help in defining where things change in your own shop – here’s what people suggested as cut points:
– more than .5 full time equivalent employee required to admin
– more than 500G database size
– more than 50 users
Finally, several people drew the line at the types of information being presented. Specifically, if the systems were impacted by compliance (HIPAA, SOX, etc.), they became candidates for a dedicated administrator because the overhead of the compliance alone could force the need for the admin.
Featured White Paper(s)
The 6 Key Points of SharePoint Infrastructure Planning
SharePoint products and technologies have readily found a place within the business environments of many organizations. Share… (read more)