http://www.sqlmag.com/authors/author/author/5052626/rsscomment/5052626en-USFri, 25 May 2012 10:33:35 GMTFri, 25 May 2012 10:33:35 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/office-365/office-365-plan-pain-143107#commentsAnchorThu, 17 May 2012 10:56:03 GMT
Or comment here.]]>Caroline MarwitzThu, 17 May 2012 10:56:03 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/office-365/office-365-plan-pain-143107#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/office-365/office-365-plan-pain-143107#commentsAnchorWed, 16 May 2012 17:55:54 GMT
Ian Moran (@ianmoran) tweeted a reminder that Plan P1 doesnt include SSL on the site collection. Thanks, Ian!]]>danholmeWed, 16 May 2012 17:55:54 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/office-365/office-365-plan-pain-143107#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/cloud-computing2/microsoft-skydrive-143021#commentsAnchorWed, 16 May 2012 17:51:49 GMT
We hope you enjoy this SkyDrive article!]]>Caroline MarwitzWed, 16 May 2012 17:51:49 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/cloud-computing2/microsoft-skydrive-143021#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/office-365/office-365-plan-pain-143107#commentsAnchorWed, 16 May 2012 17:32:45 GMT
Ian Moran reminded me of another Plan P missing feature: SSL on the site collection. Thanks, Ian! http://twitter.com/ianmoran]]>danholmeWed, 16 May 2012 17:32:45 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/office-365/office-365-plan-pain-143107#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/cloud-computing2/microsoft-skydrive-143021#commentsAnchorWed, 09 May 2012 09:18:36 GMT
You missed out the two things that can, and may, kill Skydrive as business tool. Most companies use some sort of web filtering service (e.g. Bluecoat). Most (if not all) of these block Skydrive as they classify it as a file sharing site (same as all those warez sites and DVD pirating sites). The filtering service providors state that they don't block the sites as it's up to the customer sites to decide which categories they block. Most customer site managers figure that if the site is in a blocked category it's there for a reason so don't giove the OK to unblock it. Therefore Skydrive (along with Google Drive, DropBox &c) is blocked. Also, most companies have rules about company data being stored on non-company equipment, i.e. don't do it. Skydrive is non-company equipment therefore employees may not store company data on it. Skydrive (and dropbox, and Google Drive and all the rest) can be as cool and as useful as they want. Techniucally they can be the bee's knees. Until they get past the corporate governance gate keepers they may as well not exist. Oh and OneNote. Love to use...at home. Management don't understand it so, even though it's included in our Office license, won't allow it to be installed.]]>Stephen BoothWed, 09 May 2012 09:18:36 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/cloud-computing2/microsoft-skydrive-143021#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-administration/sharepoint-calendar-tips#commentsAnchorTue, 01 May 2012 15:12:13 GMT
Dan: Has any of this change for SharePoint 2010? I have followed these steps along with other sites and I get a syntax error or is not supported error after clicking ok after creating the list item. Thank you. Kevin]]>Kevin HinderleiderTue, 01 May 2012 15:12:13 GMThttp://www.sqlmag.com/article/sharepoint-administration/sharepoint-calendar-tips#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-2012-142630#commentsAnchorSat, 31 Mar 2012 15:17:43 GMT
Good comments about SharePoint trends in Australia. Interestingly, we've had numerous inquiries this year from prospective clients in Australia. A few of these points may explain why. - Laurie Head, VP, AIS Network SharePoint Hosting (http://www.aisn.net)]]>Laurie HeadSat, 31 Mar 2012 15:17:43 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-2012-142630#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-2012-142630#commentsAnchorThu, 22 Mar 2012 19:33:57 GMT
Hi Dan, Thanks for the great presentations at the AUSPC. Are the presentations available for download? Thanks Arshad]]>samarshadThu, 22 Mar 2012 19:33:57 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-2012-142630#commentsAnchorhttp://www.sqlmag.com/article/windows-sharepoint-services-30/the-file-share-is-dead-long-live-sharepoint-document-libraries#commentsAnchorSat, 18 Feb 2012 06:34:43 GMT
Migrate File Share to SharePoint migration can choose the third party tool like PCVITA File Share to SharePoint Migration application because it satisfies the needed qualities and give advance benefits for the user while the File Share conversion process in the platforms like SharePoint, Office 365, and BPOS etc process is carried out. http://www.sharepointmigrator.com/file-share-to-sharepoint.html]]>newspcvitaSat, 18 Feb 2012 06:34:43 GMThttp://www.sqlmag.com/article/windows-sharepoint-services-30/the-file-share-is-dead-long-live-sharepoint-document-libraries#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-governance-sharepoint-management-drawing-blurry-line-142282#commentsAnchorThu, 16 Feb 2012 07:22:22 GMT
The succes of SharePoint in enterprises is dependent on the team behind SharePoint to include prepresentatives from all relevant parts of the organization. This includes both the business and it. In that sense it it critical to be able to distinguis between the quite different disciplins og governance and (operational) management. Companies will need to emphasize on the aspect of risk in governance as well. When creating governance polices, the primary goal should be to mitigate risk against the business; typically things like data loss, information breach, loss of productivity and related cost. Governance policies in these areas - in most cases - easily translate into it management activities; If IT is not conducting required backup tests, we may not be able to restore data as expected. This exposes a risk to the business - in relation to the scenarios described above. An information security policy will typically state these demands and must have "line of sight" to controls (compliance) being conducted on a regular basis. By using risk as a central component of the SharePoint governance planning, the dialogue around funding solutions and making requirements clear, tend to get much better. On top of that, the risk approach add excellent support for prioritazion to the Governance practice, optimizing running cost against value to the business.]]>Anders B. SkjoenaaThu, 16 Feb 2012 07:22:22 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-governance-sharepoint-management-drawing-blurry-line-142282#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-perspectives-equator-142032#commentsAnchorWed, 25 Jan 2012 17:10:48 GMT
Dan: as a sysadmin struggling to deploy SP for the IATTC (http://www.iattc.org), which works with 20+ countries (many in South America), I was encouraged by this report. I've heard a couple of your talks on governance and I am holding on to my notes. Have fun on the ice! M. Lopez]]>mflopezWed, 25 Jan 2012 17:10:48 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-perspectives-equator-142032#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharing-point-south-america-antarctica-sharepoint-141942#commentsAnchorThu, 19 Jan 2012 06:10:11 GMT
Antarctica?! Fantastic! That is really proof that SharePoint is used all over the world! :) Maybe I can see if there is anyone near the North Pole that want you to come over. :)]]>Goran HusmanThu, 19 Jan 2012 06:10:11 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharing-point-south-america-antarctica-sharepoint-141942#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/2011-sharepoint-year-review-141732#commentsAnchorWed, 28 Dec 2011 16:51:07 GMT
Happy New Year Dan! I have to agree with Radi that this year has brought a lot more visibility to SharePoint. We used to call it 'the most popular software no one has ever heard of' but I don't get to use that line as much anymore. For example, when I say why I'm in town, I usually get a blank stare, but this year, I've run into a few cab drivers that know of SharePoint. Also, I'd like to reinforce Rob's comment. I thought we'd hear more about ten years of SharePoint. But I guess it's simply the case that there aren't many people around that go back as far as Rob. Hey Sean, you may be busy now, but just wait until Wave 15 rolls into Victoria. :) I can't wait to see what 2012 will bring.]]>CawoodWed, 28 Dec 2011 16:51:07 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/2011-sharepoint-year-review-141732#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/workflow-fika-sharepoint-tips-141311#commentsAnchorFri, 16 Dec 2011 07:22:46 GMT
HarePoint is one more company that offers various SharePoint tools, like a free HarePoint Workflow Scheduler for example. http://www.harepoint.com]]>kharchenkoFri, 16 Dec 2011 07:22:46 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/workflow-fika-sharepoint-tips-141311#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/santa-mobile-devices-microsoft-releases-141623#commentsAnchorThu, 15 Dec 2011 04:00:27 GMT
Actually, I hope Microsoft doesn't settle for Windows 8-Best, iOS-Better, and Android-Good. I would certainly like to see Windows phone succeed big time but the chances of it outstripping Android soon are slim. I hope they go for the "best" experience on each device and make this the starting point for doing more cross platform availability of their applications. ]]>einaaiiThu, 15 Dec 2011 04:00:27 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/santa-mobile-devices-microsoft-releases-141623#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-administration/linking-to-documents-in-another-document-library#commentsAnchorThu, 08 Dec 2011 08:56:14 GMT
There is a feature in codeplex to help you linking within libraries. http://easylinkdocs.codeplex.com/ Hope it helps.]]>TiagoPThu, 08 Dec 2011 08:56:14 GMThttp://www.sqlmag.com/article/sharepoint-administration/linking-to-documents-in-another-document-library#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-governance-buzzword-141538#commentsAnchorThu, 08 Dec 2011 03:40:18 GMT
Hi Dan, Great article and to the point. Governance and Management are definitely different!! I'd like to add Governance rules on different levels and see them more as 'guidelines' as business likes to change. If properly published everybody should be able to understand them (KISS principle surely needed) 1. SharePoint Global - just very high level things, more related to administrators for setting up the environment --> web apps, site collections, content databases, ... 2. Site Collection level (for collaboration sites) - advice on security, structure, ... 3. Intranet - same as 2 but additionally publishing rules, ... Management is another thing and really difficult without a proper tool that can be used on the different levels by different people. There are some out there and I've made my choice :-) Best regards, Geert ]]>Geert MaurissenThu, 08 Dec 2011 03:40:18 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-governance-buzzword-141538#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-governance-buzzword-141538#commentsAnchorWed, 07 Dec 2011 15:10:51 GMT
I find it helpful to see Governance (be it the one buzzword, or the kelidescope of SharePoint governance, business governance, IT governance, service governance, and, as you say, management) in a similar way that I see SharePoint, with layers of complexity that each serve different roles. You have your site collections, sites, subsites, lists and libraries, all the way down to individual items and metadata fields on the items. IMO, SharePoint governance (and/or "governance") can and should be a layered approach, from the high-level 50000 foot view of the business objectives, all the way down to the low level day to day management and enforcement tools. Not every organization will need the same numbers of levels, or amount of detail; some will need them all mapped out before starting, and others will be better off building them as they gain experience with what SharePoint is and what it can do in relation to their environemnt and their requirements. Whether or not you choose to label those elements as governance (or "governance"), they all play a role in what SharePoint governance is at its heart: laying out what SharePoint is FOR in the organization, how to optimize it (minimax that most closely meets the needs at the least effort) to reach the goals of that purpose (or, more likely, those purposes), who is responsible for making sure it goes according to plan, and who is authorized to evaluate the plan and make adjustments when needed (and it will be needed).]]>dlairmanWed, 07 Dec 2011 15:10:51 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-governance-buzzword-141538#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorWed, 30 Nov 2011 17:11:07 GMT
Service accounts have been around for years and have been well documented. Not sure why we keep reinventing the wheel. But here is a good arguement for service accounts!!! Who is responsible for them? Do we make the application owner or the DBA (it would be nice if they were the same) responsible? How do we audit a service account? It's easy now in SharePoint 2010 where we have Health and Monitoring. What seems to aleviate a security risk for one, turns into to a maintenance nightmare for the other. Well lets write a script that does the password changes for you. No, that is a security risk!! The firewall rules will not allow that to be done. Interesting conversation I would say, and to be on the safe side let me always err with security. Someone will eventually get the blame]]>jj8558Wed, 30 Nov 2011 17:11:07 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-server-2010/Understanding-Claims-Based-Authentication-in-SharePoint-2010-128836#commentsAnchorThu, 24 Nov 2011 03:10:37 GMT
Very useful article.]]>PrashantThu, 24 Nov 2011 03:10:37 GMThttp://www.sqlmag.com/article/sharepoint-server-2010/Understanding-Claims-Based-Authentication-in-SharePoint-2010-128836#commentsAnchorhttp://www.sqlmag.com/article/office/automating-office-2007-deployment-#commentsAnchorThu, 10 Nov 2011 16:16:13 GMT
I've had some success with this. I think that given it's been almost 5 years, most "techs" would be looking for a 2010 office install. However we are still running both XP and Off 2003. I got this script to run as local admin. It did remove from the computer object from the security groups, and moved into the new group. It did the logging the data into the excel file also!!! I have yet to get this to run under the system and as a startup script, but it is progressing as I troubleshoot. THE AUTHOR of the solution deserves credit; albeit a little "late". THANK YOU. ]]>john suskeyThu, 10 Nov 2011 16:16:13 GMThttp://www.sqlmag.com/article/office/automating-office-2007-deployment-#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/architecting-sharepoint-governance-140244#commentsAnchorThu, 03 Nov 2011 10:47:56 GMT
Excellent article! I am looking forward to future articles in this series.]]>dlewis21Thu, 03 Nov 2011 10:47:56 GMThttp://www.sqlmag.com/article/sharepoint/architecting-sharepoint-governance-140244#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-wan-distributed-service-remote-users-141052#commentsAnchorThu, 27 Oct 2011 07:33:57 GMT
Dan, you mention 3rd party tools in your "take the content to users (remote farm)" option. Are there any specific 3rd party tools you've seen or heard do a better job of that?]]>Steve HusterThu, 27 Oct 2011 07:33:57 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-wan-distributed-service-remote-users-141052#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-portal-server-2007/migrating-microsoft-office-sharepoint-server-2007-to-a-different-server-104534#commentsAnchorThu, 29 Sep 2011 01:31:22 GMT
The links referred to in point 12 do not work. ]]>chachajeeThu, 29 Sep 2011 01:31:22 GMThttp://www.sqlmag.com/article/sharepoint-portal-server-2007/migrating-microsoft-office-sharepoint-server-2007-to-a-different-server-104534#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-social-features-129866#commentsAnchorTue, 06 Sep 2011 14:54:51 GMT
I find this article VERY WELL written and well thought out. Not sure why Pungi is so negative. Thanks Dan, keep up the great work! Jay]]>JPilkTue, 06 Sep 2011 14:54:51 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-social-features-129866#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/license-to-kill-revisited#commentsAnchorWed, 31 Aug 2011 16:38:55 GMT
Here is what I am trying to find out: We want to run both Enterprise and Standard. I have about 40K users that are spread across the country and world. I only want to buy about 500 ECALS and the other 35,500 users would just use Standard. My boss keeps insisting that I can run both envrionments on a single farm. I think we need to run two farms one with Enterprise and one with Just standard. Anyone else have any insight on what might be a viable solution? Thanks]]>billjulianWed, 31 Aug 2011 16:38:55 GMThttp://www.sqlmag.com/article/sharepoint/license-to-kill-revisited#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-technology-microsoft-future-140307#commentsAnchorWed, 24 Aug 2011 10:58:59 GMT
Good article Dan. Some of us have had to deal with multiple technologies from the beginning and had to fight to get Micosoft Technologies into the enterprise. Now that they are there , the opposite is happening. Other user type devices are helping us achive the kind of world we envisioned...... well sort of. Is that a good thing or a bad thing? It depends. I guess it's why we don't all wear blue jeans. Good piece. ]]>SCGWed, 24 Aug 2011 10:58:59 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-technology-microsoft-future-140307#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-technology-microsoft-future-140307#commentsAnchorWed, 24 Aug 2011 08:57:37 GMT
Like you Dan, I am a big fan of Skype when travelling the world. Did you know that when oversea's you can create local numbers that link back to your home country when called. For example when I was in Sydney Australia I created local Sydney numbers that linked back to my UK numbers. You can call the local number in Sydney (with a local pay as you go SIM) and call home for the cost of your local call plus a couple of cents (Skype) a minute. If you then move to another country just configure skype with your new local number (Lets say New Zealand) and all your sydney numbers change to local New Zealand numbers. Its neat and you don't need a WiFi connection. Cheers Ray Bolton, Warrington, England]]>RayWed, 24 Aug 2011 08:57:37 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-technology-microsoft-future-140307#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorThu, 04 Aug 2011 15:24:41 GMT
Do you have any good urls for a sharepoint backup/restore to test strategy please? I'm from a SQL DBA background and do this all the time but have never done more than automated backups for SP. Now that our company is getting serious about SP it's down to me to provide backup and DR options.]]>jaypatThu, 04 Aug 2011 15:24:41 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorMon, 25 Jul 2011 14:02:36 GMT
Dan - This is a FANTASTIC article! I've been looking for something this comprehensive that's written in plain English for awhile now and struck pay dirt with this little gem. Thank you!! One question though - at the end of the article you mention that you'll be returning to "the other important accountsidentities for service applications and web applicationsin an upcoming SharePointPro Connections newsletter and at the SharePointPro Connections website." I searched through your other articles but couldn't find anything like this, and just registered with the site so I missed the newsletter if that was where it was written. This particular area has proven especially sticky for me - can you point me in the right direction to find this info if it exists out there? Thanks!]]>PattyMon, 25 Jul 2011 14:02:36 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorFri, 22 Jul 2011 19:55:52 GMT
Well done Dan. Having designed and developed SQL applications for nearly 15 years, I can definitely say that the internalized BLOB design of SharePoint is something that's always worried me. As with most IT decisions, there are of course trade offs that must be considered as you carefully outline. But, in general, I think the advantages of a RBS outweigh the disadvantages when you have large, file-heavy content databases. One other note for the fellow who is externalizing very large files (>2GB), note that the file size limit with or without RBS is still 2GB. Sorry. Randy]]>Randy WilliamsFri, 22 Jul 2011 19:55:52 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorThu, 21 Jul 2011 14:47:25 GMT
@Rob & @Gerard Thanks for posting! As you'll note, the article is intentionally vendor-agnostic! There's not a single mention of a specific third-party provider in the article. So I'm pleased that you took the time to refer readers to one of the several high-quality options that they can explore to implement BLOB externalization... a consideration faced across a diverse range of SharePoint implementations!]]>danholmeThu, 21 Jul 2011 14:47:25 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 19:42:42 GMT
Gerard, Given that Dan works for AvePoint now (...that little editorial courtesy must have slipped his mind when he wrote the post) I doubt he'll be trying out STEALTH anytime soon, unless of course for "competitve analysis" purposes ;-). -Rob]]>rdoriaWed, 20 Jul 2011 19:42:42 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 18:55:28 GMT
Hi Dan, Great article. Have a look at STEALTH Software, it underlines all the points in your article and more. The question is if you need SAN or NAS or HSM to store the content data and wehter Backup of your content is needed at all. There are possibilities where this is not needed. Gerard ]]>Wed, 20 Jul 2011 18:55:28 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 18:50:12 GMT
Hi Dan, Great article. Have a look at STEALTH Software, it underlines all the points in your article and more. Gerard ]]>Wed, 20 Jul 2011 18:50:12 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 17:59:07 GMT
...and by the way.... GREAT ARTICLE! Russ]]>Wed, 20 Jul 2011 17:59:07 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 17:57:19 GMT
Dan-- I have personally created a document management system that has "external blob storage" way back in the early '90's and is still in operation today. It has a SQL database and pointers to the files and even after all these years, the SQL database < 20GB, even though the actual file storage is hundreds of GB of compressed files. Also, for those who were around in the STS 1.0 days, you'll remember that MS moved from storing the files on the file system to the SQL database in the STS 1.0 --> WSS 2.0 upgrade...something that scared the bajeebers (sp?) out of many of us, at the time. This created all kinds of backup issues and increased the market for accelerated SQL backup products. Also, for those who understand how a relational db works "under the covers" it's not a stretch to determine that blob storage in a SQL db is less than ideal. I personally believe that anyone with more than a 250GB should seriously consider RBS or EBS and carefully build the option into their TCO spreadsheet for SharePoint. Russ]]>Wed, 20 Jul 2011 17:57:19 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 16:43:14 GMT
I've purchased AvePoint's Extender. I believe something like this is required to manage BLOBs successfully in a production environment. Although Extender is free, the license expires regularly and you will have to contact them for a renewal. You also get no support unless you pay for it. That being said, I don't want to take away from the product with these comments as their product and support has been great. Realistically, it is not free as you shouldn't run something like this unsupported in production. ]]>Wed, 20 Jul 2011 16:43:14 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 16:27:15 GMT
AvePoint suite DocAve looks very promising and I am evaluating it for use with extremely large files >2GB. In theory it should work and I am building a proof-of-concept prototype to validate the solution over the next few weeks.]]>Wed, 20 Jul 2011 16:27:15 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 16:13:39 GMT
Anyone used the above AvePoint's DocAve Extender? Any comments? Is it better than just doing it yourself?]]>Wed, 20 Jul 2011 16:13:39 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorWed, 20 Jul 2011 15:48:35 GMT
Great information, Dan! AvePoint's been working in the SharePoint space for 10+ years now, and we've definitely felt the pains of customers using SharePoint to manage LOTS of content, and have responded with some great solutions to help extend SharePoint's storage architecture beyond SQL. For those wanting to eval available EBS/RBS solutions, be sure to check out AvePoint's FREE DocAve Extender (http://www.avepoint.com/sharepoint-storage-extender-docave/), which supports externalizing BLOBs to SAN, NAS, shared folders andcloud storage, and is supported by DocAve products for backup and restore, DR, replication, and tiered storage management.]]>Wed, 20 Jul 2011 15:48:35 GMThttp://www.sqlmag.com/article/sharepoint/blob-blob-139907#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-development/big-announcement-content-scalability-support-sharepoint-2010-139817#commentsAnchorWed, 20 Jul 2011 15:28:45 GMT
Great information, Dan! AvePoint's been working in the SharePoint space for 10+ years now, and we've definintely felt the pains of customers using SharePoint to manage LOTS of content, and have responded with some great solutions to support these large-scale environments. For those wanting to eval available RBS solutions, be sure to check out AvePoint's FREE DocAve Extender (http://www.avepoint.com/sharepoint-storage-extender-docave/), which is fully supported by DocAve data protection and management solutions as well.]]>Wed, 20 Jul 2011 15:28:45 GMThttp://www.sqlmag.com/article/sharepoint-development/big-announcement-content-scalability-support-sharepoint-2010-139817#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-development/big-announcement-content-scalability-support-sharepoint-2010-139817#commentsAnchorThu, 14 Jul 2011 04:08:13 GMT
Thanks Dan - for this very useful information.]]>Sanjeev SamalaThu, 14 Jul 2011 04:08:13 GMThttp://www.sqlmag.com/article/sharepoint-development/big-announcement-content-scalability-support-sharepoint-2010-139817#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-development/big-announcement-content-scalability-support-sharepoint-2010-139817#commentsAnchorThu, 14 Jul 2011 03:16:55 GMT
This is a great and important article, which hopefully enlight SharePoint experts who wants to build really large SharePoint solutions! Thank you Dan, for a great article, as always!]]>GhusmanThu, 14 Jul 2011 03:16:55 GMThttp://www.sqlmag.com/article/sharepoint-development/big-announcement-content-scalability-support-sharepoint-2010-139817#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorFri, 08 Jul 2011 12:21:57 GMT
Let me add: the June 2011 CU is a big deal and I think you SHOULD deploy it (after test, test, test, backup and test restore!)...]]>danholmeFri, 08 Jul 2011 12:21:57 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorThu, 07 Jul 2011 03:20:42 GMT
Thanks Dan for posting this great stuff !]]>Sanjeev SamalaThu, 07 Jul 2011 03:20:42 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorWed, 06 Jul 2011 18:06:21 GMT
Whats up Dan great post and I love the references and differing opinions at the end.. -Ivan]]>Wed, 06 Jul 2011 18:06:21 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-SP-1-june-2011-cumulative-update-139737#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-updates-136068#commentsAnchorWed, 06 Jul 2011 12:00:17 GMT
Spence Harbar has a great blog entry about updates at http://www.harbar.net/archive/2011/06/30/327.aspx. I recommend that you read this blog entry as well!]]>danholmeWed, 06 Jul 2011 12:00:17 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-updates-136068#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-updates-136068#commentsAnchorWed, 06 Jul 2011 11:59:53 GMT
@Mike Allen and UPDATE TO ARTICLE As you note, Microsoft is changing its tune related to the installation procedure for updates. While the SharePoint Server update *does* contain and install all of the Foundation update "bits," Microsoft Support and the field at large has experienced occastional installation challenges. Therefore, Microsoft's current guidance is to install Foundation updates before installing Server updates. Although the reality is that you only HAVE TO install the Server updates... and of course you will TEST any update, so your test environment should (in theory) "prove" whether you'll have any installation challenges that could be resolved by installing a Foundation update first. However, in the grand scheme of things--and compared to troubleshooting a failed update--you can consider this a relatively painless (if somewhat redundant) "best practice." ]]>danholmeWed, 06 Jul 2011 11:59:53 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-updates-136068#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-social-features-129866#commentsAnchorFri, 10 Jun 2011 12:35:42 GMT
You have only presented the rosy picture of using MySites. Seems you’ve never talked to admins about the extra "appendage" that they have to carry for each user, the few hundred GBs that have to be lugged around to the backup media, all because a low percentage of users want a supposedly "personal" area! In the end, it is really about "collaborating", even the documents the I would want to know what my colleague is doing? Are you serious? Who has the time to find out if the person sitting next to likes Kung Pao Chicken on your mysite? Users in most organizations I have seem struggle to come to terms with Sharepoint, even the basic functionality, now you would like to add COFUSION to the mix.. where do I go to see THIS document> On your MySite or On MY Mysite or the Department Site! Show me anything useful on my mysite, oh yeah hobbies, right? As I see, Wikis and Blogs do have some advantage, but MySite are an absolute FLUFF!]]>PungiFri, 10 Jun 2011 12:35:42 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-social-features-129866#commentsAnchorhttp://www.sqlmag.com/article/windows-sharepoint-services-30/sharepoint-2010-stacks-the-deck-with-improvements#commentsAnchorThu, 19 May 2011 14:09:33 GMT
I hate to break it to you, but RBS does NOT allow you to break the 2 GB file barrier in SharePoint 2010. It will theoretically allow you to store files bigger than that in SQL Server, but SharePoint seems to arbitrarily impose its own 2 GB file size limit, even if RBS is turned on on the back end. We looked into this for a company wanting to store raw video files up around 4-6 GB each, and while SQL Server would support it, SharePoint won’t. Not sure if SP1 might fix this problem, though. I’ll be interested to find out.]]>John GouldThu, 19 May 2011 14:09:33 GMThttp://www.sqlmag.com/article/windows-sharepoint-services-30/sharepoint-2010-stacks-the-deck-with-improvements#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-updates-136068#commentsAnchorMon, 09 May 2011 03:55:47 GMT
Hi Dan The Best Practice mentioned on the Updates for SharePoint 2010 page states "We recommend that you always install SharePoint Foundation 2010 patches before you install SharePoint Server 2010 patches. This best practice ensures that you will be successful when installing updates." yet you have stated to "only install the patch for the product youre running." Could you please elaborate? Thanks ]]>Mike AllenMon, 09 May 2011 03:55:47 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-2010-updates-136068#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/SharePoint-2010-Browser-and-App-Compatibility-125543#commentsAnchorMon, 18 Apr 2011 17:39:24 GMT
I had the same problem too with my internet explorer 9. But I later got it work when i used the Internet explorer(32-bit) instead of the 64-bit version]]>stazeraMon, 18 Apr 2011 17:39:24 GMThttp://www.sqlmag.com/article/sharepoint/SharePoint-2010-Browser-and-App-Compatibility-125543#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-birthday-community-and-career-news-137041#commentsAnchorSun, 17 Apr 2011 18:57:57 GMT
Congratulations, Dan. You picked a great company for your transistion and I’m glad to hear they will support your continuing contributions to the community. You’re right that the SharePoint community plays a large role in making SharePoint a successful product.

