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)