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

September, 2010

  • SQL Server High Availability: Technical Case Study

    The SQL CAT Team have just released another SQL Server High Availability case study. This time it is based on a Australian customer – Queensland Rail’s implementation of a geo-clustered SQL Server using Hitachi SANs with Truecopy. This infrastructure...
  • SQL Server 2008 SP2 Now Available

    Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center.  Service Pack 2 for SQL Server 2008 includes new compatibility...
  • Learning and getting trained to be a SQL Server DBA

    Time to time I get questions asked about training and learning more about SQL Server management, maintenance, best practices. As with every Microsoft product I say they are best learnt with hands on technique, that is to say get yourself a copy of the...
  • SQL Server Most Secure Database

    Let me say that again just in case you missed it, SQL Server is the most secure RDBMS. This is just not me saying, it is based on figures tracked by NIST, and the full details have been written up by a independent analyst. The full report can be accessed...
  • PowerPivot SharePoint Integration Install Bug

    I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I have on two occasions now come across the below error message:     Error: Your SQL Server 2008 R2 installation completed with failures.            ...