SQL
Moving SharePoint sites off the system drive – changing IIS virtual directories
A good practice is to move IIS off the system drive to another such as D: Ok, so you tell your Server guys but they miss out on an important step such as updating the registry to the new D:\inetpub… location. You dont check this since you think they know what they are doing and [...]
SharePoint 2010 database maintenance
This is a reminder for SharePoint Admins, DBAs and Developers to ensure that they have taken the necessary steps recommended by Microsoft when it comes down to SharePoint 2010 database maintenance. A few years ago, I posted out a similar ‘reminder’ for SharePoint (MOSS) 2007. http://www.jeremytaylor.net/2009/09/07/sharepoint-database-maintenance More recently, last year, Microsoft (Bill Baer and Bryan Porter) published [...]
Storage and SQL Server capacity planning and configuration for SharePoint Server 2010
Ever wondered if there is a formula for calculating content database sizes? Want to have a start into learning more about SQL design and database capacity planning for SharePoint 2010? Luckily, there is an awesome Technet document on SQL server design and capacity planning and it covers some great points to consider when planning your [...]
Is Microsoft SQL Server clustering supported on VMware?
When planning SharePoint environments in a fully virtualised environment, a very relevant (and appropriate) question to ask is… “Is Microsoft SQL Server clustering supported on VMware?” Its time to look at some links that I came across that might be handy for you in future. You could bookmark this page, so you can add it [...]
SharePoint High Availability (HA) Options – DR, SQL database mirroring, log shipping and clustering
Hey! I got a few requests to have this available online.. its a presentation file I put together on SharePoint 2010 High Availability options with SQL. Here is a link as promised to my presentation (pptx) on SharePoint 2010 High Availability Options. It covers some basics on Disaster Recovery, SQL database mirroring, log shipping and clustering [...]