SharePoint 2013 – Export Index a la Crawl Log

I ran into an issue where I was replacing a competitor's search service.  I needed to provide validation that SharePoint indexed the same data and used the crawl log to get a list of all the items in SharePoint.  Here's the code: $ssa = Get-SPEnterpriseSearchServiceApplication $cl = New-Object Microsoft.Office.Server.Search.Administration.CrawlLog $ssa $cl.GetCrawledUrls($false,1000000,"",$false,-1,0,-1,[datetime]::minvalue,[datetime]::maxvalue) | export-csv -notype successes.csv…

3

Securing SharePoint: Harden SQL Server in SharePoint Environments

As more and more sensitive data is stored in SharePoint, we find ourselves with a new requirement: how do we secure SQL Server? Permissions and Site access are great, but the content still lives in the database and we need to insure SQL Server’s security is a first class citizen in our architecture. While we…

6

Move a Web Application to a new Application Pool

A colleague sent me a great question today: “Instead of consolidating application pools, how do I split up an application pool with too many web applications?” The answer is actually to modify the application pool properties of the Web Application; NOT create a new application pool and set the Web Application Property. Here’s the code:…

0

SharePoint 2007 Upgrade – Identifying Customizations

During an upgrade from SharePoint 2007 to 2010, knowing where custom webparts and features are deployed can be useful for targeted testing and mitigation. Here’s is some TSQL to help identify where those sites are. First, from SharePoint 2007, execute the PowerShell: ststadm -o enumallwebs -includewebparts -includefeatures -databasename WSS_Content_YourDBName > sp2007EnumWebsOutput.txt   This command essentially…

1

SSL Sites with Hostnames in SharePoint 2010 and SharePoint 2013

As you implement SharePoint in your security-conscious enterprise, you’ll run into a scalability issue: IIS 7.5 (Windows 2008 R2) requires dedicated IP addresses for each SSL site on each Web Front End. Remember that SAML claims require end-to-end SSL – if you’re using SAML, you’re affected! Why is this a problem? Consider the most basic…

1

SharePoint 2010 Architecture and Disaster Recovery – when to use UPRE and when to log ship

The SharePoint 2010 Database types and descriptions TechNet article was recently updated (March 5th, 2013) to allow log shipping the Profile and Social databases for the User Profile Service. This change aligns SharePoint 2010 to match the similar TechNet article for SharePoint 2013. To understand the change, it’s important to understand the tight correlation between…

1

Find all list items with multiple values used

  I was working with Russ today and an interesting question came up:  If a user had a list with a multivalue column, how do we find all the list items with more than 1 value selected?   After much trial and error, LINQ was the simplest to implement.  Here’s the list we used:  …

0

Hyper-V Slow Host Network – How to Fix

Last week I installed the latest version of Windows 8 RP;  I was really excited to see Hyper-V and a desktop OS together.  It’s been running great, but I noticed a peculiar issue:  whenever my VM-DC virtual machine (which hosts AD, DNS and DHCP) was running, my host DNS requests would creep and every request…

8

Database Attach breaks Alerts and the fix!

I got a query from a colleague about Alerts and went to test it.  To my surprise, my test Alerts weren’t working and after some troubleshooting I discovered it was due to my upgrade. The fix is pretty quick – just download the txt file, rename to PS1 and call it with the WebApp url. …

0

Post June 2011 CU Move-SPProfileManagedMetadataProperty BUG – and the workaround

If you’re upgrading from SharePoint 2010 and following the post upgrade steps from Perform post-upgrade steps for a database attach upgrade (SharePoint Server 2010), you’ll need to upgrade your multi string values from your old 2007 SSP to 2010 MMS.    Let’s have a little background on why we have this. Here’s a screenshot of…

1