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...

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 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...

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...

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...

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...