Ethan Wilansky]]>EthanWSun, 17 Apr 2011 18:57:57 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-birthday-community-and-career-news-137041#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-community-career-news-135809#commentsAnchorWed, 06 Apr 2011 17:15:14 GMT
Congrats Dan - sounds like a great move for you.]]>eririeWed, 06 Apr 2011 17:15:14 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-community-career-news-135809#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/riding-the-sharepoint-2010-product-wave#commentsAnchorWed, 02 Mar 2011 15:11:44 GMT
The 10 reasons why your CIO block social media http://www.buckleyplanet.com/2010/01/top-10-reasons-your-cio-blocks-social-media.html]]>Christian BuckleyWed, 02 Mar 2011 15:11:44 GMThttp://www.sqlmag.com/article/sharepoint/riding-the-sharepoint-2010-product-wave#commentsAnchorhttp://www.sqlmag.com/article/word/add-the-updated-style-to-the-template#commentsAnchorTue, 22 Feb 2011 09:47:07 GMT
I need help coding a drop down menu to appear on my master which contains a logo. Cann CSS supply the necessary formats I need to create a drop down menu
]]>MORTELLITITue, 22 Feb 2011 09:47:07 GMThttp://www.sqlmag.com/article/word/add-the-updated-style-to-the-template#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-rapid-application-development#commentsAnchorTue, 25 Jan 2011 10:58:48 GMT
you wrote " So I ate my own dog food, spun up a SharePoint server at GoDaddy, and got to work. " awesome.

