All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

December, 2009

  • SQL Server 2008 Enterprise and DW Optimisations

    One of the key areas for the SQL Server 2008 release is to be a scalable Data Warehousing platform. Many organisations have deployed it – with DW ranging from 1TB well into the 60-80TB. So what makes SQL Server 2008 Enterprise a better choice than SQL...
  • Really Scale with SQL Server 2008 R2

    You have no doubt heard that with SQL Server 2008 R2 and Windows Server 2008 R2 we can now address 256 processors. This is all good in theory – now see a video showing off some of the latest hardware from Unisys running pre-release versions of SQL Server...
  • SQL Server 2005 Users

    SQL Server 2005 SP2 support will be retired on the 12th January 2010. Now is a good time to start planning upgrades of applications to SQL Server 2005 SP3 or SQL Server 2008 (were possible). Link: http://support.microsoft.com/lifecycle/search/default...
  • Want to try PowerPivot for Excel 2010, but don’t have access to Excel 2010

    Well then follow the below link and you can launch an virtual lab that takes you through the PowerPivot add-in. The only thing you need to install is an ActiveX control to let you access the virtual lab environment. https://cmg.vlabcenter.com/default...