Category: Data Management

Spend your day in learning and training about – Leveraging SQL Server 2012 Features and Tools #sqlsat202 #sqlsatEdinburgh

TweetNothing in this world comes for free (or without any effort), quality comes with a price tag. But that is not entirely true in case of SQLSaturday event that is scheduled in Edinburgh, Scotland on 07th June 2013. As a…

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…

Packt’s new range of Microsoft Books Out Now!

TweetPakct Publishers has released a new range of books in Microsoft technologies, ranging from System Center to any other technology within Microsoft, check the attached links below to obtain a discount on these books too! Master the use of Microsoft…

Bookmark links – track SQL Server version from build numbers

TweetUntil SQL Server 2005 SP3 I used to remember the version from the build number of SQL Server, however since 2008 version it was hard to remember due to the fact of cumulative update package releases. Since the changes affected…

Data Management and Microsoft data platform – interesting facts


An interesting facts and fixtures about data management principles in using SQL Server product technologies.

(Source: PASS TV interview – )

 

Get Microsoft Silverlight

DCSIMG

 

SQL Server configration settings – MAXDOP, to be or not to be?

TweetAs a DBA parallelism or MAXDOP terms do not need any special introduction, but it is highlgy essential to keep up the necessary settings (default value is 0) on your data platform. In many cases MAXDOP helps to achieve optimization…