Godaddy offering Sharepoint services? that really caught my eye. How much are you forking over and are you using it as an intranet site only or public facing site?


Thanks,]]>GravesTue, 25 Jan 2011 10:58:48 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-rapid-application-development#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-rapid-application-development#commentsAnchorWed, 19 Jan 2011 14:21:29 GMT
Hooray for SharePoint!!! Absolutely agree. Btw. you can have related lists, referenced by true foreign key lookups (like in databases, not with item ids) with SharePoint 2010 and 3rd party:

http://www.layer2.de/en/products/Pages/SharePoint-2010-Key-Value-Lookup-Column.aspx]]>DaskeWed, 19 Jan 2011 14:21:29 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-rapid-application-development#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-administration/implementing-folder-content-types#commentsAnchorWed, 12 Jan 2011 14:25:29 GMT
I would love to see the missing images as it is hard to follow the instructions without them.
]]>SuWed, 12 Jan 2011 14:25:29 GMThttp://www.sqlmag.com/article/sharepoint-administration/implementing-folder-content-types#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorFri, 07 Jan 2011 03:47:33 GMT
Third-party add-on that is focussed on Knowledge Management and Social Networking with SharePoint 2010:
http://www.layer2.de/en/products/Pages/Knowledge-Management-Suite-SharePoint-2010.aspx

