Category: Editions

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…

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…

Pay attention if you manage SQL Server 2000 and 2005 – Microsoft Security Bulletin MS12-060 – Critical QFE

TweetIt is very rare to see a hotfix or cumulative update for the product that is out of mainstream support (and soon out from extended support too). Also I don’t normally blog on a Sunday, but 1 email from MS…

SQL Server 2012 supported editions – simplified usage of locked pages in memory, required practices

TweetIn continuation to Memory tweaks for your 32-bit SQL Server data platform, mind the gap: Lock Pages in Memory post, as I referred there is a continuation to the process within SQL Server 2012 versions. There are certain restrictions and requirement on…

SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!

TweetAs of today the support for SQL Server 2005 Service Pack 3 ends, though the mainstream support for SQL Server 2005 was ended on 12th April 2011. This means only extended support is available for this version until 12th April 2016. Though there is…