SQLAuthority News – Great Experience at SharePoint Conference Singapore 2013

Last week, I had great pleasure to present at SharePoint Conference Singapore . It was my second time visit to this event and I had a great time attending this event. The event had more than 900 attendees and it was moved to bigger and better location since the last time. As many of you know I usually present on the SQL Server Topic, however, I love pretty much every other technology equally great.

Presenting at SharePoint Conference Seattle

The audience at SharePoint conference is much different than the SQL Server Conference, however at the end everybody had a same goal – learn something new. I decided to present on the subject regarding how to improve SharePoint Performance in 60 Seconds. It was inspired from my SQL in Sixty Seconds Series.

Wonderful Event Attednees!

I had presented a total of 3 tips during the session. The tips were revolving around the best practices of the following database settings:

  • Auto-Growth and Pre-size Database
  • Auto Create and Auto Updated Statistics
  • Placement of Database and Log Files

Pluralsight Booth was busy all the time

Additionally we had played few quizzes during the session. I had decided to do something new this time. I had a total of 100 slides and 4 demonstrations planned in the short time of 60 minutes. I was able to manage my time well and finished the session in total of 59 minutes. The room was overflowing at the event and organizers had to extend the room capacity at the last moment.

Pinal Presenting at SharePoint Conference Singapore

I really appreciate the love and support demonstrated by the developers and admin at the Singapore event. I hope to see you Singapore very soon!

Jeff Ross and Pinal Dave at Pluralsight Booth

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore

Here are a few things that I hear very often: I already have a SharePoint administrator, and I don’t need a database expert.  Or, my database is already configured because we already have SharePoint installed on its default settings.  Or, Microsoft has told us not to touch the SharePoint database.  All these things may be partial or 100% true. The problem is that living your life, or administrating a database, according on one single thought is not good.  Technology is more advanced than that, and one single idea is not going to help your database move and evolve with the times.

Of course, SharePoint’s default settings are great, it has “best practices” to follow and they were well designed.  But some things are beyond the scope of SharePoint.  SharePoint does backup, and helps with performance tuning, but its maintenance is not accurate, and needs to be taken care of.

So question number one is: had Microsoft done the best job?  And do you understand what is going on with your server?  Well, I will be teaching a class at the SharePoint conference in Singapore on January 16, and this is exactly what I am going to address.  I am going to be giving a SharePoint Tips & Tricks in Singapore.  I guarantee that if you come to this session you will learn something so cool you can walk out the session and directly implement it.  So please, come to the conference.  I guarantee you will get amazing performance from your server.  I hope to see you in Singapore!

Session Details:

Title: Performance in 60 Seconds – Database Tricks Every SharePoint Developer & Admin MUST Know
Abstract: SharePoint Developers and System Administrators often come across situations where they face a slow server response, even though their hardware specifications are above  par. This session is for all the SharePoint Developers who want their server to perform at blazing fast speed but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation.
Date and Time: January 16, 2013 – 3:15 PM-4:15 PM
Location: Max Atria is located at Singapore Expo, 1 Expo Drive, Singapore Tel 65 6403 2160

This session will cover lots of interesting tips and tricks about SQL Server and SharePoint co-exists together. I promise that every attendee will walk out with a trick which they can walk out of session and directly apply to their production server to improve its performance.

Prizes, Giveaways and …

If you attend my session and participate in the conversation – I will bring 10 special gifts. This gift is not available in a Singapore and you will specially get it from me if you attend the session.  

Do leave a comment or send me email if you are going to the event, we can sit together and have a coffee.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Deployment guide for Microsoft SharePoint Foundation 2010

SharePoint and SQL Server both goes together – hands to hand. SharePoint installation is very interesting. At various organizations, the installation is very different and have various needs. SQL Server installation with SharePoint is equally important and I have often seen that it is being neglected.

Microsoft has published the Deployment Guide for SharePoint Foundation. It talks about various database aspects as well.

For optimal sharepoint installation the required version of SQL Server, including service packs and cumulative updates must be installed on the database server. The installation must include any additional features, such as SQL Analysis Services, and the appropriate SharePoint Foundation logins have to be added and configured. The database server must be hardened and, if it is required, databases must be created by the DBA.