The Knowledge Management Suite for Microsoft SharePoint 2010 encourage knowledge workers to take advantage of the new SharePoint 2010 Collaborative Knowledge Management and Social Networking features by making it as easy as possible to manage tags, to tag content and to use tags for knowledge browsing, navigation, content discovery and search.

E.g. with auto-tagger, taxonomy import/export, taxonomy-based navigation, dynamic related content etc. Just try it out.]]>DaskeFri, 07 Jan 2011 03:47:33 GMThttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorFri, 07 Jan 2011 03:44:29 GMT
Third-party add-on focussed on external data integration:
http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx

The BDLC conencts native SharePoint lists (no BDC/BCS) directly to any external data source with FULL list features available, e.g. workflows, managed metadata, attchments, foreign key references etc. Full write-back (CRUD) codeless, directly in web Browser in the list settings dialog. Shareware is FREE. ]]>DaskeFri, 07 Jan 2011 03:44:29 GMThttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/create-a-sharepoint-site-collection-with-windows-powershell-ui-style#commentsAnchorThu, 06 Jan 2011 15:52:00 GMT
I was told you can also assign a URL to a site collection Such that users that go to xx.yy.com will end on xx.yy.com/sites/zz (zz being the sitecollection) do you know how to do that?]]>GalThu, 06 Jan 2011 15:52:00 GMThttp://www.sqlmag.com/article/sharepoint/create-a-sharepoint-site-collection-with-windows-powershell-ui-style#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorWed, 05 Jan 2011 15:38:47 GMT
Thanks for Sharing this !
Similar information related to SharePoint 2010, can be found @ http://sanjeevsamala.blogspot.com/
]]>Sanjeev.SamalaWed, 05 Jan 2011 15:38:47 GMThttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorWed, 05 Jan 2011 15:37:29 GMT
Thanks for Sharing this !
Similar information related to SharePoint 2010, can be found @ http://sanjeevsamala.blogspot.com/
]]>Sanjeev.SamalaWed, 05 Jan 2011 15:37:29 GMThttp://www.sqlmag.com/article/sharepoint/what-you-need-from-sharepoint-your-turn-#commentsAnchorhttp://www.sqlmag.com/article/office/automating-office-2007-deployment-#commentsAnchorThu, 25 Nov 2010 11:18:13 GMT
I have the same issue, its a bit frustrating as the script would be great if it all worked. The script successfully removes computers from the staging group but doesn’t add them to the success or error group. All three groups have "SELF" "Write" "Member" permission. There is nothing in the event logs. Any update on this?]]>2Tall2Thu, 25 Nov 2010 11:18:13 GMThttp://www.sqlmag.com/article/office/automating-office-2007-deployment-#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-user-profile-synch-achilles-profile-part-2#commentsAnchorWed, 24 Nov 2010 13:02:51 GMT
Readers will find much more valuable information regarding the SharePoint User Profile Service here http://www.harbar.net/articles/sp2010ups.aspx
]]>MorrishWed, 24 Nov 2010 13:02:51 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-user-profile-synch-achilles-profile-part-2#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-influencers-and-attendees#commentsAnchorFri, 15 Oct 2010 17:18:32 GMT
Dan, LOVE that last tweet. For those of us out here writing/talking about planning and governance, we sometimes feel out of place with all the dev talk. But the King is naked, and we need to speak up. Failure to plan for SP is a plan to fail.]]>Christian BuckleyFri, 15 Oct 2010 17:18:32 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-influencers-and-attendees#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-development/top-10-best-practices-for-document-libraries#commentsAnchorThu, 07 Oct 2010 06:20:47 GMT
I think that adding the Title field to every view should be on this, this is an invaluable and often overlooked . Getting users to put in good titles greatly improves findability and search result presentation.]]>GrossThu, 07 Oct 2010 06:20:47 GMThttp://www.sqlmag.com/article/sharepoint-development/top-10-best-practices-for-document-libraries#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorThu, 30 Sep 2010 14:10:37 GMT
I have the same problem as Barkhouse. I have everything set up by the book and then the The Sharepoint Configuration Wizard failes unless I set the SPinstall-account to also have sysadmin rights in sql. With only dbcreator and securityadmin rights the database is created but then the "create table permission denied"-error occurs. I use SQL 2008 R2. Maybe best practice should be to have sysadmin rights during the creation of the configuration database and then to have the sysadmin rights removed...]]>JoskoThu, 30 Sep 2010 14:10:37 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/honored-to-be-recognized-as-a-top-50-influencer-137038#commentsAnchorThu, 23 Sep 2010 13:26:20 GMT
Dan, congratulations again! ]]>Derek E. WeeksThu, 23 Sep 2010 13:26:20 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/honored-to-be-recognized-as-a-top-50-influencer-137038#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/honored-to-be-recognized-as-a-top-50-influencer-137038#commentsAnchorWed, 22 Sep 2010 07:31:11 GMT
Dan, thanks for evangelizing SharePoint out there. I am doing my best to sell this extraordinary platform to potential users within my organization who can benefit from it. I always insist on the increased productivity levels that they would experience upon adopting SharePoint (no more shared folders, duplicate documents, and things like that), not to mention the associated metadata and other powerful features that come with the product.
I have been excited about the new features of SP 2010 (unfortunately there is not too much documentation out there yet). However, I have the opportunity to evaluate the product in a test server environment that a friend of mine put together for me and it really looks promising to an extent (I might be wrong, maybe it’s my lack of knowledge of it) but I observed a couple of details that Microsoft left unattended. 1) The user interface (aka the ribbon) was designed for developers, not for regular users; 2) To do simple things like removing "the recently changed documents or components" the regular user has to become a developer to understand a piece of code to be included in a CEWP to remove this annoying quick launch menu options (could’nt Microsoft just include this as a clickable option somewhere instead?). Again, I evangelize SharePoint, I have been doing it since its early versions 2003, 2007 and now 2010; However, Microsoft does not seem to get it yet! What it really counts at the end of the day, it is to empower the end user to do things with simplicity, if you really want to foster a collaboration environment. Thanks again for your efforts.]]>carlosmenesesWed, 22 Sep 2010 07:31:11 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/honored-to-be-recognized-as-a-top-50-influencer-137038#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/what-you-want-to-know-about-the-managed-metadata-service#commentsAnchorSun, 22 Aug 2010 08:14:09 GMT
Very nice article Dan. Nice breakout of specific points and liked the Q&A format.

