Why is my transfer rate so slow when using "Open with Explorer"? - SharePoint

 

Always had this problem and now we have a fix…  uncheck Automatically Detect Settings in Internet Options – Lan Settings!

 

I'm logged in on my SharePoint 2010 server machine (running Windows Server 2008 R2) and using the "Open with Explorer" feature in a document library to copy another full directory from a separate server running as a file server into my document library. Our network is full 1Gbps and these two machines are sitting right next to one another separated by less than ten feet of Cat-6 cable, yet my transfer speed starts below 100kbps and slowly degrades over time. How do I fix this?

Why is my transfer rate so slow when using "Open with Explorer"? - SharePoint

Diagnostic logging in Sharepoint

How to turn on diagnostic logging in Sharepoint projects.
http://www.martinhatch.com/2010/05/vs-2010-rtm-and-sp-2010-rtm-deployment.html

Error Occurred in deployment step 'Add Solution': Value cannot be null. Parameter name: s

FAIL

So what on earth could be causing this error? Well, I stumbled across a registry edit that enabled diagnostics logging for SharePoint projects in VS 2010 (thanks to Glyn Clough for letting me know about it).

Enable Diagnostics Logging for SharePoint Projects in Visual Studio 2010
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\SharePointTools] "EnableDiagnostics"=dword:00000001

Warm up your SharePoint Web Applications on Windows 2008 R2 using the IIS 7.5 Application Warm-Up module | SharePoint George

For those requiring application warmups without writing painful scripts:

http://www.harbar.net/articles/apm.aspx – IIS 7 & IIS 7.5 Below.

With the introduction of IIS 7.5 and Windows 2008 R2 however, there is an actual module developed by the IIS team that will integrate directly with IIS allowing you to seamlessly enable your application pools to load your web applications after a recycle occurs.  You can download the extension here; http://www.iis.net/expand/ApplicationWarmUp At the time of this writing, the Application Warm-Up module is still in beta, but I have been using it on our production servers for over a month without any hiccups.

Warm up your SharePoint Web Applications on Windows 2008 R2 using the IIS 7.5 Application Warm-Up module | SharePoint George

SharePoint Reviews: The Power of SharePoint Web Services. Now in the Browser!

SharePoint Reviews: The Power of SharePoint Web Services. Now in the Browser!: "Sliced bread. Pocket on a shirt. Indoor plumbing. A thousand songs in your pocket. Yes, SPServices is that revolutionary.

If you have to use Javascript, you better be using jQuery. If you're using Sharepoint and Javascript, SPServices is another include you'll need.

List of SharePoint App Stores « T3chnicalLead

List of SharePoint App Stores « T3chnicalLead: "Here’s a list of the SharePoint ‘app stores’ I’ve come across in my travels"

Check out T3chnicalLead's list here.

Calculated Field Formulas

Calculated Field Formulas

For SPS Lists, here's the Calculated Field Formulas.

How come External Lists can't do this? Combining SQL tables with Sharepoint business logic could be a powerful tool.

Inspecting The SharePoint Content Database « Ethan's blog

Inspecting The SharePoint Content Database « Ethan's blog

Querying the Sharepoint Database without using the API is a don't - unless you decide to do it so here's the queries you need.

SQL access with integrated security from SharePoint - Code - eCraft Labs

Accessing databases using integrated security from  Sharepoint.

When creating custom webparts or other custom features in SharePoint that retrieves data from a SQL server, there are a few gotchas and pitfalls that you should be aware of. I spent a few hours battling a couple of problems, so I thought I’d document the things I found out here to spread the knowledge.

SQL access with integrated security from SharePoint - Code - eCraft Labs

Delivering Reports to a SharePoint Library

Publishing reports on a daily basis to Reporting Services is trivial with the Sharepoint delivery extension and Reporting Services.

More details:

SQL Server 2005 Reporting Services Service Pack 2 (SP2) includes a delivery extension that you can use to send a report to a SharePoint library. The delivery extension is installed and configured when you apply SP2.

To use the SharePoint delivery extension, you must create a subscription from an application page on a SharePoint site, and then select SharePoint document library as the delivery type. You cannot use the SharePoint delivery extension for subscriptions that you create in SQL Server Management Studio or Report Manager.

Delivering Reports to a SharePoint Library

Grant a Member the Right to Logon Locally

 
If you’re trying to work with Windows 2008 domain controllers, things have changed slightly (read-buried). Allowing a user to allow logon locally to the controller is a bit more complex than in 2003.

Grant a Member the Right to Logon Locally

Applies To: Windows Server 2008 R2

Domain controllers, by default, restrict the types of user accounts that have the ability to log on locally. By default, only members of the Account Operators, Administrators, Backup Operators, Print Operators, and Server Operators groups have the Allowed logon locally system right. If you want to grant a user account the ability to log on locally to a domain controller, you must either make that user a member of a group that already has the Allowed logon locally system right or grant the right to that user account.

Grant a Member the Right to Logon Locally