Deployment guide for Microsoft SharePoint Foundation 2010

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – My Evaluation of Singapore SharePoint Conference

Earlier this year, I presented at SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore. It was an unforgettable experience to present at Singapore SharePoint Conference as I was the only SQL Speaker at the event. The event was filled with SharePoint enthusiasts and many other experts from all around the globe. The event was indeed one of the best organized events I have attended in subcontinent.

I just received my feedback score of the event. I was very much surprised and stunned and at the same time humbled. My rating are very high and also my demo was considered as one of the best demos of the whole event. I am not sure how much feedback I can share with the community as the organizer did not specify this to me, but I am quite certain that I am allowed to share my own feedback.

Speaker – 4.39 (best score 4.74, average 3.84)
Contents – 4.37 (best score 4.39, average 3.65)
Demo – 4.48 (best score, 4.48, average 3.61)

I am very glad that all of my efforts to conduct presentations at the SharePoint Conference finally paid up. I was apprehensive before my presentation on whether the attendees will accept me or not as I am a speaker of foreign technology to them and also an unfamiliar face at the event.

I must thank all of you for the support and encouragement.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore

Every SharePoint site runs on SQL Server and most of the SharePoint sites face issues with performance due to suboptimal configuration of underlying SQL Server. Recently, I presented a session on SharePoint and SQL Server Performance at Singapore on Oct 26-27, 2010. It was South East Asia SharePoint Conference, and I must say, the event was a blast!

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

This was very a unique event in Asian Sub-Continent and also one of the best managed conferences that I have attended thus far. The location of the event was very good, and the rooms were large enough to accommodate a huge crowd. Mike Fitzmaurice presented the keynote on the history of the amazing product and the factors that were involved in taking SharePoint to a 1st class Collaboration Platform. There were 42 sessions in 04 different tracks followed by the keynote and I noticed that all the sessions had the room brimming with crowd, and during some sessions, we even had people standing at the back of the room.

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

Besides delegates and speakers, the credit of this successful event goes to Debbie Ireland, Randy Williams and Steve Sofian. They had put in lot of efforts to make this event successful. Every single aspect was properly organized.

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

I presented a session on Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site!

My session was slightly different than my previous sessions. I started with a slightly pessimistic talk about how one cannot achieve many functionalities and performance aspects in SQL Server when SharePoint Server is installed. After this 2-minute talk, I explained why there are so many restrictions. Right after this, I demonstrated few concepts and ideas to attendees, which they could apply right away to their database and obtain the desired performance instantly. I promised the attendees that if they follow my suggestions right after they walk out of the session, they will surely achieve the desired performance of their SharePoint box instantly.

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

The details of the demo are as follows:

Demo 1: Importance of File Subsystem and Its Effect on Performance

In this demo, I had three various examples to be presented in front of the attendees. The examples enabled us to see various configuration options and optimal configuration for SQL Server data files and log files.

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

Demo 2: Importance of Filegrowth settings

Pre-configuration of the data files and filegrowth is usually ignored in default SharePoint installations. I explained this concept and tried to make it interesting for all the attendees.

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

Demo 3: Important of Statistics

Does Statistics matter for SharePoint as well? It does, and we noted the effect of Statistics on performance using this demo.

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site

I am delighted and very excited as I am going to attend very first time SharePoint Conference. Even though I will be attending SP conference, I will be presenting on my favorite subject – SQL Server Performance. Every SharePoint site runs on SQL Server and most of the SharePoint sites face issues with performance due to suboptimal configuration of underlying SQL Server.

This session will be very unique. I will be starting with a bit pessimistic talk about how one cannot many things in SQL Server when SharePoint Server is installed. I will go over in the details for the reasons for the same. Right after this 5 minutes I am going to show few things to attendees which they can apply right away to their database and instantly get the performance. I am going to share the easy scripts with them online right away and if they run the same on their SharePoint Database, they will get the performance right out of the box right away – I Promise!