Bert]]>KashSun, 22 Aug 2010 08:14:09 GMThttp://www.sqlmag.com/article/sharepoint/what-you-want-to-know-about-the-managed-metadata-service#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorFri, 20 Aug 2010 10:15:04 GMT
great article. I can’t seem to get the wizard to finsh only granting the setup account dbcreator and securityadmin (had to use sysadmin). Keep getting the error like "create table permission denied... content database" (paraphrasing).

Any ideas?]]>barkhouseFri, 20 Aug 2010 10:15:04 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorFri, 20 Aug 2010 10:09:14 GMT
great article. I can’t seem to get the wizard to finsh only granting the setup account dbcreator and securityadmin (had to use sysadmin). Keep getting the error like "create table permission denied... content database" (paraphrasing).

Any ideas?]]>barkhouseFri, 20 Aug 2010 10:09:14 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/SharePoint-2010-Browser-and-App-Compatibility-125543#commentsAnchorTue, 10 Aug 2010 20:55:52 GMT
Hi Dan: I enjoy always your articles. I hope you don’t mind the cross post, but I’ve been trying to figure out this problem on the msdn forums, and so far no traction.

I have a SPF server that I recently upgraded from WSS 3 using the database attach method. The new server configuration is SQL 2008 R2 with SPF 2010 on Windows 2008 64bit SP2. Mostly things are working fairly well, though there have been a few fires to put out. The latest inflamation seems to be centered around ActiveX controls for Office 2007. I’m getting the following message whenever I try to create a new document using the New button:

" ’New Document’ requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the ’Upload Document’ button."

On the client side, the browser is IE8 on Windows 7 (Windows is 64bit, though the browser is in 32 bit mode.) using Office 2007. I’ve also had the same problem with systems running XP.]]>LloydTue, 10 Aug 2010 20:55:52 GMThttp://www.sqlmag.com/article/sharepoint/SharePoint-2010-Browser-and-App-Compatibility-125543#commentsAnchorhttp://www.sqlmag.com/article/sharepoint-administration/sharepoint-goes-to-school-with-moodle#commentsAnchorWed, 04 Aug 2010 05:30:30 GMT
Hi Dan,
Thanks for the post - just found it on the internet now.

I’ve moved my blog - any change you can update the article?

http://blog.bfcnetworks.com
http://blog.bfcnetworks.com/posts/integrating-sharepoint-and-moodle-moodle-webparts-for-sharepoint-2007/
Cheers
Alex]]>Alex PearceWed, 04 Aug 2010 05:30:30 GMThttp://www.sqlmag.com/article/sharepoint-administration/sharepoint-goes-to-school-with-moodle#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorWed, 04 Aug 2010 03:07:03 GMT
Clarification from Dan:
The SP_Farm account *must* be a local Administrator for user profile synchronization service application provisioning to succeed. I wrote the article assuming (in my head) that this was for a pre-farm account "checklist" but I wasn’t clear about it. So:

1) You should add SP_Farm to local Administrators when you provision the user profile synchronization service application. The documentation from Microsoft about UPS deployment describes this.

2) After provisioning UPS you can and SHOULD take SP_FARM OUT OF LOCAL ADMINISTRATORS. If you don’t, you’ll get a warning in Central Admin from the health analyzer. That warning is correct. The privilege is needed only when initially deploying UPS.

3) If you don’t have SP_Farm in the local Administrators group, and you use the Farm Configuration Wizard with its default settings--which include provisioning UPS--it will fail and produce errors. Same reasons.

