The WorkerThread Blog

we know stuff so you don't have to

Archive for August, 2008

Data Mining in the Cloud

Posted by workerthread on August 27, 2008

Data Modeling Icons

I’ve mentioned Microsoft’s Data Mining site in a previous post – it’s well worth a look if you are interested in the Data Mining capabilities of SQL Server 2005 or 2008.  There’s good coverage of the excellent Excel Data Mining add-in for SQL Server 2005 and 2008 plus links to lots of good training material and Webcasts.  

In the past week they have also released a Data Mining in the Clouds sample.  This lets you try out many of the features that the Excel add-in gives you, but instead of connecting to your own Analysis Services server you connect to a Microsoft Cloud Service.  You can try it out in a browser by visiting this site, or there is an option to download a new Excel 2007 add-in specifically for connecting to the cloud service.

Posted in Business Intelligence, Office, SQL Server, web development | Comments Off on Data Mining in the Cloud

SharePoint and Paintball

Posted by workerthread on August 25, 2008

So apparently there is a National Professional Paintball League – and their web site is hosted on SharePoint!  Actually I also noticed that there’s an annual SharePoint MVP Paintball Outing at their Global Summit, maybe they should join the league 🙂 .

Technorati tags: , ,

Posted in Microsoft SharePoint, web development | Comments Off on SharePoint and Paintball

2009 For Office vNext?

Posted by workerthread on August 22, 2008

According to this post from Mary-Jo Foley, Office 14 will be in alpha testing before year-end (Office 2007 was previously known as Office 12, so they’re skipping unlucky Office 13).   Office 2007 has been around for a fair while now with a second service pack already in the works.  Many of my own clients are only just beginning to think about when and how (or even if) they move to 2007 – when budgets get tightened, it becomes very difficult to justify an upgrade of hundreds or thousands of desktop licences. 

For me, the two most compelling reasons for upgrading to Office 2007 are:

1. The tighter integration with SharePoint 2007 and Windows SharePoint Services 3.0 – if you are using or planning to use SharePoint, you will find a whole host of features in Office 2007 that make life easier, such as PowerPoint slide libraries, tighter Outlook integration, workflows, Excel publishing and much more.  For a detailed breakdown of how different versions of Office work with SharePoint, I would recommend downloading the Fair, Good, Better,Best white paper from Microsoft.

2. The Business Intelligence features in Excel 2007.  For a lot of users, this is the only client they will need to connect to and query Analysis Services cubes in SQL Server 2005/8.  And now there’s also the Data Mining Add-in for Excel 2007 which comes with lots of useful wizards for help with pattern and relationship discovery when working with large sets of data (if you regularly analyse large sets of data in Excel, I would definitely take a look at this – even if you don’t have access to an Analysis Services server you can try it out by running SQL Server Developer Edition on your desktop).

Back to Mary-Jo’s post, there’s one quote which shouldn’t be overlooked, particularly if you are planning your SharePoint implementation and thinking about future-proofing your investment – ‘Please note that Office “14” servers are 64-bit only’. Bear this in mind when you are setting up your SharePoint server farm!

Technorati tags: ,

Posted in Business Intelligence, Microsoft SharePoint, Office, SQL Server | Comments Off on 2009 For Office vNext?