As I have never presented in SharePoint conference, I have practiced really well with this session. I have created three very interesting demo. I have kept the idea in mind that everybody who is going to attend the session of mine are not going to be database expert they will be SharePoint experts and will be expecting to learn something which they can apply to their SharePoint database easily. All the scripts will be solid and I promise that they will only affect positively to your server.

I will be presenting on Day of the event. Here are the details.

South East Asia SharePoint Conference – Oct 26-27, 2010
Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site!
Date: Oct 27, 2010
Time: 1:30 PM
Venue: Grand Copthorne Waterfront Hotel

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010

Just a day ago, I was asked how do you plan SQL Server Storage Capacity. Here is the excellent article published by Microsoft regarding SQL Server capacity planning for SharePoint 2010. This article touches all the vital areas of this subject. Here are the bullet points for the same.

  • Gather storage and SQL Server space and I/O requirements
  • Choose SQL Server version and edition
  • Design storage architecture based on capacity and IO requirements
  • Determine memory requirements
  • Understand network topology requirements
  • Configure SQL Server
  • Validate storage performance and reliability

Read the original article published by Microsoft here: Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010.

The question to all the SharePoint developers and administrator that if they use the whitepapers and articles to decide the capacity or they just start with application and as they progress they plan the storage? Please let me know your opinion.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQL SERVER – Sharepoint Resource Available for SQL Server

Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from Microsoft.

External Collaboration Toolkit for SharePoint
This solution allows users to create collaboration environments that use the familiar SharePoito deploy a SharePoint-based environment for collaboration with people outside your firewall. The accelerator allows users to create collaboration environments that use the familiar SharePoint interface. Because the solution is easy to use, end users are more likely to use it rather than revert to e-mail.

SQL Server Reporting Services Add-in for SharePoint Technologies
The Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

Microsoft SQL Server 2008 Reporting Services August 2009 CTP Add-In For Microsoft Sharepoint Technologies
The Microsoft® SQL Server® 2008 Reporting Services August CTP Add-in for Microsoft SharePoint® Products allows you to take advantage of new SQL Server 2008 R2 Reporting Services report processing and management capabilities in SharePoint integrated mode.

High Availability of SharePoint Server Using Virtualized Environments and Database Mirroring
This paper highlights the lessons learned from a proof of concept configuration of Microsoft Office SharePoint Server 2007 across two data centers that included database mirroring.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site

SharePoint is one interesting software from Microsoft. My outsourcing location unit is working on one large project of SharePoint. Based on users feedback and overwhelming response to article SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name I am posting one more article which is very important for SharePoint developers.

SharePoint does not allow custom coding for any of the webpart. It is possible to create webpart in Visual Studio and integrate it with SharePoint. The process to create webpart in .NET framework and make it working in SharePoint often fails due to lack of guidance about this subject on internet. Software developer Rashmika and Dhruval has extensively worked in this subject and helped me to create this tutorial.

1. First of all we need to create a webpart in visual studio (2005,2008). For that, Go to File>> New>>Project.

2. Under Templates section select WebPart (this option is available only in 2008). For VS 2005, select Class Library and add reference for System.Web.

3. Write code WebPart you want to create. Here, code is written for a label having text “Hello World”.

using System;
using System.Runtime.InteropServices;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Serialization;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;
namespace CustomWebPart
public class WebPart1 : System.Web.UI.WebControls.WebParts.WebPart
public WebPart1()
protected override void CreateChildControls()
Label label = new Label();
label.Text = “Hello World”;

4. Now, Buid Webpart and generate an assembly for this webpart. For that GoTo>>Build>>Build Solution. And the GoTo>>Build>>CustomWebPart.

The WebPart is now Build, we need to deploy this assembly in sharepoint site. For deploying webpart we need to perform following steps.

5. Put the assembly in the bin folder of sharepoint site. The MOSS 2007 creates every portal in the inetpub\wwwroot\wss folder. To find the path of bin folder of the portal for which you want to deploy the webpart, identified with port number, run inetmgr(IIS).

Right Click the portal and click on Properties

6. Under HomeDirectory tab, Local Path describes the whole path, copy the path and verify it by opening it in a browser and see if the bin folder exists, if it does not exist then create a new folder and rename it bin.