ALSO!!

There are updates to this article that go into the "remaining" accounts needed for least privilege. I will be publishing these updates in the coming weeks. If you’re in dire need of the information now, don’t hesitate to email me at danh -at- intelliem dot .]]>HolmeWed, 04 Aug 2010 03:07:03 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/windows-sharepoint-services-30/-i-m-not-dead-yet-#commentsAnchorTue, 13 Jul 2010 14:17:43 GMT
How do Sharepoint 2010 Remote Blobs factor into this? I assume that helps with the large file size issue?

Rich]]>Van AlstineTue, 13 Jul 2010 14:17:43 GMThttp://www.sqlmag.com/article/windows-sharepoint-services-30/-i-m-not-dead-yet-#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-is-so-last-month-and-scripted-configuration#commentsAnchorSun, 04 Jul 2010 20:41:06 GMT
Awesome thanks a lot!]]>SamuelSun, 04 Jul 2010 20:41:06 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-is-so-last-month-and-scripted-configuration#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/hiding-and-restricting-information-audiences-and-sharepoint-security#commentsAnchorWed, 23 Jun 2010 14:17:05 GMT
Thanks for the clear explanation - I need to go back and make sure we did not think we were securing something with an audiance instead of using permissions!]]>HeideckerWed, 23 Jun 2010 14:17:05 GMThttp://www.sqlmag.com/article/sharepoint/hiding-and-restricting-information-audiences-and-sharepoint-security#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorTue, 22 Jun 2010 08:02:48 GMT
For least privilege setup, I would recommend NOT placing the SPFARM account in the local administrators group on every server in the farm. Instead, only add it to the local administrators group on the application server that is going to run the profile sync service. Then provision the profile sync service. After you provision the profile sync service, remove the SPFARM account from the local administrators group on that server. That should work fine and follow least privilege.]]>Tue, 22 Jun 2010 08:02:48 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorMon, 21 Jun 2010 13:23:09 GMT
For least privilege setup, I would recommend NOT placing the SPFARM account in the local administrators group on every server in the farm. Instead, only add it to the local administrators group on the application server that is going to run the profile sync service. Then provision the profile sync service. After you provision the profile sync service, remove the SPFARM account from the local administrators group on that server. That should work fine and follow least privilege.]]>Joshua CliffMon, 21 Jun 2010 13:23:09 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorFri, 11 Jun 2010 12:28:36 GMT
As a SQL Server DBA and a great fan of SharePoint I find articles like this interesting. The impact on what is my day job (DBA) and my new love affair of SharePoint colliding together.
Perhaps one to remember for when the SharePoint Admins come wanting permissions to use PowerShell.]]>LangdonFri, 11 Jun 2010 12:28:36 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorFri, 14 May 2010 10:53:21 GMT
Not sure about making SP_Farm a local administrator. I actually *had* to do this (add it to the administrators group) to get the farm configuration wizard to complete without an error, but then sharepoint complains that you have a security violation (below). It would be nice to have this cleared up..

Sharepoint error:
Using highly-privileged accounts as application pool or as service identities poses a security risk to the farm, and could allow malicious code to execute. The following services are currently running as accounts in the machine Administrators group: SharePoint - 80 (Application Pool)
SharePoint Central Administration v4 (Application Pool)
OSearch14(Windows Service)
SPTimerV4(Windows Service)
WebAnalyticsService(Windows Service)
]]>PayneFri, 14 May 2010 10:53:21 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorWed, 28 Apr 2010 12:41:32 GMT
Most of this is unchanged from MOSS 2007 and shouldn’t be a surprise to anyone, including the Database/Farm account. Yes, it’s confusing, but it’s not new. See Plan for administrative and service accounts (Office SharePoint Server)
http://technet.microsoft.com/en-us/library/cc263445.aspx. The Word doc in that article describes all the accounts for MOSS 2007 least privilege scenarios and how each account is used (Office SharePoint Server security account requirements (http://go.microsoft.com/fwlink/?LinkID=92883&clcid=0x409)). For least privilege, the Database/Farm account should NOT be a member of the local admin group, so it really surprises me that this would be ok for least privilege in 2010.

If 2010 breaks the user profile synchronization, I agree that something needs to be fixed!

]]>SmithGreeneWed, 28 Apr 2010 12:41:32 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorWed, 28 Apr 2010 04:02:31 GMT
Hi Dan, i think the article fills an undocumented hole in new sharepoint 2010.

I am following it complete a clean install of moss2010 rtm, but i have a doubt.

when you say...

"Dont install SharePoint with your own administrative account!", what do you mean, with wich of three accounts i am supposed to do the installation? i’ve created the three of ’em, i also have a little concern about the setup of the sql account, will sql installation ask for this account? what if i don’t install sql and use the main sql shipped with moss2010, will i be prompted to type the account?

Thank you very much, i think you did a very good job with this post, but i would like to encourage you, to extend it in a step by step article so there’s no doubt on the steps to follow to deploy a nice brand new installation.

Thanks !!!]]>Wed, 28 Apr 2010 04:02:31 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorWed, 28 Apr 2010 04:02:22 GMT
Hi Dan, i think the article fills an undocumented hole in new sharepoint 2010.

I am following it complete a clean install of moss2010 rtm, but i have a doubt.

when you say...

"Dont install SharePoint with your own administrative account!", what do you mean, with wich of three accounts i am supposed to do the installation? i’ve created the three of ’em, i also have a little concern about the setup of the sql account, will sql installation ask for this account? what if i don’t install sql and use the main sql shipped with moss2010, will i be prompted to type the account?

Thank you very much, i think you did a very good job with this post, but i would like to encourage you, to extend it in a step by step article so there’s no doubt on the steps to follow to deploy a nice brand new installation.

Thanks !!!]]>Wed, 28 Apr 2010 04:02:22 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorWed, 28 Apr 2010 01:44:20 GMT
Hi Dan, i think the article fills an undocumented hole in new sharepoint 2010.

I am following it complete a clean install of moss2010 rtm, but i have a doubt.

when you say...

"Dont install SharePoint with your own administrative account!", what do you mean, with wich of three accounts i am supposed to do the installation? i’ve created the three of ’em, i also have a little concern about the setup of the sql account, will sql installation ask for this account? what if i don’t install sql and use the main sql shipped with moss2010, will i be prompted to type the account?

Thank you very much, i think you did a very good job with this post, but i would like to encourage you, to extend it in a step by step article so there’s no doubt on the steps to follow to deploy a nice brand new installation.

Thanks !!!]]>garesWed, 28 Apr 2010 01:44:20 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorTue, 27 Apr 2010 12:17:50 GMT
This is a very good description of the security needs for basic installation. However, with the name of the article, I had expected a more expanded view into using the principle of least priviledge with the service applications, much as we had done with the SSP services in MOSS2007. And since it has been, now, two weeks since this article was written and I still can’t find the "upcoming newsletter" with the pertinent information, I thought I woudl comment here to ask when that article is likely to be written? I’d like to see if I’ve covered all such things in my own installations.

