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

January, 2010

  • Think you are a Excel Guru? Why don’t you check for yourself

    We launched the Excelerators Quiz and the Alpha Geek Challenge. Go now to the sites below and take the quiz to see if you’re anywhere near as good as Donald Farmer!  Remember to post your results on Facebook and Twitter or even challenge a friend...
  • Time really flies when you have fun

    Well with a great product release like SQL Server 2008 and many many features like Geospatial support, data visualisation with reporting services, DW optimisations and many other bells and whistles; one can be kept busy for a long long time. And it only...
  • SQL Server Fast Track DW Seminar by HP

          .. SQL Server Webinar Microsoft SQL Server Fast Track Data Warehouse for Hewlett-Packard: Technical Overview and Reference Architecture This webinar is scheduled for Wednesday, January 13, 2010 11:00 AM Eastern/8:00 AM Pacific and...
  • TSQL Tips – Modifying text in rows

    I have been doing some loading of random text in tables, but wanted to make changes to some of the text in rows, instead of running a full update operation, I discovered that you can also use TSQL functions REPLACE or STUFF to change text. Below are examples...
  • Off Topic – but useful none the less – Win 7 Trick

    Even though this is not related to SQL Server, I thought I would share it, as we know SQL Server runs on top of a OS – and it is always handy to know how we can configure the OS. PRODUCTIVITY TIP Do you spend precious time trying to find the right place...
  • SQL Server Integration Services (SSIS) Best Practices

    I was recently just asked for some best practices on SSIS, and put together a collection of the below whitepapers/articles that discuss good practices for SSIS package design/development. · Top 10 SQL Server Integration Services Best Practices - http...