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: Cleaning up Central Admin Backup with PowerShell

How about getting rid of all those Backups that has failed? They are just sitting there doing nothing useful anyway. Here is what my Backup and Restore History page looks like… What this gives me is a bunch of SPHistoryObject that have failed: $xmldata = (Get-Content ‘C:\SPBackup\spbrtoc.xml’) $xmldata.SPBackupRestoreHistory.SPHistoryObject | Where-Object {$_.SPErrorCount -gt ‘0’} Now let’s…


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…


Publishing Excel Services over the Internet using Kerberos Constrained Delegation

So here is a very common requirement – You have Excel Services connecting to a Cube and its working great in your network. Now you want to publish it to over the internet so that your Customers can access it. You want to ensure that your Cube Security takes precedence and don’t want to use…


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 2010 Public Beta available now…

SharePoint 2010 is now available as a public beta.. visit the links below and download them today!! Microsoft SharePoint Server Enterprise 2010 Beta – http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=3ed6e43b-22da-4021-8e90-56e47536d772 SharePoint Foundation 2010 – http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=906c9f5a-6505-4eba-bf24-95e423ac1703&utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MicrosoftDownloadCenter+%28Microsoft+Download+Center%29#tm Microsoft SharePoint Designer 2010 Beta (64-bit) – http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=eeda9ab1-ac53-4870-9e1c-38940343d677 Microsoft SharePoint Designer 2010 Beta (32-bit) – http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=82df15bd-16a5-460e-a7c4-22599c669bb1 Happy downloading. Priyo


SharePoint Foundation 2010… A simple install

No this blog is not dead… i must admit I was involved with wide variety of things and honestly speaking didn’t had any spare time to Blog…. its a lame excuse .. I know :-). However, I did explore a lot of stuff and learnt a lot as well.. i will be posting those shortly…