Thanks.
SharePointKevin]]>HughesTue, 27 Apr 2010 12:17:50 GMThttp://www.sqlmag.com/article/sharepoint/Least-Privilege-Service-Accounts-for-SharePoint-2010-125062#commentsAnchorhttp://www.sqlmag.com/article/user-management-and-profiles/best-practices-for-managing-user-data-and-settings-part-1#commentsAnchorFri, 23 Apr 2010 09:04:18 GMT
Great article. But the referals to the figures are sadly missing. It would make some things clearer to understand. Rene.]]>René van BalenFri, 23 Apr 2010 09:04:18 GMThttp://www.sqlmag.com/article/user-management-and-profiles/best-practices-for-managing-user-data-and-settings-part-1#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorFri, 02 Apr 2010 09:21:53 GMT
It has been my expereince from working with customers that most will not allow the end user to run Powershell script on the SharePoint server.
For this reason, we are developing SharePoint 2010 administration enhancements will let users define actions and flows that will overcome these issues and add control to the process. Powershell was definitely a step in the right direction, but user and administrator tools are still needed for truly robust and mangeable sharepoint administration and governance. The beta of our DocAve Administartor tool for SharePoint 2010 is already up on the AvePoint website. We are looking forward to releasing some very innovative new tools to address exactly these issues very soon, so keep an eye out. ;)]]>LanniFri, 02 Apr 2010 09:21:53 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorThu, 01 Apr 2010 01:25:22 GMT
@Holme : Just for my information, I don’t get the point in using Powershell + Form instead of WebPart + SP OM ?
For people that know PowerShell I admit that it would be easier to use it for this kind of implementation (Form + Script), but I think this is not the purpose of this product. Even if I know PowerShell, I wouldn’t use it if my intention is to have a form that user will fill and this action will interact with SharePoint, I think it would be better to do this using WebPart + SP OM, no ?]]>Edgar MaucourantThu, 01 Apr 2010 01:25:22 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorWed, 31 Mar 2010 15:54:06 GMT
@Lapointe. Yeah, I agree, but what I imagined were scenarios where I would create a form (PS2.0 can do forms) that users could fill in, client side, that would magically generate or update content on the server, or scripts that a user could run (without modifying) that could let them manage users or synchronize a file share with a doc lib (something I’ve had to do at clients before). But you’re right, I don’t expect users to WRITE PS scripts! LOL *that* would be really scary.]]>HolmeWed, 31 Mar 2010 15:54:06 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorWed, 31 Mar 2010 15:29:30 GMT
Well maybe not end-users but still the trimming would have helped farm delegation. Sounds like another 3rd party product on the horizon! And why they are at it maybe they could put a gentler face on the myriad of commands and implictly scope their associative use. ]]>SandersonWed, 31 Mar 2010 15:29:30 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorhttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorWed, 31 Mar 2010 15:14:54 GMT
Honestly, PowerShell is complex enough that I can’t imagine many scenarios, if any, in which I would allow my end-users to run any kind of PowerShell - besides that fact that to run the script they’d have log into the server or I’d have to configure remoting which introduces a whole onslaught of other issues. If I really wanted to expose this kind of functionality I would create a custom action/application page/whatever which could run using the API and whatever credentials are necessary (the users or elevated). PowerShell is never going to be a tool for end-users - I hate using the word "never" but I think in this case it’s probably the most appropriate :)]]>LapointeWed, 31 Mar 2010 15:14:54 GMThttp://www.sqlmag.com/article/sharepoint/sharepoint-governance-disappointment#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/us-olympic-committee-passes-the-torch-to-sharepoint-2010-137031#commentsAnchorSat, 27 Mar 2010 19:09:41 GMT
Dan, have you come across the trial expiration in Beta 2 with the Olympic site? We are in the EAP with Microsoft and we’re using Beta 2 in production. It has expired though. I think the trial must be 180 days long. I haven’t found a fix yet. I’m trying to get a hold of you so I can warn you and also see if you’re already aware and if you found a fix.

Thanks so much,
Ryan]]>raverySat, 27 Mar 2010 19:09:41 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/us-olympic-committee-passes-the-torch-to-sharepoint-2010-137031#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-its-big-137008#commentsAnchorSun, 14 Mar 2010 18:37:48 GMT
Nice post. Thank you for the info. Keep it up.]]>srehmanSun, 14 Mar 2010 18:37:48 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-its-big-137008#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/what-an-it-pro-learned-from-working-at-the-olympics-137033#commentsAnchorFri, 12 Mar 2010 09:49:27 GMT
Dan, I work at Microsoft in IS Engineering as a Level 3 SharePoint Support Tech. As you know we get involved in most of the internal SharePoint Farms here at Microsoft. Anyway, in reading your article I was struck by a couple of things. First of all the perspective of leadership that you have embraced with regard to your SharePoint background. The points you make are so good that I think this could be required reading for most techs out there today. My uncle who just recently died was one of the great motivators of his day. His name is Paul J. Meyer. (http://www.pauljmeyer.com) He instilled just that kind of perspcetive in us which you are passing along in your article. The degree of excellence and passion in people’s work is normally no accident. It takes a winning attitude to succeed, and we are all born with the potential. But more specifically you have brought out a couple key points in what a winner does when they are focused and dedicated to their craft. It can be seen in the attitudes and working habits of techs everwhere. I feel truely blessed to be surrounded by the kind of talent and dedication I see here at Microsoft. I see people here every day who are "head down" working as hard as they can in becoming a subject matter expert and often succeeding well beyond that to becoming a wizard. In my a day the benchmark for a wizard was Jeff Beck. Enough said uh? Ok, and one final thought. You mentioned the two man bobsled. Well, as fate would have it, a gal I went to high school with named Wendy has a son who we have all been supporting on Facebook. He was in the 2 man and the 4 man USA bobsled team. Here is a link to his profile on the US Bobsled team site: http://bobsled.teamusa.org/athletes/nick-cunningham. How’s that for coincidence. Anyway, great great post. ]]>kcaravelliFri, 12 Mar 2010 09:49:27 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/what-an-it-pro-learned-from-working-at-the-olympics-137033#commentsAnchorhttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/what-an-it-pro-learned-from-working-at-the-olympics-137033#commentsAnchorTue, 02 Mar 2010 07:37:31 GMT
great article and valuable lessons for many aspects of life. Sounds like an amazing experience.]]>mdcamp00Tue, 02 Mar 2010 07:37:31 GMThttp://www.sqlmag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/what-an-it-pro-learned-from-working-at-the-olympics-137033#commentsAnchor