SQL Alias for SharePoint

Technorati Tags: SharePoint 2013,SharePoint,SharePoint Foundation,SQL Alias Having SharePoint connect to a SQL Alias instead of the NetBIOS name is always a good idea. The main benefit is, if you ever have to switch the SQL Server or connect to a SQL Cluster VIP address, you just change the Alias to point to the SQL Cluster…


Automating SharePoint 2010 Administration with PowerShell: Renaming the Admin Content DB

If you don’t like the GUID that trails the Central Admin Content DB, you have 2 options, create the Farm with PowerShell / scripting and create the databases with names that you like OR if you already have a Farm, you can use the scripts below to change the Admin Content (Central Admin Content Database)….


Automating SharePoint 2010 Administration with PowerShell: Automating Central Admin Backup

SharePoint 2010 out-of-the-box doesn’t have the capability of scheduling a backup. Fortunately, we have the mix of PowerShell script and Windows Task Scheduler to do the job. In reality it’s just a single line script: Backup-SPFarm –Directory YourBackupDirectory –BackupMethod Full / Differential So what’s so special about this specific script? It sends you an email…


SharePoint 2010 Demo Virtual Machine

If you are a Microsoft Partner (or even a customer) and want to demo / Test  a SharePoint Solution and don’t want to spend days configuring your demo environment use the ready made VHD’s below: http://www.microsoft.com/downloads/details.aspx?FamilyID=751fa0d1-356c-4002-9c60-d539896c66ce&displaylang=en I use the a similar image everyday in my demos and they save me hours (at times even days!)…


SharePoint 2010 Version Comparison

Check out the version comparison at: http://sharepoint.microsoft.com/en-us/product/Pages/Features.aspx http://sharepoint.microsoft.com/en-us/buy/Pages/Editions-Comparison.aspx   This posting is provided "AS IS" with no warranties, and confers no rights.


Configure Remote Blob Storage (RBS) with FILESTREAM for SharePoint Foundation 2010

Ok, so i just finished configuring Remote Blob Storage with FILESTREAM for SharePoint Foundation. I hit a few glitches hence thought I will share the steps with you. First, why RBS?? For all of you guys who has WSS 3.0 running on Windows Internal Database, when you install SharePoint Foundation 2010, it installs SQL 2008…


SharePoint Foundation Install Error – SQL Server has an unsupported Version…

I just started an install of SharePoint Foundation and while running PSCONFIG hit an error stating that the SQL Server version 10.0.2531.0 is unsupported. Upon further investigation, I found out a rookie mistake:). My SQL 2008 was running SP1, however the minimum software requirement is 2008 with SP 1 and CU 2 or CU 5…


Exploring Business Connectivity Services (BCS) in SharePoint Foundation 2010

That’s right. It’s not a typo!! SharePoint Foundation 2010 now allows Business Connectivity Services that runs on BDC Technology. Read it yourself at – http://office2010.microsoft.com/en-us/sharepoint-foundation-help/what-s-new-in-microsoft-sharepoint-foundation-2010-HA010370062.aspx#_Toc257206748 This means that the feature which was only a part of Enterprise SKU and available to select few is now available to all and this is a huge Partner Service…