Category: Manageablity enhancements

Cumulative update package 9 for SQL Server 2008 Service Pack 3

TweetGet set for another installment of Cumulative Update package for SQL Server 2008 SP3 version. So with this CU9 for SQL2008 SP3, build number of the cumulative update package is 10.00.5829.00. Cumulative update package 9 for Microsoft SQL Server 2008 Service…

Port configuration for an Analysis Services cluster – How to change default listening port for SSAS 2012 service?

TweetYou may know how to configure the listening port for SQL Server database engine service, via SQL Server Program Group –> Configuration Tools –> SQL Server Configuration Manager by looking into protocols and choose TCP/IP. The port number can be…

DMVs – best of the bunch, troubleshoot your data platform like a pro

TweetHere is the presentation link that was delivered in SQL & Sharepoint Connections in Berchtesgaden, Germany back in May 2012.   http://sqlserver-qa.net/wp-content/uploads/2012/12/DMVs-Best-of-the-Bunch.-Troubleshoot-Your-Data-Platform-Like-a-Pro.pptx

What I like – SQL Server 2012 SP1 patch release

TweetAs of now (this post written date) the Service Pack1 for SQL Server 2012 still in CTP4 stage for your own testing on enhancements, which will be ready in next few weeks time as a full RTM’d downloadable package. During…

SQL Server Operability recipe – Handy list of PERFMON counters to capture IO stress testing results

Tweet  I treat Scalability and Performance like a two-side coin whenever the SQL Server operability consulting is involved. The Scalability and Performance is guaranteed when the reliable storage is configured at the hardware level. In general, the storage configuration and management…