choirulamri.org

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 »

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 »

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 »

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 »

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 »

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 »

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 »