SQL Server Articles
It is nothing really new that indexes have their right to exist in SQL Server. It is also nothing really new, that these indexes need to be maintained every now and then, even though this might be surprising for people who are lulled by the otherwise low maintenance for SQL Server. But if you think […]
This article demonstrates how to monitor the usage of the various drives attached to a Windows Server installation.
I was recently asked to set up Transactional Replication comprising of 29 publishers as well as same number of subscribers. One interesting challenge was that the size of the distribution database suddenly increased from few MB’s to around 62 GB and as a result the disk on which the production database was hosted quickly filled […]
Despite Windows Server Backup being listed in Administrative Tools, the Windows Server Backup feature will still need to be installed, this article demonstrates how.
This article demonstrates how to monitor the processor usage on a Windows Server installation.
Demonstrates how to use SSL to improve your SharePoint site’s security.
Available memory is usually the most common source for performance issues on a Windows Server installation. Fortunately, however, it is an easy metric to measure since there are several counters in the memory object which can help troubleshoot memory issues.
SQL Azure Performance Tuning is a much tougher task than SQL Server since SQL Azure lacks some of the basic tools available to SQL Server DBA’s
A recent blog entry I read reminded me again that I wanted to rant about an issue in SQL Server for quite some time now… SQL Server 2005 introduced the separation between user and schema. Though schemata already existed before SQL Server 2005, they really became usable with this version, imho. At the same time […]
First introduced with SharePoint 2010, Resource Throttling allows the farm administrator to control the overall performance of a SharePoint farm.