7. Now copy the assembly from project output folder.

C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\CustomWebPart\CustomWebPart\bin\Debug.

Paste it in the portal bin folder. C:\Inetpub\wwwroot\wss\VirtualDirectories\80\bin

Now everytime we change the webpart we need to copy and paste the assembly in portal bin folder. Hence to avoid this stuff we can do the following step which will automatically replace the new assembly in the portal bin folder.

8. In VS .Net, Solution Explorer, Right Click the project name(CustomWebPart) Click on Properties, click on Build. Into the Output Path paste the path which we copied from inetmgr console.

9. Now to make the webpart usable we need to modify the web.config file of the portal. To declare the control safe we need to add a <safecontrols> entry in web.config file.

10. For <safecontrols> tag we require a parameter “PublicTokenKey” to generate this key drag the assembly from project folder and drop it in C:/Windows/assembly folder and it will generate a publictokenkey.

Right Click on CustomWebPart and copy Public Key Token.

Open web.config file and enter the following text :

<SafeControl Assembly=“CustomWebPart, Version=,
Culture=neutral, PublicKeyToken=9f4da00116c38ec5″

Namespace=“CustomWebPart” TypeName=“*” Safe=“True”
AllowRemoteDesigner=“True” />


11. Now we need to Configure Portal to use CustomWebPart.

Till now the web part has been created and deployed to the site directory. Now the next part is how to use the web part on the Portal’s Site. The web part created can be placed on any site of the portal.

Open the portal site in the internet explorer, in my case its http://win2003, ensure that the logged in user has the administrative rights on the portal site, else it will not allow adding the web part.

12. Click on the Site Action>>Site Settings

13. On the site settings page under Galleries column click on the Web Parts.

14. On the Web Part Gallery Page click on the New button, to add the new web part assembly to the gallery.

15. On the New Web Parts page locate the CustomWebPart in the list, check the check box on the left and click on the Populate Gallery button the top of the page. This will result in the Web Part entry creation in the Web Part Gallery list, and hence it can be used from now on from the gallery.

Now the Web Part is ready to be added to the page.

16. Open a site created in the Portal. Click on Site Action>>Edit Page

17. This will modify the appearance of the page to enable the edit view. In this view Web Part Zones are highlighted so that a user can add a web part to the zone, Click on the Add a Web Part button in the left zone to add the Web Part.

18. Select the CustomWebPart from the web part list . It is found under the Miscellaneous section and then click on Add.

19. Click on the Exit Edit Mode link on the page and the site will return to the view mode.

20. At the end the page will appear like this.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name

If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together on same physical server, changing the name of the server (computer) using operating system may create non-functional SharePoint website.

When you change the physical server name the SharePoint is already connected to the SQL instance of old computer name (OldServerName/SQLInstance) and on changing the name the SharePoint will not able to connect the SQL Server  as now the SQL Server instance will run on new computer name (NewServerName/SQLInstance).

To solve this problem you need to reconfigure the entire Microsoft Office SharePoint Server with SQL Server Instance. Please follow the steps to fix the issue.

1. Open command prompt, change directory to where stsadm.exe exists.

C:\cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

2. To invoke setconfigdb operation we need to use stsadm.exe. Run following command on command prompt

stsadm.exe -o setconfigdb -databaseserver ServerName -farmuser MyUserName – farmpassword MyPassword

3. Go to IIS, All Programs>>Administrative Tools>>Internet Information Service (IIS) Manager.

4. Right Click SharePoint Central Administration v3, click on delete and re-run the configuration wizard; the web application will be re-created by the configuration wizard.

5. After the above operation has completed successfully, run the SharePoint Products and Technologies Configuration Wizard.

All Programs>>Microsoft Office Server >> SharePoint Product and Technologies Configuration Wizard

6. Complete all the steps of wizard by clicking on Next button.

At the end of this process you will get a success wizard.

On completion of this whole procedure Microsoft Office SharePoint Server gets connected to the database with new Computer Name.

Reference : Pinal Dave (http://blog.SQLAuthority.com)