What is The Best SQL Resources on Internet?

By
January 3, 2012

Well, I always receive this question again and again, specially when delivering talks on technical communities. Veteran DBAs may just simply doing bing or googling, most of newbie find themsselves overwhelmed by tons of info from the net. Let me share my favourite site that I always visit regularly:   SQLServerCentral I subscribe to their newsletter since 2001, and never get bored since then. I even wrote 2 aqrticles for them, but now I just do ot have enough time anymore. This is the biggest SQL articles repository in the net, with very active community. SQL MVPs Brian Knight,...
Read More »

Resources on Capacity and IO Planning

By
November 22, 2011

I am posting some collection of links and resources related with capacity planning, plan for performance, and IO planning. This is also a kind of note to self, so it will be easier for me to find out those links in the future .   Estimating the Size of a Clustered Index http://msdn.microsoft.com/en-us/library/ms178085.aspx Estimating the Size of a Database http://msdn.microsoft.com/en-us/library/ms187445.aspx> Proper I/O Capacity Planning and Configuration Resources for SQL Server http://blogs.msdn.com/b/askjay/archive/2011/03/25/proper-i-o-capacity-planning-and-configuration-resources-for-sql-server.aspx Predeployment I/O Best Practices http://technet.microsoft.com/en-us/library/cc966412.aspx Physical Database Storage Design http://technet.microsoft.com/en-us/library/cc966414.aspx Storage and SQL Server capacity planning and configuration http://technet.microsoft.com/en-us/library/cc298801.aspx Storage Performance Testing with SQLIO http://www.brentozar.com/archive/2008/11/storage-performance-testing-with-sqlio/ SQLIO Tutorial: How...
Read More »

Tuning SQL Server for SharePoint Performance

By
October 31, 2011

I had an opportunity to present on SQL Server User Group Indonesia monthly meeting on Oct 27, 2011 about SQL performance tuning from SharePoint perspective. Most of DBAs might be familiar with SQL stuff, but not on what SharePoint expects from SQL Server. Understanding how SharePoint works is really important in tuning SQL Server. Most of the SharePoint contents are stored in SQL Server. Documents, picture, pages, Lists, and its configuration. Document and picture are stored as binary in SQL, so do not expect to find the physical files in SharePoint server. Most of physical files that are not...
Read More »

KPI Report with Reporting Services 2008 R2

By
November 1, 2010

There is a new gem in SQL Server 2008 R2: Indicator control. It enables us to create KPI style report in easy way. You may ask how is it difference with Gauges that already exists in SQL Server 2008? Well, Gauges is cool by displaying speedometer style indicator. But sometime they are just too much. I don’t want the fancy circle style, instead I want it to be a simple traffic light or dot indicator like this: If you are a Reporting Services veteran then you know what to do: upload couple of traffic light symbols and bind them...
Read More »

Practical SQL Performance Troubleshooting

By
August 21, 2010

DBA daily life is always hectic. They receive many issues ranging from network, performance, security, or application. I had collected many scripts and tools since couple of years ago. They are very useful for ad-hoc troubleshooting and diagnose the problem on the spot. When I mentioned ad-hoc means the ability to locate and diagnose the problem quickly, without collecting data with SQL Profiler or Perfmon. I’m not saying that ad-hoc approach is better, but there are many situations when we just do not have enough time to collect the data while my users are screaming. The DMVs become handy...
Read More »

Tuning SQL Server for SharePoint Performance

By
October 31, 2011

I had an opportunity to present on SQL Server User Group Indonesia monthly meeting on Oct 27, 2011 about SQL performance tuning from SharePoint perspective. Most of DBAs might be familiar with SQL stuff, but not on what SharePoint expects from SQL Server. Understanding how SharePoint works is really important in tuning SQL Server. Most of the SharePoint contents are stored in SQL Server. Documents, picture, pages, Lists, and...
Read More »

Sharepoint – Reporting Services Integration

By
May 30, 2009

I did presentation for MaxIT event on May 29, 2009 and one of the interesting discussion was SharePoint integration with Reporting Services. I know that SharePoint is hot here in Singapore. I also did demo on some new features of SSRS 2008 such as tablix and charting. My presentation slide can be downloaded here: There are several advantages of integrating SSRS with...
Read More »

Running SharePoint on Windows 7

By
January 28, 2009

I know that running SharePoint on Vista or Windows 7 is not for production, but as a developer I need a handy tool for coding and testing instead of VPC or VMWare. Well, installing SharePoint on Windows 7 is not officially supported, but if you are a geek enthusiast, here are the steps: First, prepare IIS 7 for ASP.NET component. I configured the following components in my Win 7: Read More »

Slide Deck and Demo on SharePoint + Silverlight

By
December 15, 2008

Technorati Tags: Silverlight,Sharepoint This is a quick post for my presentation slide and demos at SharePoint Pro Singapore User Group Meeting last week. I discussed about configuration on SharePoint box to make it Silverlight enabled, and also giving some demos to write Silverlight video player then deploy it to SharePoint. The PPT and demos are available for download from my Skydrive. Enjoy!
Read More »